Excel Formulas and Functions FLEXCAST
Available Until
Your Desk
2.0 Credits
Member Price $98.00
Non-Member Price $113.00
Overview
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.
Highlights
The worksheet ribbon. Common mathematical operations. Text manipulation formulas. Date and time formulas. Conditional analysis formulas. Financial analysis formulas. Conditional formatting. Formula error elimination.
Prerequisites
None.
Designed For
CPAs, CEOs, CFPs, and other accounting professionals
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.
Preparation
None.
Notice
This is a FlexCast (no exam required) and may be viewed only Monday - Saturday, 5am - 5pm PT. You may take up to one year from the date of purchase to complete the course. Pause your FlexCast and resume at a convenient day during the hours above. Partial credit for 2+ credit courses: If you are unable to complete the course in one sitting, partial credit can be awarded (minimum of one credit). To earn the remaining credits, you must return later and start the course from the beginning. Use chat to ask questions of a subject matter expert during the program.
Leader(s):
Leader Bios
Steven Bragg, Western CPE
Steven M. Bragg, CPA, is a full-time book and course author who has written more than 70 business books. He provides Western CPE with self-study courses in the areas of accounting and finance, with an emphasis on the practical application of accounting standards and management techniques. A sampling of his courses include the The New Controller Guidebook, The GAAP Guidebook, Accountants’ Guidebook, and Closing the Books: An Accountant’s Guide. He also manages the Accounting Best Practices podcast.
Steven has been the CFO or controller of both public and private companies and has been a consulting manager with Ernst & Young and an auditor with Deloitte & Touche. He holds an MBA from Babson College, a Master of Finance from Bentley College, and a BA from the University of Maine (summa cum laude).
Non-Member Price $113.00
Member Price $98.00