Contact Us

Contact Us





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

    Toronto Excel users ready to go significantly further will cover the full advanced toolkit here -- multi-sheet consolidation, external data connections, What-If analysis, macros, rolling charts, and Power Query. The skills that turn a capable Excel user into the person the rest of the team comes to with data problems. Prerequisite: Knowledge of Excel 2

    You will become comfortable with:

      • » Using Power Query to reshape your data with UnPivot
        » Using Power Query to effectively transform “unclean” data for Pivot Table analysis
        » Using Power Query to efficiently consolidate data from multiple sheets
        » Goal Seek
        » Advanced Charting tips
        » XLOOKUP, FILTER, INQUE
        » Pivot Table from Data Model
        » Using Offset to create rolling charts
        » Macro recorder examples
        » DSUM
        » and more…

      You will benefit most from this course if you:

        • » Consider yourself an intermediate/strong Excel user and want to ramp up your productivity
          » Work with data sourced outside Excel or data that may need “cleansing”
          » Are comfortable with functions such as: VLOOKUP, IF, and know how to use named ranges
          » Know Excel tables, filtering, structured references
          » Know basic conditional formatting
          » Have built and used basic Pivot Tables