Fully Customizable Courseware For Trainers
Microsoft Office Excel 2007: Foundation
DOWNLOAD A FREE SAMPLE
Our Microsoft Office Excel 2007: Foundation courseware and training material is customizable in any way you need. Add it, delete it, change it, and rename it; whatever makes the courseware work for you. By customizing our courseware to fit your unique needs you can walk into the classroom confident, knowing the material you have is proven.
Microsoft Office Excel 2007 is one of the most popular data manipulation tools on the market. Having the skills to use this software, and use it effectively, will increase an employee’s efficiency greatly (and reduce their frustration). Adopting this technology to its fullest and train your users on the basic Excel 2007 skills.
Let us remove the lesson plan guesswork and headache. We have done all the work for you by covering everything you need to complete a training session:
- Activities workbook
- Quick reference guide
- Instructor guides
- Student manual
- Lesson plans
- PowerPoint slides
Our Microsoft Office Excel 2007: Foundation curriculum covers everything you’ll need to let your students be confident in their abilities to handle the fundamentals of Excel 2007. These include topics such as workbook use and explanation, the many different tabs and their functions, and basic Excel features.
Section 1: Getting Started
Lesson 1.1: Starting Out
What is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
Step-By-Step
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
The Zoom Feature
Step-By-Step
Skill Sharpener
Lesson 1.4: Getting Help in Excel 2007
Using the Help Screen
About Online Help
About Offline Help
Step-By-Step
Skill Sharpener
Section 1: Case Study
Section 1: Review Questions
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
Lesson 2.2: The Home Tab
Clipboard
Font
Alignment
Number
Style
Cells
Editing
Step-By-Step
Skill Sharpener
Lesson 2.3: The Insert Tab
Tables
Charts
Illustrations
Shapes
Links
Text
Step-By-Step
Skill Sharpener
Lesson 2.4: The Page Layout Tab
Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener
Lesson 2.5: The Formulas Tab
The Function Library
Defined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener
Lesson 2.6: The Data Tab
Get External Data
Connections
Sort and Filter
Data Tools
Outline
Step-By-Step
Skill Sharpener
Lesson 2.7: The Review Tab
Proofing
Comments
Changes
Step-By-Step
Skill Sharpener
Section 2: Case Study
Section 2: Review Questions
Section 3: Excel Basics
Lesson 3.1: Working With Excel 2007
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
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
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 and Items
How to Use Paste Special
How to Insert and Delete Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Step-By-Step
Skill Sharpener
Lesson 3.4: Smart Tags and Options Buttons
What Are Smart Tags?
Setting Smart Tag 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 Styles
Step-By-Step
Skill Sharpener
Lesson 4.4: Working With Charts, Part 1
Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Tab
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics
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 Axis and Data Series
Saving a Chart as a Template
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
Step-By-Step
Skill Sharpener
Lesson 5.3: Managing Multiple Windows
Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Step-By-Step
Skill Sharpener
Lesson 5.4: Printing your Workbook
Opening Print Preview
Using the Print Preview Tab
Quick Printing
The Print Dialog
Using Page Setup
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.
