Whats new in Excel 2007: Course 544

In this online course you will learn about the new features and functionality in the latest version of Microsoft Office Excel. There have been substantial changes to the user interface in this spreadsheet application, and this course can help you get up to speed quickly.

This course covers the new features that enable you to organize and analyze business information in Excel, as well as to collaborate with others by sharing your business information using Office Excel Services and Microsoft Office Sharepoint Server 2007.

This course is 1 hour long.

Objectives:

At the end of this course, students will be able to:
Identify the new interface elements of Microsoft Office Excel 2007.
Organize business information by using Excel 2007.
Analyze business information by using Excel 2007.
Share and manage business information by using Excel 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 5444: What's New in Microsoft Office Excel 2007

Modules & Lessons
Course Overview
Module Introduction
Navigation Overview
Course Information
What's New in Microsoft Office Excel 2007
Module Introduction
Exploring the New Fluent Interface
Lesson Introduction
The Fluent Interface
Tasks and Tabs
Self Test
Organizing Business Information
Lesson Introduction
Insert and Format Tables
External Sources of Business Information
Enhanced Formula-Writing Capabilities
How to Create Professional-Looking Reports
Lab: Creating Professional-Looking Charts
Self Test
Analyzing Business Information
Lesson Introduction
Analyze Data by Using Conditional Formatting
Lab: Creating PivotTable and PivotChart Reports
Self Test
Sharing and Managing Business Information
Lesson Introduction
Benefits of Publishing Spreadsheets
Different Ways to Interact with a Spreadsheet in a Browser
User Permissions in Excel 2007
What Are Business Intelligence Dashboards?
What Are Snapshots?
Self Test
Module Summary
Glossary
Module Introduction