Excel Training - MS Excel 2003

This training course contains a series of video based tutorials which are designed to teach users the essential spreadsheet skills. It begins with the basics of the Microsoft Excel spreadsheet and quickly advances to cover the more advanced features, including functions, formulas, charts, importing and exporting data, pivot tables, Excel help and tips, and much more. You'll learn how to use Microsoft Excel in hours, not days.

 Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.  

Register Now and Activate This Excel Training Course Instantly

Excel Training Course Online - MS Excel 2003

Free sample tutorial: Introduction to Excel Formulas

Course Introduction

Chapter 1 - Getting Started With MS Excel
Excel interface
The menus
Customizing toolbars I
Customizing toolbars II
Navigating techniques
Getting help & assistance

Chapter 2 - Excel Workbook
Creating a new workbook
Entering & editing data
Commenting

Chapter 3 - Managing Excel Workbooks
Saving & converting file to a web page
Opening a workbook
Securing an file
Adding and deleting worksheets
Adding rows & columns
Sharing files

Chapter 4 - Managing Excel Data
Working with data
Find & replace data
Naming cells & cell ranges
Creating lists
AutoFilter
Using data form
Data validation

Chapter 5 - Formatting Excel Worksheets
Formatting cells I
Formatting cells II
Adjusting width & height
Copying cell formatting
Using AutoFormat
Freeze/unfreeze rows & columns

Chapter 6 - Advanced Excel Worksheet Formatting
Using styles
Conditional formatting
Protecting cells
Inserting graphics

Chapter 7 - Excel formulas
Operators
Creating formulas
Relative & absolute references
External references
Creating named constants
Concatenation

Chapter 8 - Excel Functions
Functions & the function wizard
Common functions
Text functions
Date & time functions
Lookup functions

Chapter 9 - Excel charts
Creating charts
Editing charts
Formatting charts
Adding graphics to charts

Chapter 10 - Importing & Exporting Excel Data
Importing data
Querying external database I
Querying external database II
Exporting data

Chapter 11 - Printing Excel Worksheets
Setting up
Headers & footers
Print what you want

Chapter 12 - Excel Tips
Compare workbooks
Handy tricks
Useful shortcuts