Loading page details...
Instructor-Led Training
One-Day Advanced Training for Microsoft Excel
As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This LIVE, virtual workshop will teach you the most advanced features and functions Excel offers — taking your level of proficiency from mid-level to advanced. After a few hours of training, you’ll be amazed at how this powerful program can work for you.
This intensive training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Course Preview
Course Outcomes
- Utilize advanced Excel features to optimize data management and reporting
- Create, configure and customize tables to effectively organize and present data
- Summarize and analyze large datasets using PivotTables for insightful reporting
- Develop and implement robust formulas with both absolute and relative cell references
- Apply common functions to streamline and simplify complex calculations
Course Agenda
Instructor-Led Training
Session 1: Excel Tables and PivotTable Reports
Session 2: Absolute vs. Relative Cell References and Formatting
Session 3: VLOOKUP and Other Common Functions
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in
Related Courses