Excel Power User Module 3: Six Critical Excel Functions ON DEMAND

Overview

Explore six important Excel functions that enable us to automate a variety of tasks, as well as continue to integrate these functions.

Highlights

Conditional summing basics with SUMIFS. Remove duplicates. Lookup basics. Improving VLOOKUP with MATCH. Improving VLOOKUP with VALUE and TEXT. Moving beyond VLOOKUP with INDEX.

Prerequisites

None.

Designed For

Accounting professionals that use Excel for Windows.

Objectives

Identify the keyboard shortcut for evaluating formula text. Recall the arguments for the SUMIFS function. Recognize the Excel feature that removes duplicate values within a range.

Preparation

None.

Notice

None.