Course 5444: What’s New in Microsoft Office Excel 2007

Introduction 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. Objectives At the end of the 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.

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 System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled