Collection CBL33: Excel 2003 Complete Training by Microsoft
Course Description
This 9-hour collection contains the following courses:
Course 4106: Core Training for Microsoft Office Excel 2003
Course 4101: Advanced Training for Microsoft Office Excel 2003

System Requirements:
Pentium II 400 MHz
256MB RAM
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard

Subscription: 1 year.

Course 4106: Core Training for Microsoft Office Excel 2003

Pre-Assessment

Getting to Know Excel
Lesson Introduction
Introducing Excel
Saving Changes to an Existing Workbook
Organizing Data
Creating and Using Lists
Creating a Workbook
Checking and Correcting Data

Setting Up a Workbook
Lesson Introduction
Making Workbooks Easier to Work With
Making Data Easier to Read
Adding a Graphic to a Worksheet
Managing Comments
Naming Groups of Data

Performing Calculations on Data
Lesson Introduction
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
Rounding Results in Statistical Functions

Changing Document Appearance
Lesson Introduction
Changing the Appearance of Data
Applying Styles and Formats to Data
Making Numbers Easier to Read
Making Printed Worksheets Easier to Read
Positioning Data on a Printed Page

Filtering and Reordering Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Sorting a Data List
Organizing Data into Groups

Combining Data from Multiple Sources
Lesson Introduction
Creating a Template from an Existing Worksheet
Working with More Than One Set of Data
Linking Data to Other Workbooks
Grouping Multiple Workbooks

Creating Charts
Lesson Introduction
Creating a Chart
Customizing Chart Labels and Numbers
Creating Diagrams

Printing
Lesson Introduction
Printing Worksheets
Printing Part of a Worksheet
Printing a Chart

Collaborating in Excel
Lesson Introduction
Saving a Workbook for the Web
Comparing Workbooks
Using Smart Tags to Acquire Real-Time Data

Post Assessment

Course 4101: Advanced Training for Microsoft Office Excel 2003

Pre-Assessment

Working with Excel and Other Office Programs
Lesson Introduction
Creating a Template from an Existing Worksheet
Modifying Workbook Settings
Using Custom Data Formats
Sharing Data Between Excel and Other Office Programs

Organizing Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Performing Calculations on Filtered Data
Validating Data
Changing Data Appearance Based on Value
Summarizing and Grouping Multiple Sets of Data

Performing Calculations on Data
Lesson Introduction
Naming Cell Ranges
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations

Analyzing Data
Lesson Introduction
Defining and Editing Alternative Data Sets
Defining Multiple Alternative Data Sets
Working with Goal Seek and Solver
Analyzing Data with Descriptive Statistics

Working with PivotTables
Lesson Introduction
Creating and Using PivotTables
Editing PivotTables
Creating PivotTables from External Data

Working with Graphics and Charts
Lesson Introduction
Formatting and Resizing Graphics
Creating a Chart
Creating a Dynamic Chart Using PivotCharts

Working with Database Data and Macros
Lesson Introduction
Locating and Retrieving Data from a Database
Summarizing List Data
Introducing Macros
Creating and Modifying Macros

Publishing on the Web and Using XML
Lesson Introduction
Converting an Excel Workbook to XML
Using XML Data Capabilities and Retrieving Web Data
Publishing Worksheets and PivotTables on the Web

Collaborating in Excel
Lesson Introduction
Sharing and Comparing Workbooks
Managing Comments
Tracking and Managing Changes
Protecting Workbooks and Worksheets

Post Assessment
Course Details
Course Length: 9 hours

Collection CBL17: Office 2007 Library
by Microsoft

Course Description

This great value collection of online courses covers the core skills and knowledge you will need to get the most out of Microsoft Office System 2007. It is also ideal training for the MCAS exams for Word, Excel, PowerPoint, Outlook and Access 2007.

This collection of courses is 54 hours long.

This collection contains the following:
Collection 5258: Core Training for Microsoft Office Word 2007
Collection 5259: Core Training for Microsoft Excel 2007
Collection 5260: Core Training for Microsoft Office PowerPoint 2007
Collection 5261: Core Training for Microsoft Outlook 2007
Collection 5262: What's New in the 2007 Microsoft Office System
Collection 5263: Core Training for Microsoft Office Access 2007
Collection 5264: Core Training for Microsoft Office Project 2007
Collection 5265: Core Training for Microsoft Office Visio 2007
Collection 5267: Core Training for Microsoft Office OneNote 2007
Collection 5268: Core Training for Microsoft Office InfoPath 2007

System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Office 2007 Standard Edition;
Flash Player 7.0 or higher;
Speakers and soundcard.

Please note you will need Office 2007 installed on your computer to carry out the labs included in these courses.

Subscription: 1 year
Course Details
Course Length: 54 hours

Collection 5262: What's New in the 2007 Microsoft® Office System
by Microsoft

Course Description

This collection of online courses covers the new features and functionality in the 2007 Microsoft Office release.

This collection of courses is 8 hours long.

This collection contains the following:

Course 5443: What's New in Microsoft Office Access 2007
Course 5444: What's New in Microsoft Office Excel 2007
Course 5445: What's New in Microsoft Office InfoPath 2007
Course 5446: What's New in Microsoft Office OneNote 2007
Course 5447: What's New in Microsoft Office Outlook 2007
Course 5448: What's New in Microsoft Office PowerPoint 2007
Course 5449: What's New in Microsoft Office Word 2007
Course 5450: What's New in Microsoft Office Visio 2007

System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

Subscription: 1 year
Course Details
Course Length: 8 hours

Collection CBL14: Core Training for Office 2007 Standard Edition (Word, Excel, PowerPoint, Outlook)
by Microsoft

Course Description

This collection of online courses covers the core skills and knowledge you will need to get the most out of Microsoft Office System 2007 Standard Edition. It is also ideal training for the MOS (formerly known as MCAS) exams for Word, Excel, PowerPoint and Outlook 2007.

This collection of courses is 24 hours long.

This collection contains the following:
Collection 5258: Core Training for Microsoft® Office Word 2007
Collection 5259: Core Training for Microsoft® Office Excel® 2007
Collection 5260: Core Training for Microsoft® Office PowerPoint® 2007
Collection 5261: Core Training for Microsoft® Office Outlook® 2007

System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Office 2007 Standard Edition;
Flash Player 7.0 or higher;
Speakers and soundcard.

Please note you will need Word, Excel, PowerPoint and Outlook 2007 installed on your computer to carry out the labs included in this course.

Subscription: 1 year.
Course Details
Course Length: 24 hours

Collection 10359: What's New in Microsoft Office 2010 Applications
by Microsoft

Course Description

This twelve-hour collection provides you with the skills and knowledge required to familiarize yourself with the new and improved features in Microsoft Office 2010.

This collection includes the following courses:
Course 10280: What's New in Microsoft Outlook 2010
Course 10281: What's New in Microsoft Word 2010
Course 10282: What's New in Microsoft PowerPoint 2010
Course 10283: What's New in Microsoft Excel 2010
Course 10284: What's New in Microsoft Office 2010
Course 10395: What's New in Microsoft Access 2010
Course 10396: What's New in Microsoft InfoPath 2010
Course 10397: What's New in Microsoft OneNote 2010
Course 10398: What's New in Microsoft Project 2010
Course 10399: What's New in Microsoft Publisher 2010
Course 10400: What's New in Microsoft SharePoint Designer 2010
Course 10402: What's New in Microsoft Visio 2010

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard

Subscription: 1 year.
Course Details
Course Length: 12 hours

Collection CBL59: Beginner Skills in Office 2010 (Word, Excel, PowerPoint, Outlook)
by Microsoft

Course Description

This 9-hour collection will help you to get started in using Word, Excel, PowerPoint and Outlook 2010.

This collection contains the following:
Course 4697: Introduction to the New Microsoft Office Fluent User Interface
Course 10294: Beginner Skills in Microsoft Word 2010
Course 10296: Beginner Skills in Microsoft Excel 2010
Course 10295: Beginner Skills in Microsoft PowerPoint 2010
Course 10293: Beginner Skills in Microsoft Outlook 2010

Student Prerequisites:
Learners familiar with Office 2003 or earlier should complete Course 4697: Introduction to the New Microsoft Office Fluent User Interface before taking the other courses in this collection.

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard
To use the local labs included with the course, you will also need Office 2010 installed on your computer.

Subscription: 1 year.
Course Details
Course Length: 9 hours

Collection CBL58: Skills Training for Office 2010 (Word, Excel, PowerPoint, Outlook)
by Microsoft

Course Description

This collection will you teach you core skills and knowledge on Word, Excel, PowerPoint and Outlook 2010.

This collection contains the following:
Course 4697: Introduction to the New Microsoft Office Fluent User Interface
Collection 10357: Skills Training for Microsoft Word 2010
Collection 10358: Skills Training for Microsoft Excel 2010
Collection 10351: Skills Training for Microsoft PowerPoint 2010
Collection 10350: Skills Training for Microsoft Outlook 2010

Student Prerequisites:
Learners familiar with Office 2003 or earlier should complete Course 4697: Introduction to the New Microsoft Office Fluent User Interface before taking the other courses in this collection.

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard
To use the local labs included with the course, you will also need Office 2010 installed on your computer.

Subscription: 1 year.
Course Details
Course Length: 20 hours