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.
SECTION 1: Getting Started with Excel
Lesson 1.1: Introduction
What is Excel?
New Features in Excel 2003
Lesson 1.2: Help with Excel
The Office Assistant
The Help Task Pane
Lesson 1.3: Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working with Excel Menus
Exploring Task Panes
Excel Shortcut Keys
Lesson 1.4: The Basics of File Management
How to Open Existing Workbooks
How to Save Workbooks
How to Close Workbooks
Excel File Types
Lesson 1.5: Explore your Workbook
The Active Cell
Exploring a Worksheet
The Zoom Feature
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
Lesson 2.2: Basic Excel Features
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Lesson 2.3: Editing Tools
Using Spell Check
Using Find and Replace
Documenting a Worksheet with Comments
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
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
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
Creating Custom Number and Date Formats
Lesson 3.2: Cell Formatting
What is the Format Painter?
What is AutoFormat?
Cell Merging and AutoFit
Find and Replace Formatting
Lesson 3.3: Enhancing a Worksheet's Appearance
Adding Patterns and Colours
Adding Fill Effects
Working with Styles
Lesson 3.4: Modifying Excel's Toolbars
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
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
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
Lesson 4.2: Formatting your Workbook
Using Headers and Footers
Inserting Page Numbers
Changing Margins and Orientation
Hiding Rows, Columns and Worksheets
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
Lesson 4.4: More Workbook Features
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.