Excel Functions and Formulas FLEXCAST

Overview

In this course, 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 want 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. This course will teach you over two dozen of Excel’s most useful functions that you will be able to apply at your practice.

Highlights

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

Prerequisites

None.

Designed For

Anyone interested in elevating their Excel skills.

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.