Class Outline

This one-day, instructor-led course will teach you the advanced tools to perform more complex tasks in Microsoft® Excel. By the end of this course, you will be able to use macros to automate repetitive tasks and what-if analysis to analyze data.  You will learn how to validate your data to ensure the data in your workbook is appropriate, and how to perform advanced importing, exporting, and linking.  You will learn how to create custom lists and custom views and move on to learn the Quick Analysis features which ensures efficiency while working in this application.

The training covers these topics:

Macros in Excel

  • Recording a Macro
  • Running a Macro
  • Saving a Macro Enabled File

WHAT IF Analysis

  • The Solver Add-In
  • Goal Seek
  • Scenario Manager
  • Correlation
  • Histogram

Data Validation

  • Validating Data on a Worksheet
  • Using Data Validation to Create a List
  • Using a Dropdown List with Conditional Formatting

Advanced Importing and Linking

  • Importing from a Database
  • Exporting to PDF
  • Importing a Text File

Custom Lists and Views

  • Creating a Custom List
  • Creating a Custom View

Quick Data Analysis

  • Quick Analysis Charts
  • Quick Analysis Totals
  • Quick Analysis Tables