MS Excel Intermediate Course
Microsoft Excel Training Session
Our MS Excel Intermediate Course is a comprehensive, tutor-led program that includes hands-on practice. The course is designed to advance your Excel skills to the next level. We’ll start by reviewing the Excel for beginners training, then delve into advanced formulas and functions, and help you become proficient in working with spreadsheets. Throughout the course, you’ll gain knowledge of commonly used Excel functions, learn how to manage large sets of Excel data, and master PivotTables to generate dynamic reports. Additionally, we will cover other useful formulas such as IF, VLOOKUP, INDEX, and MATCH. See below for more details!
At the end of this intensive Training
03.
MS Excel Intermediate Course
- Advanced Formulas and Functions
- VLOOKUP, HLOOKUP, and XLOOKUP
- INDEX and MATCH
- IF, AND, OR Functions
- Data Validation and Conditional Formatting
- Data Validation
- Conditional Formatting
- PivotTables and PivotCharts
- Creating PivotTables
- PivotCharts
- Data Analysis Tools
- What-If Analysis
- Data Tables
- Advanced Charting Techniques
- Combo Charts
- Sparklines
04.
Learning Outcomes:
Once you finish this course, you’ll have the skills to use Excel to enhance your data analysis abilities!
MS Excel Intermediate Course
- Course fee: CAD 100.00 + GST
- Minimum Eligibility Criteria: Open to all.
Call Today
403-402-4264