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 VBA macros to automate tasks.
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
