Collège des technologies de l’information de Montréal
Montreal College of Information Technology 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.

Instructor led


  • Analyzing Data with Excel

    Get trained by industry Experts

  • Analyzing Data with Excel

    Project Based Learning

  • Analyzing Data with Excel

    Learn while you Work

  • Analyzing Data with Excel

    State of the Art Infrastructure

  • Analyzing Data with Excel

    24/7 Lab access


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



Career starters : For those people who are either entering the job market or are interested in making a shift in their current job status. Analyzing Data with Excel certification program can help you transition into, or start a new career as a fully equipped Excel expert or consultant.
Professionals aiming to undertake exams in Word or Excel to earn a Microsoft Office Specialist Expert certification or demonstrate their skills in Excel in a professional sphere.
Those seeking to validate a professional ability to work with MS Excel applications and tools. Familiarise with spreadsheet application distributed by Microsoft and data entry jobs, functions like graphic tools, calculators, formulas, charts, macro programming language, and other pivotal tools.
Professionals seeking an increase in salary and as much as 29% in the long run. In a similar survey done among employers, statistics indicate that a recruit feels more comfortable hiring a certified professional than recruiting a non certified professional.


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

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



— FAQ —

Pour vous inscrire à un cours, vous pouvez soit nous appeler, soit saisir votre demande en ligne, et notre personnel administratif vous appellera pour vous inscrire.
Absolument. N'hésitez pas à contacter notre bureau, nous serons plus qu'heureux de travailler avec vous pour répondre à vos besoins de formation.
Vous pouvez trouver la plupart des informations de planification et de tarification sur notre site Web, ou vous pouvez appeler notre bureau pour obtenir de l'aide.
Les sessions de MCIT commencent tous les quatre mois, soit en octobre (session d’automne), février (session d’hiver), et juin (session d’été). Les étudiants sont invités à s’inscrire au moins 2 à 16 semaines à l’avance. Veuillez noter que plusieurs cours affichent complet bien avant la date limite d’inscription.