Intermediate Excel 2007 - Course Outline

Back to Software Training

Program Objective: Students will learn how to create more advanced Charts, database functions, logical formulas, creating Range Names, and working with large spreadsheets more efficiently in the new 2007 format.

 You will learn the following items:

• Various methods of selecting cells
• Creating Range Names
• Working with Logical & IF Formulas
• Inserting Comments
• Adding Auto & Conditional Formatting
• Working & Printing large Spreadsheets
• Using Data Sort & Filters
• Working with Static cells
• Grouping Spreadsheets
• Advanced Linking of Spreadsheets

There are 11 practice examples you will work with in this 8-hour course. With the course divided into 4 – 2 hour sessions, you are  certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!