Microsoft Excel, Intermediate
This hands-on class covers the skills and information needed to create complex worksheets and to effectively analyze, extract and present actionable information from existing data. It is designed for anyone who already has a strong foundational knowledge of Excel and wishes to develop greater proficiency and mastery. Emphasis will be given to the use of advanced functions and PivotTables.
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: Excel Fundamentals or equivalent knowledge
Using defined names to map data & simplify formulas/functions
Identifying & utilizing specialized functions on an as-needed basis
Decoding complex function syntax & arguments
Using logical functions to embed decision making into calculations
Transitioning from standard to conditional summary functions
Using functions to pass argument information via nesting
Calculating data and time information in Excel
Manipulating text strings with formulas/functions
Sorting, filtering and subtotaling datasets
Converting ordinary data ranges to Table Objects
Using the Table Object functionality to quickly transform data
Leveraging dynamic ranges to minimize ongoing maintenance
Using formula-based conditional formatting to highlight related data
Selecting, creating, modifying and formatting charts
Creating dual-axis combo charts with forecasting & trend lines
Determining when to Use Table Objects vs. Pivot Tables
Summarizing large datasets with PivotTables and PivotCharts
Analyzing and refining PivotTable reports
Switching between cross tabulation and nested outline reports
Redefining how summary values are calculated & displayed
Creating interactive filters with Slicers & Timelines
Extracting PivotTable supporting data on the fly
Custom delivery
This class can be tailored to meet your company's needs. It can be delivered at your facility, or off-site at our office. Please contact Employers Network for more information.
Instructor
Schedule
This is a 2-Day Class.
March 12-13, 2025
Class meets 8:30 a.m. to 4:30 p.m on both days.
Fee
Members: $616 per person
Non-members: $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.