Course 10394: Advanced Skills in Microsoft Excel 2010

Introduction

This 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