Fully Customizable Courseware For Trainers
Microsoft Excel 2010: Part One
DOWNLOAD A FREE SAMPLE
This customizable Microsoft Excel 2010: Part One training package is one of three courses that, when delivered together, will help students prepare for Microsoft?Office Specialist Exams 77-882 and 77-888.
Here’s a sneak peek at the lessons included in this Microsoft Excel 2010: Part One manual:
- Getting Started with Microsoft Excel 2010
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbook Contents
- Managing Large Workbooks
- Customizing the Excel Environment
Trainers love receiving a complete package that they can use however they like. You can take the materials and train right away, or pick and choose the’sections that you want to teach. It’s all up to you!
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with Microsoft Excel 2010
TOPIC A: Identify the Elements of the Excel Interface
Microsoft Excel 2010
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
The Excel Interface
Activity 1-1
TOPIC B: Create a Basic Worksheet
The Ribbon
The Backstage View
Data Types
Excel 2010 File Formats
The Save and Save As Commands
Compatibility Mode
The Convert Option
The Compatibility Checker
Activity 1-2
TOPIC C: Use the Help System
The Excel Help Window
The Table of Contents Pane
Activity 1-3
Summary
Review Questions
Lesson 2: Performing Calculations
TOPIC A: Create Formulas in a Worksheet
Excel Formulas
The Formula Bar
Elements of an Excel Formula
Common Mathematical Operators
The Order of Operations
Activity 2-1
TOPIC B: Insert Functions in a Worksheet
Functions
The Function Library
Common Functions in Excel
The Formula AutoComplete Feature
Activity 2-2
TOPIC C: Reuse Formulas
The Cut, Copy, and Paste Commands
Paste Special Options
Relative References
Absolute References
Mixed References
Activity 2-3
Summary
Review Questions
Lesson 3: Modifying a Worksheet
TOPIC A: Manipulate Data
The Undo and Redo Commands
The AutoFill Feature
AutoFill Options
The Transpose Option
Live Preview
The Clear Button
Activity 3-1
TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
The Insert and Delete Options
Column Width and Row Height Alternation Methods
The Hide and Unhide Options
Activity 3-2
TOPIC C: Search For and Replace Data
Cell Names and Range Names
The Find Command
The Replace Command
Activity 3-3
TOPIC D: Spell Check a Worksheet
The Spelling Dialog Box
Activity 3-4
Summary
Review Questions
Lesson 4: Formatting a Worksheet
TOPIC A: Modify Fonts
Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Galleries
Live Preview and Formatting
The Mini Toolbar
Activity 4-1
TOPIC B: Add Borders and Color to Cells
Border Options
Fill Options
Sheet Backgrounds
Paste Options
Activity 4-2
TOPIC C: Apply Number Formats
Number Formats
Number Formats in Excel
Custom Number Formats
Activity 4-3
TOPIC D: Align Cell Contents
Alignment Options
The Indent Commands
The Wrap Text Command
Orientation Options
The Merge & Center Options
Activity 4-4
TOPIC E: Apply Cell Styles
Cell Styles
The Style Dialog Box
Activity 4-5
Summary
Review Questions
Lesson 5: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
The Print Options in the Backstage View
The Page Setup Dialog box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
Activity 5-1
TOPIC B: Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Titles
Scaling Options
Activity 5-2
Summary
Review Questions
Lesson 6: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
Tab Formatting Options
Activity 6-1
TOPIC B: Manage Worksheets
Grouped Worksheets
Methods for Repositioning Worksheets
Methods for Inserting or Deleting Worksheets
The Hide and Unhide Worksheet Options
Worksheet References in Formulas
Activity 6-2
TOPIC C: Manage the View of Worksheets and Workbooks
The Split Command
The Freeze Panes Options
The Arrange All Command
The Arrange Windows Dialog Box
The View Side by Side Command
The Switch Windows Command
The New Window Command
Activity 6-3
Summary
Review Questions
Lesson 7: Customizing the Excel Environment
TOPIC A: Customize General and Language Options
The Excel Options Dialog Box
The General Category
The Language Category
Activity 7-1
TOPIC B: Customize Formula Options
The Formulas Category
Activity 7-2
TOPIC C: Customize Proofing and Save Options
The Proofing Category
The Save Category
Version Control
Activity 7-3
TOPIC D: Customize the Ribbon and Quick Access Toolbar
The Customize Ribbon Category
The Quick Access Toolbar Category
Activity 7-4
TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
What Are Add-ins?
The Add-Ins Category
Activity 7-5
TOPIC F: Customize Advanced and Trust Center Options
The Advanced Category
The Trust Center Category
Activity 7-6
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson 2
Lesson Lab 2-1
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 6
Lesson Lab 6-1
Lesson Lab 6-2
Lesson 7
Lesson Lab 7-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Next Steps
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.
