Skip to main content

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

Available Until

Your Desk

2.0 Credits

Member Price $69.00

Non-Member Price $89.00

Overview

Explore six important Excel functions that enable us to automate a variety of tasks.

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.

Non-Member Price $89.00

Member Price $69.00