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.
Learning Objectives
Upon successful completion of this course, participants will be able to:
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.
Major Topics
The Worksheet Ribbon
Common Mathematical Operations
Text Manipulation Formulas
Date and Time Formulas
Conditional Analysis Formulas
Financial Analysis Formulas
Conditional Formatting
Formula Error Elimination
