Course 10283: What's New in Microsoft Excel 2010

Introduction This one-hour course provides you with the skills and knowledge required for managing files effectively and controlling the data within the files in Excel 2010.

Topics covered in this course include:

• Introduction to Office 2010 Applications and Suites
• Enabling Teams to Work Together More Effectively
• Getting Almost Anywhere Access to Your Work
• Visualizing Data Using Improved Charting Capabilities
• Managing Files in Backstage View
• Collaborating in Excel 2010
• Analyzing Data Using PivotTables
• Summarizing Large Data Sets
• Adding Mathematical Equations
• Accessing Excel 2010 Data Over the Web
• Accessing Excel 2010 Data Using a Mobile Device

Student prerequisites:
To get the most benefit the learner must have intermediate-level skills and at least two years of experience using Microsoft Excel in an enterprise environment.
Objectives At the end of the course, students will be able to:

• Recognize the differences among Office 2010 versions and learn about important elements in the Office 2010 interface.
• Identify the new and improved features in the Office 2010 applications.
• Describe the new features in Excel 2010
• Describe how Excel 2010 helps you bring ideas to life.
• Describe how Excel 2010 enables teams to work together more effectively.
• Describe how Excel 2010 provides almost anywhere access to your work.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Introducing Microsoft Office 2010 Module Overview Exploring the Office 2010 Programs and Interface Introduction Introducing Office 2010 Versions and Programs Exploring the Office 2010 Interface Self Test New and Improved Features in Office 2010 Programs Introduction Bring Ideas to Life Work Together Effectively Access Your Work from Almost Anywhere Self Test Module Summary Module Summary Introducing Excel 2010 Module Overview Bringing Ideas to Life Introduction Managing Files in the Backstage View Controlling Paste Options Visualizing Data by Using Improved Charting Capabilities Calculating Results by Using More Accurate Functions Summarizing Large Data Sets Analyzing Data by Using PivotTables Adding Mathematical Equations Self Test Working Together Introduction Collaborating in Excel 2010 Communicating Across Languages Self Test Accessing from Anywhere Introduction Accessing Excel 2010 Data Over the Web Accessing Excel 2010 Data Using a Mobile Device Self Test Module Summary Module Summary About the Author Glossary Module Overview Glossary Glossary 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