Advanced Excel - July 2024

Program Objective:
Participants will learn the most rewarding features of Excel. Please note the term “Advanced” does not refer to a high level of difficulty, but just a continuation of the Intermediate class. This is truly the “cool” class, as you get to see a lot of neat things you can do in 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