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.
Various methods of selecting cells
Creating Range Names
Working with Logical formulas
Track Changes – the snitch report!
Working & Printing large Spreadsheets
Using Data Sort & Filters
Creating an Outline
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.