Microsoft Excel Intermediate
This intermediate-level course will show you exactly how simple Microsoft Excel can be, when you get proper training that is focused on how to use the program in the real world.
Are you comfortable with the basics of Microsoft Excel—creating simple formulas, adding cells, and basic formatting—but find yourself struggling with more advanced tasks? When it comes to building smarter, more efficient worksheets that handle recurring data entry with ease and accuracy, many of us either turn to IT for help or revert to manual methods like pen, paper, and calculators.
Imagine having the skills to design Excel worksheets tailored to your daily tasks, cutting down hours of repetitive work into just a few moments of data entry. Microsoft Excel is one of the most powerful tools in the Microsoft Office suite, yet its advanced features often seem intimidating or hard to grasp. The truth? With the right training, those features are easier to use than you might think.
Our Microsoft Excel Intermediate Training is designed to bridge the gap between basic understanding and professional-level proficiency. This course provides hands-on instruction, focusing on practical techniques and real-world applications to help you unlock Excel’s full potential. Don’t let outdated processes slow you down—empower yourself with the skills to excel.
This is an intermediate-level course.
Course Curriculum
Session 1: Working with Templates, March 4, 10 am to 12 pm PT
• Using Excel Online Templates
• Creating Templates from a Worksheet
• Saving and Sharing Templates
• Editing Templates
• Using Templates to Start New Worksheets
• Template Best Practices
Session 2: Data Controls, March 11, 10 am to 12 pm PT
• Sorting and Filtering Data
• Finding Data
• Working With Conditional Formatting
• Integrating Filters and Conditional Formatting
Session 3: Conditional & Lookup Formulas, March 18, 10 am to 12 pm PT
• Linking Workbooks and Worksheets via Formulas
• Conditional Formulas & Functions
• Lookup Formulas & Functions
• Nesting Formulas
• Other Useful Formulas and Functions
Session 4: Charts & Tables, March 25, 10 am to 12 pm PT
• Chart Planning
• Creating Basic Charts and Tables
• Chart Types and Formats
• Pivot Tables
• Sharing Charts & Tables
