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

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