Microsoft Excel
This comprehensive Microsoft Excel training takes you from foundational skills to advanced data analysis techniques. Whether you are new to spreadsheets or looking to sharpen your expertise, this course covers everything from cell formatting and formulas to PivotTables, Power Query, and dynamic dashboards. You will leave with the confidence to automate repetitive tasks, build professional reports, and make data-driven decisions faster.
Need a custom curriculum for your team? Contact us
What You Will Learn
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modulesDay 1: Getting Started with Spreadsheets
- Navigating the Excel interface, Ribbon, and Quick Access Toolbar
- Creating, saving, and organizing workbooks and worksheets
- Cell formatting: fonts, borders, number styles, and alignment
- Essential functions: SUM, AVERAGE, COUNT, MIN, MAX
- Conditional formatting rules to highlight key data
- Printing, page setup, and sharing workbooks
Day 2: Building Reports and Visuals
- Relative vs. absolute cell references in formulas
- IF, VLOOKUP, and CONCATENATE for everyday tasks
- Sorting, filtering, and organizing data in Tables
- Creating bar, line, and pie charts from your data
- Introduction to PivotTables: summarize data in clicks
- Page layout tips for professional printed reports
After This Level
- Build and format professional spreadsheets from scratch
- Write formulas using 15+ essential functions
- Create basic charts and PivotTables to summarize data
- Apply conditional formatting and print-ready layouts
Who Is This For
- Business analysts and financial professionals
- Administrative staff managing reports and data
- Team leads who need data-driven insights
- Anyone looking to boost productivity with Excel
Prerequisites
Basic computer literacy. No prior Excel experience required for the Fundamental level.
Frequently Asked Questions
Is this Excel course available online?
Yes. All sessions are delivered live via virtual classroom, so you can join from anywhere in Canada or internationally. On-site training is also available for teams in Ottawa and Ontario.
Do I need any prior Excel experience?
No. The Fundamental level starts from scratch. If you already have some experience, you can begin at the Intermediate or Advanced level.
How long does the course take to complete?
Each level is 2 days of training. The full program across all three levels is 6 days, with flexible scheduling to fit your work calendar.
Will I receive a certificate?
Yes. Upon completing each level, you receive a GrowWM certificate of completion that you can share with employers.
Can this be customized for my team?
Absolutely. We offer tailored curricula for corporate teams, focusing on the specific Excel skills your organization needs. Contact us for group rates.
What version of Excel do I need?
We recommend Microsoft 365 or Excel 2021 for the best experience. Most content also works on Excel 2019.
Ready to master Microsoft Excel?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.