Microsoft Excel intermediate level training

This intermediate level Microsoft Excel training course is designed for individuals who have a basic understanding of Excel and are looking to enhance their skills and take their data analysis and spreadsheet creation to the next 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 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. By the end of the course, participants will have the skills and knowledge to effectively analyze and present data using Excel, and will be able to apply these skills in their personal and professional lives.

Basic computer experience required.

Students need to have taken our Excel foundations class 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 Basic Excel Skills

  • Review of basic Excel functions and formulas
  • Introduction to intermediate level concepts and tools

II. Advanced Formulas and Functions

  • Using IF, AND, and OR functions for complex data analysis
  • Working with lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Advanced math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, MAX, MIN, STDEV)

III. Pivot Tables

  • Creating and editing pivot tables
  • Sorting, filtering, and calculating data in pivot tables
  • Using pivot tables to analyze and present data

IV. Data Visualization

  • Creating professional-quality charts and graphs
  • Using data visualization tools in Excel (Sparklines, Map Charts, Waterfall Charts)
  • Best practices for data visualization

V. Working with Large Datasets

  • Splitting and freezing panes for easy navigation
  • Using data validation to ensure accurate data entry
  • 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

VII. Case Studies and Hands-On Exercises

  • Working through real-world examples to apply intermediate Excel skills
  • Practice applying advanced formulas, pivot tables, and data visualization tools to solve problems

VII. 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.
Nancy J.


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!
Monica B.

Graphic Designer

Well organized and gave practical examples that I can apply to my work.
Andrea K.

Senior Electronic Communications