Excel Advanced 1: Automating Tasks

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros.

Prerequisites

This class is ideally suited for people who have taken the Intermediate Excel classes or have at least two years of experience using Excel.

Outline

Working on Multiple Sheets Simultaneously

• selecting ranges of worksheets
• selecting non-contiguous worksheets
• making changes to multiple worksheets
• getting out of Group mode
• writing formulas that link to cells on multiple sheets

Performing "What If" Analysis

• using Goal Seek to find optimum solutions
• storing multiple scenarios in Scenario Manager
• switching between scenarios
• generating a scenario summary sheet
• creating one- and two-input data tables

Advanced Conditional Formatting

• apply conditional formatting rules
• using formulas in conditional formatting

Recording Macros

• recording new macros
• deciding where to store a macro
• determining which referencing mode to use
• recording macros
• running macros
• editing macros
• assigning macros to custom buttons on the Ribbon
• renaming and deleting macros