Name:
Advanced Excel - October 2022
Date:
October 31, 2022
Time:
8:00 AM - 10:30 AM EDT
Website:
http://GreaterReading.org
Registration:
Register Now
Event Description:
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:
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