Advanced Excel
Name:
Advanced Excel
Date:
September 17, 2021
Time:
8:00 AM - 10:30 AM EDT
Website:
http://GreaterReading.org
Registration:
Register Now
Event Description:
Program Objective: Participants will learn how to create more advanced charts, database functions, logical formulas, creating range names, and working with large spreadsheets more efficiently.
Course Outline:
Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
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
Participants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
