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


Analyzing Data with Excel

This course will introduce participants to advanced Excel techniques that will improve their ability to summarise data or perform data calculations. Students will learn how to use functions in Excel in this course. The introduction will cover the fundamental operations, after which calculations and expressions will be thoroughly examined. The advanced features will be thoroughly examined. Additionally, the course will cover regressions, what-if analysis, and solver. Students are capable of creating pivot tables, pivot charts, and macros as well as executing them by the end of the course. Professionals can use this course to get certified by Microsoft.

  • 7th August 2023
  • 36 hours
  • Contact the Advisor
  • Talk to an Advisor

Schedule: Monday, Wednesday, Friday - 6pm - 9pm


  • Analyzing Data with Excel

    Get trained by industry Experts

    Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.
  • Analyzing Data with Excel

    Official Certification curriculum

    Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.
  • Analyzing Data with Excel

    Tax Credit

    Claim up to 25% of tuition fees and education tax credit from your taxes.
  • Analyzing Data with Excel

    Discount on Certification Voucher

    Upto 50 percent discount voucher will be provided.
  • Analyzing Data with Excel

    24/7 Lab access

    Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.


Analyzing Data with Excel

This module explores launching Excel, Microsoft Excel Startup Screen, Customizing the Excel Quick Access Toolbar, More on the Excel Interface, Understanding the Structure of an Excel Workbook, Saving an Excel Document, Opening an Existing Excel Document, Common Excel Shortcut Keys.

This module comes with Entering Text to Create Spreadsheet Titles, Working with Numeric Data in Excel, Entering Date Values in Excel, Working with Cell References, Creating Basic Formulas in Excel and Relative Versus Absolute Cell References in Formulas

This module provides knowledge about Working with the SUM() Function, Working with the MIN() and MAX() Functions, Working with the AVERAGE() Function, Working with the COUNT() Function, Adjacent Cells Error in Excel Calculations, Using the AutoSum Command, Excel's AutoSum Shortcut Key and Using the AutoFill Command to Copy Formulas.

This module covers moving and copying Data in an Excel Worksheet, Inserting and Deleting Rows and Columns, Changing the Width and Height of Cells, Hiding and Unhiding Excel Rows and Columns, Renaming an Excel Worksheet, Deleting an Excel Worksheet and Moving and Copying an Excel Worksheet.

This module makes you familiar with Working with Font Formatting Commands, Changing the Background Color of a Cell, Adding Borders to Cells, Excel Cell Borders Continued, Formatting Data as Currency Values, Formatting Percentages, Using Excel's Format Painter, Creating Styles to Format Data, Merging and Centering Cells, Using Conditional Formatting and Editing Excel Conditional Formatting.

This module comes with Inserting Images, Inserting Excel Shapes and Formatting Excel Shapes.

This module provides with the necessary knowledge of Creating an Excel Column Chart, Working with the Excel Chart Ribbon, Adding and Modifying Data on an Excel Chart, Formatting an Excel Chart, Moving a Chart to another Worksheet and Working with Excel Pie Charts

This module explores the Sorting a List Using Single Level Sort, Sorting a List Using Multi-Level Sorts, Using Custom Sorts in an Excel List, Filter an Excel List Using the AutoFilter Tool, Creating Subtotals in a List, Format a List as a Table, Using Conditional Formatting to Find Duplicates and Removing Duplicates.

This module provides and overview of Excels Function: DSUM(), Excel DSUM Function Single Criteria Continued, Excel DSUM Function with OR Criteria, Excel DSUM Function with AND Criteria, Excel Function: DAVERAGE(), Excel Function: DCOUNT() and Excel Function: SUBTOTAL()

This module provides idea about creating an Excel Data Validation List, Excel Decimal Data Validation, Adding a Custom Excel Data Validation Error and Dynamic Formulas by Using Excel Data Validation Techniques

This module presents idea about the importing Data Into Microsoft Excel, Importing Data from Text Files, Importing Data from Microsoft Access, Import Data From Text Files into Excel,  Import Data From a Database into Excel, Microsoft Excel Legacy Import Options for New Excel Versions and Exporting Data to a Text File.

This module presents Creating an Excel PivotTable, Modifying Excel PivotTable Calculations, Formatting PivotTable Data, Modifying PivotTable Calculations, Drilling Down into PivotTable Data, Creating PivotCharts, Filtering PivotTable Data and Filtering with the Slicer Tool.

This module presents Using the Freeze Panes Tool, Grouping Data (Columns and/or Rows), Print Options for Large Sets of Data, Linking Worksheets (3D Formulas) and Consolidating Data from Multiple Worksheets

This module presents Working with Excel Name Ranges, Advantages and Disadvantages of Excel Name Ranges, Editing an Excel Name Range, Using Excel's IF() Function, Excel's IF() Function with a Name Range, Nesting Functions with Excel, Nesting Excels AND() Function within the IF() Function, Using Excel's COUNTIF() Function, Using Excel's SUMIF() Function and Using Excel's IFERROR() Function

This module covers Microsoft Excel VLOOKUP() Function, Microsoft Excel HLOOKUP() Function, Microsoft Excel INDEX() Function, Microsoft Excel MATCH() Function, Microsoft Excel INDEX() and MATCH() Function Combined, Microsoft Excel INDEX() and MATCH() Function Combined Continued and Creating a Dynamic HLOOKUP() with the MATCH() Function.

This module presents Understanding Excel Macros, Activating the Developer Tab in Excel, Editing a Macro with VBA and Creating Buttons to Run Macros.



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.

Eligibility and Requirements

Learners need to possess an undergraduate degree or a high school diploma. No need of any professional experience is required as this is a basic course.



There are no prerequistes for this course.

Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation


Upon completing this cerification course you will:

  • Receive an industry-recognized certificate from MCIT.
  • Be prepared for the official Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation.



— F.A.Q —

Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
All of our exceptionally skilled instructors have a decent experience of training and industry experience and are AW certified in the respective field. Each of them through a rigorous selection procedure that included profile screening, technical examination, and a training demo. 
Yes, there are vouchers to take the official exam.
Upon completion of the certification course classes you will be provided with an MCIT certificate.