Excel – Level 3

Description

Overview:

This course builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel including lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Prerequisite(s):

Excel Level 2

Audience:

Outline:

Lesson 1: Logical and Lookup Functions

• Decision-making functions
• Lookup and reference functions

Lesson 2: Advanced Formulas

• Auditing and error-trapping
• Formula options
• Arrays

Lesson 3: Special functions

• Date and time functions
• Text functions
• Other functions

Lesson 4: Importing and Exporting

• The Power Pivot Data Model
• Exporting data

Lesson 5: Analysis

• What-if analysis
• The Analysis Toolpak

Lesson 6: Macros and Forms

• Recording macros
• Running macros
• Forms

Internationalization and Accessibility

• Preparing workbooks for internationalization and accessibility