Name:
Advanced Excel
Date:
September 1, 2020
Time:
8:00 AM - 10:30 AM EDT
Website:
http://GreaterReading.org
Registration:
Online registration for this event has been closed, please call 610.376.6766 to register.
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:
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
Participants will work on 11 practice examples throughout the 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:
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
Participants will work on 11 practice examples throughout the 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.