Excel Advanced 1: Make Quick Work of Complex Tasks
Class Details
Length of class: three hours
Price per person: $149
Version covered: for Office 365
Description
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
Protecting and Sharing Excel Workbooks
- protect cells
- protext sheets
- share a workbook
- restore a workbook using version history
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
Using Cell Styles
- applying styles
- modifying styles
- defining custom styles
- importing styles from another workbook
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
Upcoming Dates
Mon, Nov 16, 2026
12:00 PM - 3:00 PM
Mon, Jan 4, 2027
12:00 PM - 3:00 PM