Microsoft Office Excel 2003: Basic

  • Courseware
  • eLearning
  • Print


Entire course and all it's components written for you


One-off cost
  • Easily customizable
  • Unlimited reprinting
  • Unlimited Users
Free Trial Buy Now


SCORM-Compliant course for your LMS


Per Year
  • Easily customizable
  • Runs on your LMS
  • Unlimited Users
Free Trial Buy Now
  • Product Description
  • Course Outline
  • Bundle & Save
  • What is Courseware?

Microsoft Office Excel 2003: Basic

We can all benefit from 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 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.

 For those beyond the beginner level, we offer courses for the intermediate and advanced learner. 

Course Outline

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

What is Courseware?

Courseware has become the trainer’s preference amongst “Instructor-Led” course materials, and for good reason. Courseware (course material delivered to our customers in an easy to use word processing format) is designed and written to eliminate the preparation time and efforts needed to develop custom training materials. Instructors are choosing to purchase Velsoft Courseware for the many benefits a pre-written course can provide.

Courseware comes in an electronic format which offers several key advantages to trainers, including:

Instant access to the training materials through our unique Courseware Assurance Program, Flexibility in customizing the course content to reflect the varying needs of their students, On-demand printing of the materials, and Updates to the purchased courses can be received to ensure your students are getting the most relevant and up-to-date information (this requires participation in our fee based courseware assurance program). Velsoft Courseware has been designed with the needs of an instructor in mind. Our training materials can be viewed and edited in Microsoft Word (or any word processing program) and instructors have the rights to edit the content to suit their training plan. The range in the availability of our Courseware titles means providing your students with access to lifelong learning.

Confidence in our Courseware training materials means confidence in your instructors’ ability to effectively and successfully teach in the classroom. The unique resources included in every Velsoft course offers instructors complete guidance throughout the training process.

Velsoft Courseware can provide your organization with effective training solutions that won’t break your budget. At Velsoft we take pride in the quality of our products, and we take pride in our pricing. Choose Velsoft Courseware to help your organization grow.

Try Microsoft Office Excel 2003: Basic Courseware for Free

See how you can save time & money with pre-written, customizable courses.

For every hour of training delivery it takes 40 hours of prep work to have quality training materials. A two-day training class of 7.5 hours per day can easily take 600 hours of work. Velsoft courseware means this work is done for you and delivered in MS Word format files so that you can make any changes you like; right down to taking our logo off and replacing it with yours. Velsoft courseware gives you the confidence of walking into your training session knowing you are prepared to give a great class.

With Velsoft courseware you receive:

  • Fully customizable files
  • Unlimited reprinting rights
  • Unlimited number of users
  • No annual renewal fees

There's no risk, no obligation, and no credit card required

If you are interested in any of our eLearning titles, we can provide you with access to a free demo. Our web-based SoftSkills courses are effective and affordable; allowing business professionals to learn interesting and practical information related to their jobs. Trying out this interactive and customizable eLearning course will demonstrate to you the quality of our product, and the advantages it will bring to your organizational training goals.

Try for Free
Now available in SCORM format:

Microsoft Office Excel 2003: Basic

Easily load this course into your LMS. Download Test File

Related Courses