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