Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR


Analyzing Data with Excel

This course is to familiarize participants with the use of advanced techniques in excel which enhances the use of excel in summarizing or performing data calculations. In this course, students will learn the implementation of functions in Excel. The basic functions will be covered as a part of the introduction and then calculations and expressions will be studied in detail. Advance functions will be explored in depth. The course will also include solver, regressions and what if analysis. By the end of the course, students are able to create pivot tables, pivot charts and create macros as well as execute them. This course also prepares professionals for official Microsoft certifications.

​Class Schedule: Tuesday and Thursday (6:00pm - 9:00pm EST)

Professional Benefits

Professionals work in a wide array of companies, from startups to global organizations. The annual salary range for a business analyst is generally between $48,000 to $88,000.


Who Should Apply

IT professionals
Human resource specialists
Data entry specialists
Professionals performing business analytics

Analyzing Data with Excel
Sihame B

BI Developer

Analyzing Data with Excel
Rosana Neishabouri

Data Analyst at Lamour

Analyzing Data with Excel
Dwany H

Big Data Developer

Analyzing Data with Excel
Chloe D


Eligibility and Requirements

General IT knowledge
General IT business knowledge
Some knowledge on Microsoft Office


Excel basics

Use of worksheets and workbooks

Conditional formatting

Working with tables

Formatting tables

Using functions and formulas

Using charts

Graphical display of data

Format objects

Create pivot tables and charts

Working with external data

Macros, power map, and power pivot


Analyzing Data with Excel

Creating and Formating worksheets, workbooks
Customizing options and views for worksheets and workbooks
Configuring worksheets and workbooks for distribution
Inserting and format data in cells and ranges
Summarizing and organising data

Creating and managing tables
Managing table styles and options
Filtering and sorting table
Summarizing data by using functions
Performing conditional operations by using functions
Formating and modifying text by using functions

Creating and formating charts
Using graphic elements in chart
Inserting and formating objects

Creating pivot table and charts
Pivoting data and slicers
Two dimensional pivot table
Creating and formatting pivot chat with external data

Create macro using VBA
In built functions and sub procedures
Loops, conditional statements and regression analysis
Mapping data, discover insights and share stories in power map
Power pivot implementation

Earn MCIT Certification

Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
(Different versions of Excel are also available)

Why join MCIT?

  • Taught by Industry Expert Instructors
  • Real-Time, Hands-on Training
  • Post Graduation Job Placement
  • 24/7 Virtual Lab Access
  • Flexible Schedule (Evening and Weekend Class Times)
  • Vendor Authorized Trainings



After completing my diploma in Business Intelligence at Montreal College, I was able to land my first job at Bell Canada, where I am currently working with the Intelligence & Analytics team.

Abdulla Alkhuzai — BI Student
  • Analyzing Data with Excel
  • Analyzing Data with Excel
  • Analyzing Data with Excel
  • Analyzing Data with Excel
  • Analyzing Data with Excel


— F.A.Q —

To register for a course, you can either call us or enter your request online and our administrative staff will call you with steps to register.
Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
You can find most of the scheduling and pricing information on our website, or you can call our office for assistance.
Montreal College offers a new session every four months, i.e., in October (fall session), February (winter session) and June (summer session). Students are encouraged to register at least 2 to 16 weeks in advance. Please note that many programs fill up before the registration deadline.

Montreal College of Information Technology

Collège des TI de Montréal   

110-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3V8

+1 514-312-2383
.(JavaScript must be enabled to view this email address)