Excel Functions and Formulas FLEXCAST

Overview

In this step-by-step Microsoft Excel tutorial, you’ll get a hands-on walkthrough of the most common formulas and functions used by Excel power users. This course is perfect for beginners who are brand new to formulas and functions, as well as more advanced users who are still likely to pick up a few new tricks. The course includes an additional interactive Excel workbook. It opens with a survey of basic functions and references, as well as the fundamentals of using them. From there, it expands to cover over two dozen of Excel’s most useful functions.

Highlights

The most common formulas and functions used by Excel power users.

Prerequisites

None.

Designed For

CPAs.

Objectives

Create and edit formulas in Excel. Reference cells via absolute references as well as cells on other sheets. Use fundamental Excel formulas and functions, including logical functions. Understand XLOOKUP and VLOOKUP.

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.