Microsoft® Office Excel 2007: Level 2

Course Objective: Students will learn to create templates, sort and filter data, import and export data, analyze data, and work with Excel web tools.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing spreadsheets in Excel. Knowledge of formulas and functions is also necessary (Sum, Min, Max, Average, If, and applying absolute referencing) to be successful in this class. Students can obtain this level of skill through our Level 1 course.

Contact us to discuss if this level is right for you.

What’s New in 2007: Microsoft has a brand new tool for organizing and managing data, which is called the Excel Table. Table features include automatic freeze-panes, easier formatting, and other features that increase ease of use and protection for your data. PivotTables and charting tools have been enhanced to become more user-friendly and powerful. Named ranges can be viewed and edited with the new Name Manager.

Excel 2007 Training Class Outlines:

Excel Level 1 - Fundamentals of Excel
Excel Level 2 - Intermediate Functions and Features
Excel Level 3 - Advanced Tools and Collaboration Features
Excel Level 4 - Advanced Formulas and Functions
Excel Level 5 - Introduction to VBA Macros
Excel Level 6 - Advanced VBA Macros