Fully Customizable Courseware For Trainers
Excel 2002: Foundation
DOWNLOAD A FREE SAMPLE
With our Excel 2002 – Foundation courseware training material you can have the confidence to walk into the classroom knowing the material you have is sound. Our courseware is market tested in 150 countries around the world, and is completely customizable. You are able to add, delete, or change any part of it you like. You can print as much as you want, use it for as many people as needed, and there are no annual renewal fees.
In today’s workplace using spreadsheets has become commonplace. After all this time, Microsoft office Excel 2002 is still towards the front of the pack for spreadsheets programs. Providing training that will offer the needed skills to your workers will help them understand Excel 2002.’this will empower them to adopt new technology, increasing their efficiency in the workplace.
Our Excel 2002 – Foundation courseware training material is fully featured and includes everything you’ll need to offer a training session, including:
- Exercise files
- Instructor guide
- PowerPoint slides
- Quick reference guide
- Student manual
Our curriculum for Excel 2002 will cover everything a beginner needs to know. Some examples of topics covered are: modifying cells and data, moving your data, and working with charts.
SECTION 1: Getting Started with Excel
Lesson 1.1: Introduction
What is Excel?
Opening Excel
Exiting Excel
Practice Exercise
Lesson 1.2: Help with Excel
Finding Help
The Office Assistant
How to Use Help
Practice Exercise
Lesson 1.3: Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working with Excel Menus
Excel Shortcut Keys
Practice Exercise
Lesson 1.4: The Basics of File Management
New Workbooks
How to Open Existing Workbooks
How to Save Workbooks
How to Close Workbooks
Excel File Types
Practice Exercise
Lesson 1.5: Explore your Workbook
Switching Worksheets
The Active Cell
Selecting Cells
Exploring a worksheet
The Zoom Feature
Practice Exercise
Section 1: Review Questions
SECTION 2: Excel Basics
Lesson 2.1 Working with Excel
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing your Worksheet
Practice Exercise
Lesson 2.2 Basic Excel Features
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Practice Exercise
Lesson 2.3 Editing Tools
Using AutoCorrect
Using Spell Check
Using Find and Replace
Documenting a Worksheet with Comments
Practice Exercise
Lesson 2.4 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
Practice Exercise
Lesson 2.5: Using Smart Tags and Option Buttons
What are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Practice Exercise
Section 2: Review Questions
SECTION 3: Working with Excel
Lesson 3.1: Modifying Cells and Data
Changing the Size of Rows or Columns
Working with the Formatting Toolbar
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Practice Exercise
Lesson 3.2: Cell Formatting
Conditional Formatting
What is the Format Painter?
What is AutoFormat
Cell Merging and AutoFit
Find and Replace Formatting
Practice Exercise
Lesson 3.3 Enhancing a Worksheet's Appearance
Adding Patterns and Colours
Adding Borders
Adding Fill Effects
Working with Styles
Practice Exercise
Lesson 3.4 Modifying Excel's Toolbars
Hiding toolbars
Showing Toolbars
Moving Toolbars
Customizing Toolbars
Practice Exercise
Lesson 3.5: Working with Charts
Creating a Chart
Formatting a Chart
Manipulating a Chart
Enhancing a Chart with Drawing Tools
Enhancing your Chart with Titles and Tables
Practice Exercise
Lesson 3.6: Working with Charts and Data
Changing the Type of Chart
Changing the Source Data
Creating 3-D Charts
Working with the chart Axes and Data Series
Making Custom Charts
Practice Exercise
Section 3: Review Questions
SECTION 4: Workbook Management
Lesson 4.1 Organizing your Workbook
Inserting and Removing Worksheets
Renaming, Moving, and Colour-Coding Worksheets
How to Split and Freeze a Window
Using Multiple Workbooks and Windows
Using a Watch Window
Creating a Custom View
Practice Exercise
Lesson 4.2 Formatting your Workbook
Using Headers and Footers
Inserting Page Numbers
Changing Margins and Orientation
Hiding Rows, Columns and Worksheets
Practice Exercise
Lesson 4.3 Printing a workbook
Choosing a Print Area
Setting up Page Breaks
Choosing Paper Size and Changing Print Scale
Adding Print Titles and Gridlines
Practice Exercise
Lesson 4.4 More Workbook Features
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Protecting Worksheets
Using Templates
Practice Exercise
Section 4: Review Questions
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.
