Name:
Intermediate Microsoft Excel - SOLD OUT!
Date:
January 17, 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:
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
Course Outline:
- Various methods of selecting cells
- Creating range names
- Absolute reference
- Working with logical formulas
- Conditional formatting
- Inserting comments
- Track changes – the snitch report!
- Working & printing large spreadsheets
- Using data sort & filters
- Creating an outline
- Goal seek
- Creating scenarios
- Macros
- Creating subtotals
- Grouping spreadsheets
- Advanced linking of spreadsheets
Prerequisite: Introduction to Excel and a good working knowledge of the computer.