Perform advanced data analytics using Excel

Excel is more than just a spreadsheet. Manipulate, visualize, and build reports on your data effectively to support everyday decision-making. This module will cover conditional formatting, pivot tables, writing formulas, and more. Participants will learn how to use tools in Excel more efficiently, and keep up with data analytic skills demanded in the workforce today.

Coaching hours: 4

Participants can expect to spend approximately 12-15 hours beyond the coaching hours on completing this module.

What’s in it for you?

Key competencies:

  1. Format data quickly with shortcuts and conditional formatting.
  2. Apply formulas to simplify data retrieval and manipulation (including VLOOKUP, IF statements, array formulas, text and string functions, etc.).
  3. Visualize data clearly with complex charts.
  4. Create pivot tables and pivot reports.
  5. Prepare data tables, generate simulations, and use the solver.

Inaugural fee: $259 (HST included)