Microsoft Excel – Level 3

You will become comfortable with:

• » Using Power Query to efficiently consolidate data from multiple sheets

 

• » Using Power Query to effectively transform “unclean” data for Pivot Table analysis

 

• » Establishing data relationships to creating Pivot Tables sourced from the Data Model

 

• » Advanced conditional formatting with rules

 

• » What-IFs using Scenarios, Goal Seek, and Solver

 

• » 3D formulas

 

• » Macro recorder to save time performing repetitive tasks

 

• » Using Offset to create rolling charts

 

• » Various sought-after Tips and Tricks (no macros)

 

• » Exciting Dynamic Array formulas (with Excel 365 or later)

 

» 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