Fully Customizable Courseware For Trainers

Microsoft Excel 2010

Easily edit and rebrand as your own


Buy Now DEMO
Download a Free Sample DOWNLOAD
Materials for
hours of
Easily edited

Easily edit and rebrand as your own

Our mission is to provide you with the best possible courseware so you can teach incredible classes and workshops

High quality course content - written for you

Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.

Enjoy confidence in the classroom

Facilitate perfect workshops everytime with high-quality training material with all the training components you need.

Save time & money with pre-written materials

Focus your attention on the training and we'll take care of the materials.

Course description+

This Microsoft Excel 2010: Part Three course concludes our three-part Microsoft Excel 2010 series designed to prepare students for Exams 77-882 and 77-888 of the Microsoft Office Specialist program.

Interested in what this Microsoft Excel 2010: Part Three course covers? Here’s a brief look:

  • Automating worksheet functionality with macros
  • Validating and auditing data
  • Using What-If analysis tools, such as Goal Seek, Solver, and the Scenario Manager
  • Consolidating and linking data
  • Creating Excel forms
  • Importing and exporting data

If you’re looking for high-quality, customizable training materials at a great price, don’t wait! Purchase your copy of this Microsoft Excel 2010 training package today.

Course outline+

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1: Automating Worksheet Functionality

TOPIC A: Update Workbook Properties

Workbook Properties

Activity 1-1

TOPIC B: Create and Edit a Macro


The Record Macro Dialog Box

Macro Naming

Visual Basic for Applications

Macro Security Settings

Activity 1-2

TOPIC C: Apply Conditional Formatting

Conditional Formatting

Conditional Formats

The Conditional Formatting Rules Manager Dialog Box

The New Formatting Rule Dialog Box

Clear Rules

Activity 1-3

TOPIC D: Add Data Validation Criteria

Data Validation

The Data Validation Dialog Box

Activity 1-4


Review Questions

Lesson 2: Auditing Worksheets

TOPIC A: Trace Cells

The Trace Cells Feature

Tracer Arrows

Activity 2-1

TOPIC B: Troubleshoot Invalid Data and Formula Errors

Invalid Data

The Error Checking Command

Error Types

Activity 2-2

TOPIC C: Watch and Evaluate Formulas

The Watch Window

Formula Evaluation

Activity 2-3

TOPIC D: Create a Data List Outline


The Outline Group

Activity 2-4


Review Questions

Lesson 3: Analyzing Data

TOPIC A: Create Sparklines


Types of Sparklines

The Sparkline Tools – Design Tab

Activity 3-1

TOPIC B: Create Scenarios


About What-If Analysis

The Scenario Manager Dialog Box

Activity 3-2

TOPIC C: Perform a What-If Analysis

Add-In Types

The Goal Seek Tool

The Solver Tool

Activity 3-3

TOPIC D: Perform a Statistical Analysis with the Analysis ToolPak

Analysis ToolPak

The Data Analysis Dialog Box



Random Number Generator

Rank and Percentile

Activity 3-4


Review Questions

Lesson 4: Working with Multiple Workbooks

TOPIC A: Create a Workspace


Activity 4-1

TOPIC B: Consolidate Data

Data Consolidation

The Consolidate Dialog Box

Consolidation Functions

Activity 4-2

TOPIC C: Link Cells in Different Workbooks

External References

Activity 4-3

TOPIC D: Merge Workbooks

The Compare and Merge Workbooks Feature

Activity 4-4


Review Questions

Lesson 5: Exporting Excel Data

TOPIC A: Export Excel Data

Export Formats

Sharing Workbooks

Activity 5-1

TOPIC B: Import a Delimited Text File

Importing Process

The Get External Data Group

Delimited Text Files

Methods of Importing Text Files

Activity 5-2

TOPIC C: Integrate Excel Data with the Web

The File Publishing Process

Publish as Web Page Dialog Box

Activity 5-3

TOPIC D: Create a Web Query

Web Queries

The New Web Query Dialog Box

Activity 5-4


Review Questions

Lesson 6: Importing and Exporting XML Data

TOPIC A: Import and Export XML Data


XML Components

XML Schemas

XML Maps

The XML Source Task Pane

Import and Export XML Data

Activity 6-1


Review Questions

Lesson 7: Creating Excel Forms

TOPIC A: Create Excel Forms

What is a Form?

Types of Controls

Create Excel Forms

Activity 7-1


Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson Lab 1-2

Lesson 2

Lesson Lab 2-1

Lesson Lab 2-2

Lesson 3

Lesson Lab 3-1

Lesson Lab 3-2

Lesson 4

Lesson Lab 4-1

Lesson Lab 4-2

Lesson 5

Lesson Lab 5-1

Lesson Lab 5-2

Lesson 6

Lesson Lab 6-1

Lesson 7

Lesson Lab 7-1

Course Wrap-Up

Post-Course Assessment

Course Summary


Keyboard Shortcut Quick Reference Sheet

Mapping to Microsoft Office Excel 2010, Exam 77-882

Mapping to Microsoft Office Excel 2010 Expert, Exam 77-888



What you get+

Instructor Guide

Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.

Student Manual

Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the student version of the course you will be teaching.

Exercise Workbook

Whether or not you choose to introduce exercises into your training is up to you as the facilitator. In case you want to do this Velsoft offers you an Exercise Workbook (also customizable) that is specific to the course you are offering.

Sample Files

Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.

Powerpoint Deck

Courseware from Velsoft is designed to give you everything you need for use in the classroom or workshop. This includes the PowerPoint versions of all the courses, prepared for you in advanced.

Quick Reference Guide

Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quest Reference Guide summarizes the most important elements in each courseware title down to two pages.

The best courseware in the world has Velsoft on the cover.

Our goal is to improve the daily life of those who train the world.

Velsoft empowers training providers with course material and educational technologies that get results.

Microsoft Excel 2010


Instant download access
Buy Now
Fully customizable

Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.

Unlimited reprinting

Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.

Unlimited users

Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.

No annual renewal fees

This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.



Courseware you can customize.


View an eLearning Course


Download a SCORM sample to try in your LMS


View an eLearning Course


Available as an eLearning Course



eLearning you can customize.



Courseware you can customize.


Safe & Inclusive Workplace

By Velsoft


Seeing Double

August Only



Courseware you can customize.