Contact Us

Contact Us





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

    Get ready to ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener. Unlike Intermediate Excel courses found elsewhere, this workshop teaches you features you will actually use and remember. 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.