Contact Us

Contact Us





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

    Are you an advanced Excel user? Do you need to consolidate data from several worksheets, work with external data, or perform What-IFs? Would you like to learn how to use macros or create rolling charts? This one-day course will teach you all that and a whole lot more with time-saving techniques and formulas. We also dive into Power Query for gathering data quickly and shaping it easily. 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