Contact Us

Contact Us





    Microsoft Excel – Intermediate 1 Day | 6 hours | $350 PLUS TAX

    The step from knowing Excel basics to using it well is bigger than most Toronto professionals expect. This course bridges that gap -- robust formulas, Pivot Tables, charts, data analysis -- with exercises built around the business scenarios Toronto professionals actually encounter. Hands-on throughout. Prerequisite: Knowledge of Excel 1

    You will become comfortable with:

      » Date and Time arithmetic
      » Named Ranges
      » Defined Names
      » IF, Logical Functions
      » IFS, IFerror
      » VLOOKUP, XLOOKUP
      » Conditional formatting
      » SUMIFS & DSUM
      » Excel tables
      » Sorting, Filtering
      » Pivot Tables; Slicers; Dashboards
      » Charts

    You will benefit most from this course if you:

      » Need to organize/manage/analyze lists of data or items
      » Are comfortable using Excel ribbons and formatting cells
      » Have written basic Excel formulas
      » Know about the $ (dollar sign) in formulas for absolute referencing
      » Know basic data filtering+sorting
    More dates available.