Microsoft Excel, Advanced
This hands-on class covers the skills and information needed to make complex worksheets more robust, perform advanced data analysis & formula auditing, automate workbook functionality, and tap into the power of dynamic array formulas & functions. It is designed for experienced Excel users who would like to advance their skills. Emphasis will be given to fully mastering Excel’s new dynamic array capabilities.
Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to apply new skills to real‑world scenarios.
Topics include:
Prerequisite: Intermediate Excel as taught by same provider
Using cell links to pull in data from other cells/worksheets/workbooks
Creating formulas and functions that reference external data
Using 3-D references to summarize ranges of data across sheets
Collecting, compiling & consolidating data from multiple locations
Collaborating more effectively on shared workbooks
Protecting worksheets and workbooks from unauthorized actions
Searching for and removing potentially sensitive metadata
Applying validation to facilitate easier and more accurate data entry
Searching for and resolving invalid data and formula errors
Recording simple macros to automate workbook functionality
Selecting and implementing various lookup functions
Retrieving related data from reference tables interactively
Utilizing reference arrays, resultant arrays & array constants
Understanding dynamic arrays and spilled array behavior
Understanding single & multi cell array formula syntax
Using Excel’s new dynamic array functions to work with datasets
Tracing formula precedents and cell dependencies
Auditing and troubleshooting formulas and functions
Determining potential outcomes with data tables
Using data scenarios to quickly switch between datasets
Using goal seek to identify input needed for desired outcome
Forecasting future data trends from existing datasets
Micro charting individual data series with sparklines
Visualizing geographic data over time with 3d Maps
Instructor
Schedule
This is a 2-Day Class.
June 17-18, 2025
Class meets 8:30 a.m. to 4:30 p.m on both days.
Fee
Members/Investors: $616 per person
Standard Tickets: $836 per person
Attendance
Should you need to cancel your registration, please email Candace Hall at candace@employersnet.com. Kindly note the following:
Eventbrite Service Fee: Non-refundable under all circumstances.
Employer's Network Cancellations: If Employers Network cancels the class for any reason, your ticket can be transferred to any class of your choice of equal value.
No-Show Policy: Registered participants who do not attend the class ("no-shows") will be charged the full class cost. No-show fees cannot be used as credit for any future Employers Network class, event, or service.
Cancellation Window: Cancellations made less than 10 business days prior to the class start will be charged the full class cost. This fee may not be used as credit for future Employers Network classes, events, or services. However, substitutions are welcome.
Real-Time Event Changes: Employers Network reserves the right to make real-time changes to event content or offerings as necessary. In such cases, no refunds, partial refunds, or alternative offers will be made beyond the terms stated in this cancellation policy.