Loading...

Description

Business analytics integrates statistical analysis, management science, and information technology to solve business problems. Although Excel is one of the most popular and accessible software packages, most users are unaware of its multiple data analysis functions. The Analysis ToolPak in Excel offers powerful tools that allow users to perform statistical and financial analyses using various analytics techniques, including descriptive statistics, correlation, and regression.

The objective of this practical hands-on workshop is to demonstrate to participants how they can use various Excel functions and tools to perform sophisticated data analyses and transform data into valuable business insights.


This course has been approved for the Visées program funding.

Develop the skills of your teams with this training, and benefit from a grant of up to $8,000!

The Visées program is an initiative of the Fédération des Chambres de Commerce du Québec (FCCQ) and the Chambre de Commerce du Montréal Métropolitain (CCMM), funded by Upskill Canada (powered by Palette Skills) and the Government of Canada.

When applying to Visées for tuition reimbursement, please use reference code: MCGILL-006.

Apply for a grant from the Visées program

Topics Covered

  • Introduction to business analytics
  • Descriptive analysis
  • Correlation analysis
  • Predictive modelling using linear regression

Learning Outcomes

Upon completion of this workshop, participants should be able to:

  • Summarize a data set using descriptive statistics
  • Identify patterns using correlation analysis
  • Produce linear regression models
  • Examine the results of linear regression models

Notes

Participants need to have access to:

  • Microsoft Excel (2016 version or later) installed on their computers (not accessed via web browser)

Prerequisite(s) and Corequisite(s)

Basic knowledge of Excel.

Who Should Attend?

Open to anyone who wishes to learn about the field of business analytics and who wants to use Excel as their data analysis tool.
Loading...
Section(s) offered
Section Title
Introduction to Business Analytics using Excel
Language of Delivery
English
Type
Virtual Course
Days
F
Time
9:30AM to 11:45AM
Dates
Sep 05, 2025 to Sep 26, 2025
Schedule and Location
Contact Hours
9.0
Delivery Format(s)
Course Fee(s)
Fee non-credit $595.00
Drop Request Deadline
Aug 29, 2025
Transfer Request Deadline
Aug 29, 2025
Withdrawal Request Deadline
Sep 05, 2025
Section Notes

A minimum number of registrations is required for this workshop section to be offered. The School reserves the right to cancel any workshop section when a minimum number of registrations has not been reached 7 days prior to the start date. In the event of a cancellation, the workshop fee will be refunded in full.

Cancellation Policy

All cancellation & substitution requests must be made in writing to pce.scs@mcgill.ca

  • Receive a full refund if your cancellation request is received up to 7 days prior to the start date of the workshop.
  • Receive a refund minus $50 cancellation fee if your cancellation request is received within 7 days prior to the start date of the workshop.
  • No Refunds are issued if no written notice is given prior to the start of the workshop

Please note that if no notice is given prior to the start of the event(s) and you fail to attend, you will be liable for the full workshop fee.

Required fields are indicated by .