Program Overview

Microsoft Excel – Analyzing and Visualizing Data Program

Overview

The Microsoft Excel – Analyzing and Visualizing Data program is designed to equip students with in-demand skills for today's competitive market. This online, self-paced program teaches students how to consume, transform, model, and visualize data in Microsoft Excel.

Program Highlights

• 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

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

• Consume and transform data
• Manage data relationships
• Optimize models for reporting
• Group, summarize, and visualize data

Course Details

• Consume and Transform Data: Import from data sources, other Excel workbooks, and supported file types; connect and import from databases, files, and folders.
• Perform Data Transformations: Design and implement basic and advanced transformations, apply business rules, change data format to support visualization, cleanse, filter, and format data.
• Visualize Data: Create and manage Pivot Tables and Pivot Charts, format Pivot Table and Pivot Table Charts, use slicers.

Program Overview

• Online Self-study
• Approx. 21 hours
• Microcredential: 12 weeks
• Open enrolment

Who Should Take This 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

Career Opportunities

• 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

Academic Learning Outcomes

Upon successful completion of this program, students will be able to:

1. Consume and transform data
2. Manage data relationships
3. Optimize models for reporting
4. Select a chart type, format calculated measures, filter data
5. Group, summarize, and visualize data

Admission Requirements

This program is open enrolment, which means there is no formal application or admission procedure. To enrol in a course, simply register online. Our courses can be taken as part of a program or individually.

• To enrol in McMaster Continuing Education programs, you must:
  • Have an Ontario Secondary School Diploma or equivalent OR
  • Be a mature student as defined in the Undergraduate Calendar of McMaster University OR
  • Be deemed an exceptional case

Language Requirements

If English is not your native language, you must meet McMaster University’s English proficiency requirements by either qualifying for an exemption or passing a McMaster-approved English test.

Tuition Fees

• $395.00 (Note: Tuition price does not include HST)