Course 10393: Intermediate Skills in Microsoft Excel 2010

Introduction This online course is designed to help manage workbooks in Excel 2010.

Topics covered in this course include:

• Editing Worksheets
• Adding Headers, Footers, and Hyperlinks
• Formatting and Editing Cells
• Conditional Formatting
• Analyzing Data Lists
• Using What-If Analysis
• Performing Calculations
• Creating, Editing, and Formatting PivotTables
• Creating and Editing Charts
• Setting Excel 201 Options and Workbook Properties
• Linking and Embedding Objects
• Sharing Workbooks

Student Prerequisites:
Learners must have the basic skills of using Excel 2003. These include basic tasks such as opening a workbook, formatting text, and saving a workbook. It is recommended that the learners complete the course 4697 that introduces the Fluent Interface (ribbon).
Objectives At the end of the course, students will be able to:

• Enhance Excel 2010 workbooks.
• Work with worksheet data.
• Work with tables and charts.
• Use the advanced features of Excel 2010.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Managing Workbooks in Excel 2010 Module Overview Enhancing Workbooks Introduction Modifying Worksheets Adding Headers and Footers Editing Worksheets Working with Office Themes Formatting and Editing Cells Conditional Formatting Inserting Hyperlinks Formatting Cell Data Self Test Working with Data Introduction Extending a Data Series Analyzing Data by Using Data Lists Cleaning Up and Outlining Data Lists Using What-If Analysis Performing Calculations Working with Data Lists Self Test Working with Tables and Charts Introduction Creating and Editing Pivot Tables Formatting PivotTables Analyzing PivotTable Data Working with a PivotTable Working with PivotCharts Editing Charts Using Table Styles Using PivotTables Self Test Working with Advanced Features of Excel 2010 Introduction Setting Excel Options Setting Workbook Properties Customizing the Ribbon Customizing the Quick Access Toolbar The Track Changes Feature Linking and Embedding Objects Sharing a Workbook Working with the Advanced Features Self Test Module Summary Module Summary 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