Name:
Advanced Excel - SOLD OUT!
Date:
January 12, 2022
Time:
8:00 AM - 10:30 AM EST
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.