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
