Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.
Facilitate perfect workshops everytime with high-quality training material with all the training components you need.
Focus your attention on the training and we'll take care of the materials.
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:
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
Lesson 1.2: About Workbooks
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Lesson 1.3: Exploring your Workbook
The Active Cell
Exploring a Worksheet
The Zoom Feature
Lesson 1.4: Getting Help in Excel 2007
Using the Help Screen
About Online Help
About Offline Help
Section 1: Case Study
Section 1: Review Questions
Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
The Default Buttons
Customizing the Toolbar
Lesson 2.2: The Home Tab
Lesson 2.3: The Insert Tab
Lesson 2.4: The Page Layout Tab
Scale to Fit
Lesson 2.5: The Formulas Tab
The Function Library
Lesson 2.6: The Data Tab
Get External Data
Sort and Filter
Lesson 2.7: The Review Tab
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
Lesson 3.2: Basic Excel Features
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
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
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
Lesson 3.5: Editing Tools
Using Spell Check
Using Find and Replace
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
Creating Custom Number and Date Formats
Lesson 4.2: Cell Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Lesson 4.3: Enhancing a Worksheet's Appearance
Adding Patterns and Colors
Working with Styles
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
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
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
Lesson 5.2: Managing a Single Window.
Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Lesson 5.3: Managing Multiple Windows
Switching Between Open Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Lesson 5.4: Printing your Workbook
Opening Print Preview
Using the Print Preview Tab
The Print Dialog
Using Page Setup
Section 5: Case Study
Section 5: Review Questions
What you get
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.
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.
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.
Courseware from Velsoft is designed to give you everything you need for use in the classroom or workshop. This includes PowerPoint slides for classroom use, prepared for you in advance.
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes in two pages the most important elements in each courseware title.
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.
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.
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.
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.
Available as an eLearning Course
eLearning you can customize.
Courseware you can customize.
Courseware you can customize.