Microsoft Excel Advanced
Thursday, May 16, 2019 9am to 11am
About this Event
2100 Eure Drive, Winston-Salem, NC 27106
http://pdc.wfu.edu/event/13142/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
Consolidating data using the Consolidate command
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 forms and controls
Examining invalid data and formula errors
PLEASE NOTE: Registration is required for this event. Use the "Register" link on this page.
Event Details
User Activity
No recent activity