Course 10394: Advanced Skills in Microsoft Excel 2010

Introduction This online course is designed to help you customize and manage the Excel 2010 interface as well as know how to manage, manipulate, and format data.

Topics covered in this course include:

• Setting Excel 2010 Options
• Manipulating Worksheet Data
• Creating and Editing Named Ranges
• Working with Solver and PowerPivot Add-Ins
• Working with External Data
• Creating and Editing Web Queries
• Creating Sparklines and Trendlines
• Analyzing PivotTable Data
• Creating and Editing Macros
• Running a Macro
• Workbook Protection Levels

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:

• Customize Excel 2010.
• Work with worksheet data.
• Work with external data.
• Work with tables and charts.
• Automate workbooks.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Working with Advanced Features of Excel 2010 Module Overview Customizing Excel 2010 Introduction Setting Excel 2010 Options Defining Workbook Protection Levels Customizing Worksheet Views Self Test Working with Worksheet Data Introduction Manipulating Worksheet Data Creating Named Ranges Managing Named Ranges Inserting Equations Analyzing Data Working with a PowerPivot Workbook Lab: Working with Worksheet Data Self Test Working with External Data Introduction Defining and Editing External Data Connections Working with XML Data Creating and Editing Web Queries Lab: Working with External Data Self Test Working with Tables and Charts Introduction Working with Charts Creating a Sparkline Chart Creating Different Types of Charts Adding Trendline to a Chart Analyzing Pivot Table Data Lab: Working with Tables and Charts Self Test Automating Workbooks Introduction Introduction to Macros Creating a Macro Editing a Macro Running and Deleting a Macro Lab: Working with Macros 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