Excel Power User Module 3: Six Critical Excel Functions (2 hours) [NT] – On-Demand Webcast

Overview

Explore six important Excel functions that enable us to automate a variety of tasks, as well as continue to integrate these functions as we proceed throughout the series. This is part 3 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

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

Excel Power User Modules 2 or knowledge of the topics covered

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.

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!