Overview
Complete the Microsoft Excel program and earn a microcredential
Upon successfully completing this program, you will receive a microcredential recognizing your learning achievement. Complete with details of the skills and specialized knowledge you have acquired, the microcredential is digitally shareable, making it easy to add to your resume, LinkedIn profile and to share with current or prospective employers.
Earn a microcredential with our online Microsoft Excel – Analyzing and Visualizing Data program
Six out of ten Canadian job postings place Microsoft Excel as one of the top skills employers seek. Companies are hiring employees with experience in data analysis and visualization to transform complex data into solutions to help make better business decisions.
- Teaches you how to consume, transform, model, and visualize data in Microsoft Excel
- Developed in collaboration with McGraw Hill and Devant
- The course uses SIMnet, an online training program that identifies skill gaps so you learn the skills you need, from beginner to intermediate
Information Box Group

Program highlights Learn More
- Online – self-paced – start at any time
- Taught via SIMnet Online Training and assessment platform with expert instructor support
- Earn a microcredential in as little as 12 weeks
- Open enrolment program
Microsoft Excel – Analyzing and Visualizing Data program features:
- Access to SIMnet platform for life
- Expert instructor available for questions and support
- Virtual Excel interface (no need to purchase an Excel license)
- Unlimited practice with real-life business cases
- Approximately 21 hours of course work
- Configure and manipulate data in PowerPivot, Pivot Tables and Pivot Charts

What you'll learn Learn More
- Consume and transform data
- Manage data relationships
- Optimize models for reporting
- Group, summarize and visualize data
Through our Microsoft Excel – Analyzing and Visualizing Data program, you’ll learn to:
Consume and Transform Data
- Import from data sources, other Excel workbooks and supported file types
- Connect and import from databases, files and folders, Microsoft SQL, Azure, Big Data, SQL, Server Analysis Services (SSAS) and Power Query
- Link data from other sources
Perform Data Transformations
- Design and implement basic and advanced transformations, apply business rules, change data format to support visualization, cleanse, filter and format data
- Manage incomplete data and data received as a report
- Remove data, repeating headers, rows and columns
- Create and optimize data models, manage data relationships, manually enter data
- Perform Get & Transform
- Create automatic and manual relationships
- Create calculated columns, measures and tables
- Create Excel formulas and performance KPIs
- Calculate the actual value, target value and actual to target values
- Create hierarchies, date and business hierarchies and resolve hierarchy issues
- Describe DAX queries and formulas
Visualize Data
- Create and manage Pivot Tables and Pivot Charts
- Format Pivot Table and Pivot Table Charts
- Format calculated measures, filter groups and summarize data
- Use slicers
- Describe interaction with PowerBI: import and manipulate Excel data*
*PowerBI topic is not included in SiMnet course modules and course evaluation. Instructor shares supplemental resources.
Learn more about the Microsoft Excel program
- Professionals interested in advancing their skills in Microsoft Excel
- Professionals in finance, healthcare, marketing, government, logistics, transportation, information systems, media/entertainment or other sectors
- Anyone interested in re-skilling, up-skilling or making a career change
Earning a Microcredential in Microsoft Excel opens doors to a wide range of rewarding careers that require Excel, including:
- Accountants and auditors
- Management and market analysts
- Cost Estimators
- Market research analysts and digital marketers
- Administrative assistants, information staff
- Project coordinators, project managers and construction managers
- Sales, marketing, training and administrative managers
- Remote Excel jobs
Upon successful completion of this program, students will be able to:
- Consume and transform data
- Manage data relationships
- Optimize models for reporting
- Select a chart type, format calculated measures, filter data
- Group, summarize, and visualize data
Check out our latest Program Preview webinar recording to learn more about the Microsoft Excel – Analyzing and Visualizing Data program
What our recent graduates say

Adam
Business Administration graduate
I feel very strongly that McMaster Continuing Education can really help you reinvent your career.
I feel very strongly that McMaster Continuing Education can really help you reinvent your career. I found that the Business Administration program was really the best fit for me, because the learning that I was able to take in through this program was really cutting edge and current to the labour market. The learning that I took on is something I use every day.
Adam
Business Administration graduate
Judelyn '23
Business Administration with a concentration in Finance/Accounting
I appreciated the opportunity to discover my full potential and strengths, which inspired me to do better.
My family migrated to Canada in 2006 from the Philippines (Asia). I hold a bachelor’s degree in accounting from my home country.
Although challenging, I am grateful for the opportunities I have been given. I started my journey in Canada with temporary junior accounting jobs. It allowed me to integrate myself into the Canadian workforce and culture. After gaining more Canadian work experience, I landed a permanent job. Currently, I work as Treasury Analyst in a HydroElectric Generation company.
Despite the obstacles, I was determined to gain Canadian credentials. The pandemic made it more challenging, but I persisted. I balance work, study, and family.
In December 2019, I enrolled at McMaster University. Later earned a Diploma in Business Administration with a Concentration in Finance and completed a Diploma in Accounting.
While studying at McMaster University, I developed my self-discipline and changed how I perceive things, which is priceless. I have to experience it to learn and discover it. I am self-motivated. I noticed I enjoyed studying – understanding in depth and not memorizing, which I usually did when I was younger.
The McMaster University courses were challenging to be honest, and my teachers taught me to be a critical thinker. I began thinking outside the box. The good thing is that if I had an idea or answered a question, they let me explain why I came up with that answer – that, for me, was so engaging for a student to understand more and strive to improve rather than simply dismissing a student’s incorrect answer.
From personal experience, the teaching style of McMaster University is different, and I appreciated the opportunity to discover my full potential and strengths, which inspired me to do better. Until now, I have applied the ways and self-discipline I had gained even with this Treasury Designation exam I took recently. I want to thank and let McMaster know the influence/the lessons they had instilled in me that changed my outlook and mindset, making me better and excel in what I want to be.
Judelyn
Business Administration with a concentration in Finance/Accounting

Tracy
Project Management graduate
I am constantly reinventing myself. McMaster Continuing Education has been transformative.
I am constantly reinventing myself. McMaster Continuing Education has been transformative. I was introduced to new ideas and new skills. Because of that, I’ve had new opportunities in my career. McMaster Continuing Education is the best place to take professional development courses. The programs fit into your life.
Tracy
Project Management graduate
I feel very strongly that McMaster Continuing Education can really help you reinvent your career.
I feel very strongly that McMaster Continuing Education can really help you reinvent your career. I found that the Business Administration program was really the best fit for me, because the learning that I was able to take in through this program was really cutting edge and current to the labour market. The learning that I took on is something I use every day.
Adam
Business Administration graduate
I appreciated the opportunity to discover my full potential and strengths, which inspired me to do better.
My family migrated to Canada in 2006 from the Philippines (Asia). I hold a bachelor’s degree in accounting from my home country.
Although challenging, I am grateful for the opportunities I have been given. I started my journey in Canada with temporary junior accounting jobs. It allowed me to integrate myself into the Canadian workforce and culture. After gaining more Canadian work experience, I landed a permanent job. Currently, I work as Treasury Analyst in a HydroElectric Generation company.
Despite the obstacles, I was determined to gain Canadian credentials. The pandemic made it more challenging, but I persisted. I balance work, study, and family.
In December 2019, I enrolled at McMaster University. Later earned a Diploma in Business Administration with a Concentration in Finance and completed a Diploma in Accounting.
While studying at McMaster University, I developed my self-discipline and changed how I perceive things, which is priceless. I have to experience it to learn and discover it. I am self-motivated. I noticed I enjoyed studying – understanding in depth and not memorizing, which I usually did when I was younger.
The McMaster University courses were challenging to be honest, and my teachers taught me to be a critical thinker. I began thinking outside the box. The good thing is that if I had an idea or answered a question, they let me explain why I came up with that answer – that, for me, was so engaging for a student to understand more and strive to improve rather than simply dismissing a student’s incorrect answer.
From personal experience, the teaching style of McMaster University is different, and I appreciated the opportunity to discover my full potential and strengths, which inspired me to do better. Until now, I have applied the ways and self-discipline I had gained even with this Treasury Designation exam I took recently. I want to thank and let McMaster know the influence/the lessons they had instilled in me that changed my outlook and mindset, making me better and excel in what I want to be.
Judelyn
Business Administration with a concentration in Finance/Accounting
I am constantly reinventing myself. McMaster Continuing Education has been transformative.
I am constantly reinventing myself. McMaster Continuing Education has been transformative. I was introduced to new ideas and new skills. Because of that, I’ve had new opportunities in my career. McMaster Continuing Education is the best place to take professional development courses. The programs fit into your life.
Tracy
Project Management graduate
Other programs you may be interested in
Microcredential in Microsoft Excel
Microcredential in Microsoft Excel – Analyzing and Visualizing Data
Earn a Microcredential in Microsoft Excel – Analyzing and Visualizing Data with McMaster Continuing Education
Explore the requirements below and register today!
Information Box Group

Microcredential in Microsoft Excel – Analyzing and Visualizing Data
To earn a Microcredential you will need to pass the final capstone exam. A final grade of 60% or better on the final assessment is equivalent to a Pass.
Microcredential in Microsoft Excel – Analyzing and Visualizing Data Requirements
Note: You will have 12 weeks from your start date to complete the course.
Course
*Students may begin this course any time before April 16, 2023 and will be given 12 weeks from start date to complete the course.
Please note: Tuition price does not include HST
Microsoft Excel – Analyzing and Visualizing Data Course
Microsoft Excel – Analyzing and Visualizing Data Courses
Advance your career with the online Microsoft Excel – Analyzing and Visualizing Data course
Explore the course below and register today!
Information Box Group
*Students may begin this course any time between May 8th and August 17th, 2023, and will be given 12 weeks to complete the course.
Please note: Tuition price does not include HST. This will be added at checkout.