Fully Customizable Courseware For Trainers
Microsoft Office Excel 2010: Basic
DOWNLOAD A FREE SAMPLE
Microsoft Office Excel 2010: Basic customizable courseware training materials for Office Excel 2010 has been professionally designed to provide instructors and students with the best resource available for learning how to use the program. Interacting with Office Excel 2010 can be a very intimidating task. Learners can quickly become overwhelmed with the thousands of possibilities for organizing information. As well, transforming data into a workbook can be a critical step to streamlining business practices, and users need to know how to do it correctly.
The format of our Office Excel 2010 training materials ensure that instructors and students can easily follow the flow of information; step by step. Even through the most advanced applications of Office Excel 2010, students and instructors can easily navigate the sections of the course. Instructors can progress with training at a comfortable rate for the class. Students are able to understand the new information, before moving on to the next section.
Using our customizable Microsoft Office Excel 2010: Basic Courseware, instructors will be able to demonstrate to their students effective methods for using all of the features Office Excel 2010 has to offer. Our Courseware for Microsoft Office Excel 2010 provides instructors and students with accurate and resourceful “how-to pictures”. The visual aid of “screen shots” included in our Courseware demonstrates to users exactly where and how to access these options. The”screen shots” act as a personal trainer, showing users the correct way to perform the functions of the program.
Calculating results has never been so easy, using Office Excel 2010. Training instructors will be absolutely pleased to give their learners the best training experience for Office Excel 2010. After using the customizable Office Excel 2010 Courseware, users will be proficient in understanding the complexities of the program.
Introduction
Prerequisites
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Office Excel 2010?
What's New in Excel 2010?
Opening Excel
Interacting with Excel
Closing Excel
Step-By-Step
Skill Sharpener
Lesson 1.2: About Workbooks
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Step-By-Step
Skill Sharpener
Lesson 1.3: Exploring your Workbook
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
Using Zoom
Step-By-Step
Skill Sharpener
Lesson 1.4: Getting Help with Excel
Opening Help
Using the Help Screen
The Help Toolbar
Searching for Help
Online Help vs. Offline Help
Using the Table of Contents
Getting Help in a Dialog Box
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: The Excel Interface
Lesson 2.1: The Quick Access Toolbar and File Menu
The Default QAT Commands
Adding Commands
Removing Commands
Customizing the Toolbar
Using the File (Backstage) Menu
Step-By-Step
Skill Sharpener
Lesson 2.2: The Home Tab
Understanding Tabs and Groups
Clipboard Commands
Font Commands
Alignment Commands
Number Commands
classs Commands
Cells Commands
Editing Commands
Step-By-Step
Skill Sharpener
Lesson 2.3: The Insert Tab
Tables Commands
Illustrations Commands
Charts Commands
Sparklines Commands
Filter Commands
Links Commands
Text Commands
Symbol Commands
Step-By-Step
Skill Sharpener
Lesson 2.4: The Page Layout Tab
Themes Commands
Page Setup Commands
Scale to Fit Commands
Sheet Options Commands
Arrange Commands
Step-By-Step
Skill Sharpener
Lesson 2.5: The Formulas Tab
The Functions Library
Defined Names Commands
Formula Auditing Commands
Calculation Commands
Step-By-Step
Skill Sharpener
Lesson 2.6: The Data Tab
Get External Data Commands
Connections Commands
Sort and Filter Commands
Data Tools Commands
Outline Commands
Step-By-Step
Skill Sharpener
Lesson 2.7: The Review Tab
Proofing Commands
Language Commands
Comments Commands
Changes Commands
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Excel Basics
Lesson 3.1: Working with Excel
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing your Worksheet
Step-By-Step
Skill Sharpener
Lesson 3.2: Basic Excel Features
AutoFill
AutoSum
AutoComplete
Working with Basic Formulae
Step-By-Step
Skill Sharpener
Lesson 3.3: Moving your Data
Dragging and Dropping Cells
How to Cut, Copy, and Paste Cells
How to Cut, Copy, and Paste Multiple Cells
Using the Clipboard
Using Paste Special
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Step-By-Step
Skill Sharpener
Lesson 3.4: Custom Actions and Options Buttons
What are Custom Actions?
Setting Custom Action Options
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Step-By-Step
Skill Sharpener
Lesson 3.5: Editing Tools
Using AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments
Step-By-Step
Skill Sharpener
Section 3: Case Study
Section 3: Review Questions
Section 4: Editing your Workbook
Lesson 4.1: Modifying Cells and Data
Changing the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Step-By-Step
Skill Sharpener
Lesson 4.2: Cell Formatting
Conditional Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Step-By-Step
Skill Sharpener
Lesson 4.3: Enhancing a Worksheet's Appearance
Adding Patterns and Colors
Adding Borders
Working with classs
Working with Themes
Step-By-Step
Skill Sharpener
Lesson 4.4: Working with Charts, Part 1
Creating a Chart
Styling Charts with the Design Tab
Modifying Charts with the Layout Tab
Additional Styling with the Format Tab
Manipulating a Chart
Step-By-Step
Skill Sharpener
Lesson 4.5: Working with Charts, Part 2
Changing the Type of Chart
Changing the Source Data
Working with the Chart Axes and Data Series
Saving a Chart as a Template
Absolute and Relative Cell References
Step-By-Step
Skill Sharpener
Section 4: Case Study
Section 4: Review Questions
Section 5: Printing and Viewing your Workbook
Lesson 5.1: Using the View Tab
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Step-By-Step
Skill Sharpener
Lesson 5.2: Managing a Single Window.
Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Splitting a Worksheet
Step-By-Step
Skill Sharpener
Lesson 5.3: Managing Multiple Windows
Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling and Resetting a Window
Saving a Workspace
Step-By-Step
Skill Sharpener
Lesson 5.4: Printing your Workbook
Print Commands
Print Preview
Using Basic Print Options
Other Print Options
Setting Printer Properties
Step-By-Step
Skill Sharpener
Section 5: Case Study
Section 5: Review Questions
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.
