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.

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
Workshop
Days
F
Time
1:00PM to 5:30PM
Dates
Feb 17, 2023
Type
Workshop
Days
F
Time
1:00PM to 5:30PM
Dates
Feb 24, 2023
Schedule and Location
Contact Hours
9.0
Location
  • Downtown, Montreal
Delivery Format(s)
Course Fee(s)
Fee non-credit $395.00
Drop Request Deadline
Feb 10, 2023
Transfer Request Deadline
Feb 10, 2023
Withdrawal Request Deadline
No withdrawal request allowed after enrollment
Instructors
  • Abdelarhman Ayad
Section Notes

A minimum number of registrations is required for this course section to be offered. The School reserves the right to cancel any course 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 course fee will be refunded in full.
 

Cancellation Policy

All cancellation & substitution requests must be made in writing to pd.conted@mcgill.ca.

  • Receive a full refund if your cancellation request is received up to 14 days prior to the start date of the workshop.
  • Receive a refund minus $50 cancellation fee if your cancellation request is received up to 7 days prior to the start date of the workshop.
  • No Refunds are issued if your cancellation request is received within 7 days of the start date of the workshop, however suitable participation substitution will be permitted.

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 course fee.

Required fields are indicated by .