Fully Customizable Courseware For Trainers
Microsoft Office Excel 2003: Basic
DOWNLOAD A FREE SAMPLE
Microsoft Office Excel 2003: Basic training can help you teach the benefits of understanding the proper uses of Excel. This spreadsheet application will help you analyze and use data for decision making purposes.
If you need courseware and training materials to help teach your workshop, you have come to the right place! Our Microsoft Office Excel 2003 courseware will allow you to be efficient at lesson planning. The training material is fully customizable. You have the power to change lessons, exercises, examples and logos to make it truly your own.
We will provide you with training material to properly engage students in understanding the functions of Microsoft Office Excel 2003. Self-study guides, quick reference, student manuals, workbooks and instructor guides are only some of the provided resources we have available to you.
Our Microsoft Office Excel 2003: Basic?courseware will allow you to understand and teach basic skills as: creating documents, file management, excel features, editing tools, moving data, using smart tags and option buttons, cell formatting, enhancing a worksheet’s appearance, working with charts, organizing workbooks and more.
SECTION 1: Getting Started with Excel
Lesson 1.1: Introduction
What is Excel?
New Features in Excel 2003
Opening Excel
Exiting Excel
Practice Exercise
Lesson 1.2: Help with Excel
Finding Help
The Office Assistant
The Help Task Pane
Practice Exercise
Lesson 1.3: Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working with Excel Menus
Exploring Task Panes
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.
