Fully Customizable Courseware For Trainers
Microsoft Excel 2010: Part Three
DOWNLOAD A FREE SAMPLE
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.
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
Macros
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
Summary
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
Outlines
The Outline Group
Activity 2-4
Summary
Review Questions
Lesson 3: Analyzing Data
TOPIC A: Create Sparklines
Sparklines
Types of Sparklines
The Sparkline Tools – Design Tab
Activity 3-1
TOPIC B: Create Scenarios
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
Anova
Correlation
Random Number Generator
Rank and Percentile
Activity 3-4
Summary
Review Questions
Lesson 4: Working with Multiple Workbooks
TOPIC A: Create a Workspace
Workspaces
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
Summary
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
Summary
Review Questions
Lesson 6: Importing and Exporting XML Data
TOPIC A: Import and Export XML Data
XML
XML Components
XML Schemas
XML Maps
The XML Source Task Pane
Import and Export XML Data
Activity 6-1
Summary
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
Summary
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
Appendices
Keyboard Shortcut Quick Reference Sheet
Mapping to Microsoft Office Excel 2010, Exam 77-882
Mapping to Microsoft Office Excel 2010 Expert, Exam 77-888
Glossary
Index
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
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
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
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 for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
