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.

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


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.
Section(s) offered
Section Title
Introduction to Business Analytics using Excel
Language of Delivery
Virtual Workshop
9:00AM to 3:00PM
Oct 03, 2024
Virtual Workshop
9:00AM to 2:00PM
Oct 04, 2024
Schedule and Location
Contact Hours
Course Fee(s)
Fee non-credit $495.00
Drop Request Deadline
Sep 26, 2024
Transfer Request Deadline
Sep 26, 2024
Withdrawal Request Deadline
No withdrawal request allowed after enrollment
  • Abdelrahman Ayad
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 .