Excel Lookups, Functions, and Macros Course

Take your Microsoft Excel skills to new heights with our Excel Lookups, Functions, and Macros course, which continues where the Excel Intermediate class left off. As a result, you will accomplish more by taking full advantage of Excel's power: more powerful calculations with advanced functions, more time saved with automated routines using macros, and more successful data visualizations.

Prerequisites:

  • Excel Intermediate or the equivalent in work experience.

Logical and Lookup Functions

  • Decision-Making Functions
  • Lookkup and Reference Functions

Advanced Formulas

  • Auditing And Error-Trapping
  • Formula Options

Special Functions

  • Date And Time Functions
  • Text Functions
  • Other Functions

Importing And Exporting

  • The Power Pivot Data Model
  • Exploring Data

Analysis

  • What-If Analysis
  • The Analysis Toolpak

Macros And Forms

  • Recording Macros
  • Running Macros
  • Forms

Internationalization And Accessibility

  • Preparing Workbooks For Internationalization And Accessibility

Excel Lookups, Functions, and Macros courses are offered at these locations: