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 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.