Excel Formulas and Functions (CPE Course)

CPE Credit: 2.5 hours

Course Type: Downloaded PDF materials with online test

Price (with PDF Textbook): $30

Excel Formulas and Functions Thumbnail.jpg

Course Description
Excel is an essential spreadsheet tool for the accountant. To wring the greatest possible use from it, one should have a detailed understanding of how to use formulas and functions. In the Excel Formulas and Functions course, we discuss the mechanics of constructing formulas and how to use many of the functions that apply to common business problems, such as net present value analysis, using date calculations, and calculating depreciation. The course also covers how to create error-free worksheets. (Note: This course is based on the desktop version of Excel 2019, but its contents are generally applicable to the users of earlier versions of Excel)

Author: Steven Bragg

Course Number: SP1014

Learning Objectives

  • Explain the nature of the Excel ribbon system.

  • Describe the contents of a formula.

  • Identify the precedence rules for the various Excel operators.

  • Specify how nesting can be used to override operator precedence rules.

  • Describe the range of available date and time functions within Excel.

  • Explain when cell references should be designated as relative, absolute, or mixed.

  • Describe the range of available counting functions within Excel.

  • Identify the types of functions that can be used to manipulate text within Excel.

  • Specify the underlying computational structure used by Excel to calculate dates and times.

  • Identify the functions used for conditional calculations, and how they are applied.

  • Identify the types of descriptive statistics functions that can be applied to data in Excel.

  • Describe the techniques used to clean up data within a worksheet.

  • Specify the review methods available for examining the formulas within a worksheet.

Level: Overview

Instructional Method: QAS Self-Study

NASBA Category: Computer Software & Applications

Prerequisites: Basic knowledge of Excel.

Advance Preparation: None

Latest Review Date: March 2023

Program Registration Requirements: Click on "Purchase Course" near the top of this page to pay for and access the course. You will then be able to download the course as a PDF file, then take an on-line examination, and then download a certificate of completion if you pass the examination.

Program Refund Policy: For more information regarding administrative policies concerning complaints, refunds, and other matters, see our policies page.

CPE-Sponsor-Logo.jpg

AccountingTools, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

The NASBA sponsor identification number for Accountingtools, Inc. is 115881.

AccountingTools is an IRS Approved Continuing Education Provider. We are compliant with the requirements for continuing education providers (as described in sections 10.6 and 10.9 of the Department of Treasury’s Circular No. 230 and in other IRS guidance, forms, and instructions). Our IRS Approved Continuing Education Provider number is 72821.