713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

Microsoft® Office Excel 2007: Level 2

Training Course Content

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.

Lesson 1: Calculating Data with Advanced Formulas

Topic 1A: Calculate Data Across Worksheets
Topic 1B: Mixed and Absolute Referencing
Topic 1C: Nesting Functions
Topic 1D: Conditional Logic Functions

Lesson 2: Organizing Worksheet Data with Tables

Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort and Filter Worksheet/Table Data
Topic 2D: Calculate Data Using Table Functions

Lesson 3: Using Lookup Functions

Topic 3A: Create and Use Named Ranges
Topic 3B: Manage Named Ranges
Topic 3C: VLOOKUP
Topic 3d: HLOOKUP

Lesson 4: Presenting Data Using Charts

Topic 4A: Create Charts
Topic 4B: Modify Charts
Topic 4C: Incorporate Shapes in Charts
Topic 4D: Create Trendlines

Lesson 5: Analyzing Data Using PivotTables and PivotCharts

Topic 5A: Create a PivotTable
Topic 5B: Create a PivotChart
Topic 5C: Filter Pivot Data
Topic 5D: Analyze Pivot Data

Lesson 6: Enhancing Workbooks

Topic 6A: Customize the Excel Environment
Topic 6B: Manage Themes
Topic 6C: Save a Workspace


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

 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |