Microsoft Excel advanced level training
This advanced level Microsoft Excel training course is designed for individuals who have a strong understanding of Excel and are looking to expand their skills to the highest level. Through hands-on exercises and real-world examples, participants will learn how to use advanced formulas and functions, create and edit pivot tables and macros, and utilize data visualization tools to create professional-quality charts and graphs.
In this course, participants will also learn how to work with large datasets, perform data validation, and use advanced formatting techniques to create visually appealing and easy-to-read spreadsheets. Additionally, participants will learn how to create and use macros to automate tasks and streamline workflows, as well as how to work with data from external sources such as databases and web APIs. By the end of the course, participants will have a comprehensive understanding of Excel and will be able to effectively analyze and present data using a wide range of advanced tools and techniques.
Basic computer experience required.
Students need to have taken our Excel foundations and intermediate classes or have equivalent experience with Excel
- 6 hours of hands on training – 9am to noon, one hour lunch break, 1pm to 4pm CST
- 100% original content created by C2
- 1 year of email tech support
- 1 year free retake policy
- 100% Satisfaction guarantee
Class Outline by Topic
I. Introduction and Review of Intermediate Excel Skills
- Review of intermediate Excel functions and formulas
- Introduction to advanced level concepts and tools
II. Advanced Formulas and Functions
- Using complex nested formulas for data analysis
- Working with advanced lookup and reference functions (HLOOKUP, VLOOKUP, INDEX, MATCH)
- Using financial and engineering functions (PMT, FV, PV, IRR, XIRR, RATE)
- Working with text and logical functions (CONCATENATE, TEXT, IFERROR, ISERROR)
III. Pivot Tables and Macros
- Creating and editing pivot tables with advanced options
- Using pivot tables to analyze and present data
- Introduction to macros and VBA programming
- Creating and editing macros to automate tasks
IV. Data Visualization
- Creating professional-quality charts and graphs with advanced options
- Using data visualization tools in Excel (Sparklines, Map Charts, Waterfall Charts)
- Best practices for data visualization
V. Working with Large Datasets
- Advanced techniques for sorting and filtering data
- Using data validation to ensure accurate data entry
- Importing and exporting data from external sources (databases, web APIs)
- Tips and tricks for organizing and managing large datasets
VI. Advanced Formatting Techniques
- Using styles and themes to create visually appealing spreadsheets
- Using conditional formatting to highlight important data
- Customizing cell and number formatting
- Working with data tables and named ranges
VII. Case Studies and Hands-On Exercises
- Working through real-world examples to apply advanced Excel skills
- Practice applying advanced formulas, pivot tables, macros, and data visualization tools to solve problems
VIII. Conclusion and Next Steps
- Review of key takeaways from the course
- Resources for continuing Excel learning and development
Schedule a live instructor for this class
Book an instructor at the same price as all our classes – no additional fees
One-day, 6 hours of training for $395
Love C2 Training! I always walk away with great ideas.
I am rusty and needed to be brought back up to speed. Feel refreshed and learned many basics that I didn’t know I needed!
Well organized and gave practical examples that I can apply to my work.