Advanced Excel PM Session - July 2024

It is important to note that Advanced Excel© is not a higher level of difficulty, it is just a continuation of the skills learned in the Intermediate Excel© course. This is truly the "cool" class, as you get to see a lot of neat things you can do in Excel©! Some skills that will be learned in Advanced Excel© include creating a shared workspace, consolidating workbooks, using the text to columns command, creating a histogram and much more! This course serves as a culmination of all that was learned in Intro and Intermediate Excel©. 

Course Outline:

• Everything you can do in pivot tables

• Consolidating workbooks

• Creating a shared workspace

• Creating a saved workspace

• Data validation in range names

• Remove duplicate records

• Outlining the spreadsheet

• Working with advanced macros

• Using the text to columns command

• Protecting cells that contain formulas

• Creating a Pareto chart

• Creating a histogram

• Advanced goal seek

• Working with V lookup functions