Microsoft Excel Advanced

If you enjoyed our Microsoft Excel Basics class, join us for more hands-on activities to help you absorb the material. We will delve into more advanced features of Excel. Class modules include:

Managing Multiple Workbooks and Worksheets

Using 3-D References in formulas
Using links and External References in formulas
Applying cell and range names

Analysis Tools

Applying advanced Conditional Formatting
Determining potential outcomes with Data Tables
Performing What-if Analysis using Goal Seek and Scenarios
Exploring the basics of PivotTables and PivotCharts

Managing Worksheet Functionality

Adding Data Validation criteria
Creating and editing a basic macro
Working with Form Controls
Examining invalid data and formula errors


PLEASE NOTE: Registration is required for this event. Use the "Register" link on this page.

Wednesday, March 11, 2020 at 9:00am to 11:00am

Z. Smith Reynolds Library, 204
1834 Wake Forest Road Winston-Salem, NC 27106