Microsoft Excel 2007 Online / CBT Training Course

Here you are, with a new version of Excel, but do not know how to work all the new changes and enhancements. Do not get frustrated trying to teach yourself how to use all these new features since our Excel 2007 training course can teach you everything there is to know about the new Excel. This course is taught by subject matter experts who have mastered the new version of one of the best spreadsheet programs around. Our course will teach you how to harness the power that you didn't even know existed and learn simple tricks and techniques.

Available Learning Formats

CD
Online
Network Deployable

Microsoft Excel 2007 Training Outlines

Microsoft Excel 2007 Training via Online

The online Excel 2007 training videos are in full-motion video that makes it seem as if the instructor is actually teaching right in front of you for a more personal learning experience. The online computer training videos are also instructor led where you learn from seeing and doing instead of just reading from a boring textbook. You will view interactive content including animations, step-by-step narrated videos, graphic illustrations and more, and even get hands-on practice with exercises that allow you to get familiar with the program in our Excel 2007 online training course that is also self-paced and self-guided.

Microsoft Excel 2007 CBT Training Videos on CD / DVD

Never have to miss work again with our self-study Excel 2007 CBT course that is done entirely on your computer. You can learn in the comforts of your home or office with our Excel 2007 training CD that is jam-paced with tons of interactive content that makes learning fun and easy. This computer based training course also allows you the freedom to learn on your own time, which is great for busy professionals with little time to spare. The Excel 2007 computer based training videos also provide you with a simulated environment that does not require you to have the program installed on your computer to learn successfully.

Microsoft Excel 2007 Training Outline:

Microsoft Excel 2007 Basic

1.0 Creating a Basic Worksheet

Exploring the User Interface and the Ribbon
Customizing the Quick Access Toolbar
Navigate and Select in Excel
Enter Data and Saving as a Workbook

2.0 Performing Calculations

Creating Basic Formulas
Calculating with Functions
Copying Formulas and Functions

3.0 Modifying a Worksheet

Manipulating Data
Working with Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Checking a Worksheet

4.0 Formatting a Worksheet

Modifying Fonts
Adding Borders and Color to Cells
Change Column Width and Row Height
Applying Number Formats
Using Styles

5.0 Printing Workbook Content

Printing Workbook Contents Using Default Print Options
Setting Page Breaks

6.0 Managing Large Workbooks

Formatting Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Workbooks
Chapter Review Test

Microsoft Excel 2007 Intermediate

1.0 Calculating Data with Advanced Formulas

Managing Cell and Range Names
Calculating Data Across Worksheets
Analyzing Data with Logical and Lookup Functions

2.0 Organizing Worksheet and Table Data

Creating and Modifying Tables
Formatting Tables
Sorting or Filtering Worksheet or Table Data
Calculating Data in a Table or Worksheet

3.0 Presenting Data Using Charts

How to Create a Chart
Modifying Charts
Formatting Charts

4.0 Analyzing Data Using PivotTables and PivotCharts

Creating a PivotTable Report
Analyzing and Modifying a PivotTable
Chapter Review Test

5.0 Inserting Graphic Objects

Inserting and Modifying Pictures and ClipArt
Drawing and Modifying Shapes

6.0 Customizing and Enhancing Workbooks and the Excel Environment

How to Customize the Excel Environment
Customizing Workbooks
Managing Themes
How to Create and Use Templates

Microsoft Excel 2007 Advanced

1.0 Streamlining Workflow

Creating Macros
Adding Macros to the Quick Access Toolbar
Editing a Macro
Using Conditional Formatting
Applying Data Validation to a Worksheet
Updating Worksheet Properties
Modifying Excel Options
Chapter Review Test

2.0 Collaborating with Others

Protecting Files and Sharing Workbooks
Merging Multiple Workbooks
Adjusting Macro Settings
Restricting Document Access
Chapter Review Test

3.0 Auditing Worksheets

Tracing Cell Precedents and Dependents
Troubleshooting Errors in Formulas
Watching and Evaluating Formulas
Creating a Data List Outline
Chapter Review Test

4.0 Analyzing Data

Adding a Trend Line to Charts
Create Scenarios and Performing What-If Analysis
Chapter Review Test

5.0 Working with Multiple Workbook

Create a Workspace
Consolidate Data
Managing Linked Cells in Different Workbooks
Chapter Review Test

6.0 Importing and Exporting Data

Exporting Excel Data
Importing a Table from Word
Importing a Delimited Text File
Chapter Review Test