*2026 - Jan - Data Analytics on Microsoft Excel

Course Schedule

Schedule: Tuesdays and Thursdays for 4-5 Weeks
Time: 6:00PM - 8:30 PM

Course Overview

This hands-on course is designed to help learners harness the power of Microsoft Excel for data analytics. Through practical modules, participants will develop the skills to clean, analyze, visualize, and interpret data using Excel’s advanced features and tools.

Course Modules

• Module 1: Introduction to Data Analytics & Essential Excel Functions
• Module 2: Data Wrangling with Power Query
• Module 3: Descriptive Analytics Techniques
• Module 4: Creating Effective Data Visualizations
• Module 5: Exploring Relationships Between Variables

Learning Outcomes

By the end of the course, participants will be able to:

1. Apply key mathematical, statistical, logical, and text functions for data processing
2. Clean and transform data using Power Query
3. Use Pivot Tables and Pivot Charts for dynamic data analysis
4. Create impactful visualizations and choose appropriate graph types
5. Summarize data using statistical functions
6. Calculate and interpret correlations
7. Apply predictive analytics using trend curves, regression, and smoothing techniques
8. Conduct hypothesis testing and ANOVA
9. Build interactive dashboards in Excel

Certification

Participants will receive a Data Analytics with Microsoft Excel Certificate issued by Skills for Change, a recognized training institution accredited by the Ministry of Colleges and Universities. Trusted provider since 1998.

Instructor Profile

Waldo Beauséjour is a senior data analyst with over 10 years of experience across government, international development, research, private sector, and healthcare. He holds a Master’s in Applied Economics and has taught at colleges and universities in Canada, the USA, and abroad. Waldo is passionate about empowering professionals with statistical knowledge to make data-driven decisions.

Prerequisites

• English proficiency (CLB Level 6 or higher)
• Basic computer skills and internet access

Tax Benefits

Skills for Change provides official tax receipts. You may be eligible for a partial or full refund of your course fees when filing your Canadian tax return.

📝 Registration is now open. Space is limited—sign up today to reserve your spot!