Intermediate Excel I - 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.

 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 8 practice examples you will work with in this 6-hour course. With the course divided into 3 – 2 hour sessions, you are  certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!