Microsoft Excel 2003 Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2003 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Introduction To Excel 2003
- First Glance at Excel 2003 Demo
- Why Choose Excel 2003? Demo
- About Spreadsheets Demo
- Touring Excel – Pt.1 Demo
- Touring Excel – Pt.2 Demo
- Features New to Excel 2003 Demo
Installing Excel 2003
- Recommendations Before You Install Demo
- Minimum System Requirements Demo
- Using Excel Setup Demo
- Troubleshooting Excel 2003 Installation Demo
- Performance Issues with Excel 2003 Demo
Getting Assistance With Excel 2003
- Ways to Increase Your Aptitude Demo
- Exploring the Assistance Menu Demo
- Type a Question for Assistance Demo
- Using Microsoft Office Online Demo
Excel 2003 Basic Concepts
- Worksheets and Workbooks
- Organization
- Differences Between Text & Data Values
- Labels and Names
- More About Labels
- More about Cells and Cell Ranges
- About Mathematical Operators & Operands
- About Formulas & Calculations
- The Role of Functions
- Types of Charts
- Forms/Including Data Forms
- The Job of Queries
- What are Workbook Audits
- Importing and Exporting
- Linking and Embedding
- Absolute vs Relative Cell References
- What About Smart Tags?
- What is XML?
- Locking/Freezing Cells/Splitting Work Area
- About Excel Security
First Hands On In Excel
- Launching Excel 2003
- Planning Your Worksheet or Workbook
- Labeling & Naming Worksheet/Workbook
- A Look at Our Example Layout
- Naming and Saving Your Workbook
- Renaming and Deleting a Workbook
- Printing Your Workbook
- Double Check Workbook & Exit
- Opening an Existing Workbook
Customizing Excel 2003
- About Excel Customization
- Customizing Excel Menu Bar
- Customizing Excel Toolbars
- Changing Page Setup
- Modifying Default Location of Saved Work
- Setting Up Options – Pt.1
- Setting Up Options – Pt.2
Entering Your Information
- About Entering Your Information
- Entering Labels and Values
- More About Multiple Entries
- Understanding Multiple Selections
- Inserting/Deleting Rows & Columns
- Copying & Pasting Columns/Rows & Cells
- Moving Columns/Rows & Cells
- Adding a Smart Tag
- Editing Your Work
Formatting Your Work
- Introduction to Formatting
- Formatting Text & Data Pt.1
- Formatting Text & Data Pt.2
- Using AutoFormat
- Changing AutoFormat Options
- Adding Colors and Patterns
- Adding Borders
- What is Conditional Formatting?
- Applying Conditional Formatting
- Copying Cell Formatting
- About Styles
- Creating a Style
- Applying and Modifying a Style
Adding Elements To A Workbook
- Introduction to Adding Elements
- Adding Images to a Workbook
- Modifying Images Inserted in Workbook
- Adding Clips
- Diagramming in Excel
- Adding an Organizational Chart
- Changing an Organizational Chart
- Adding WordArt
- Adding a Hyperlink
- Inserting Objects Such as AutoShapes
Calculation With Formulas and Functions
- About Formulas and Calculation
- Creating a Formula – Pt.1
- Creating a Formula – Pt.2
- Spotting Problems & Editing a Formula
- More About Functions
Managing Data With Excel
- Use it or Lose it
- Using Forms/Particularly Data Forms
- Entering Data Using a Data Form
- Managing Data from a Data Form
- About Using Excel as a Database
- What are Lists?
- Creating a List
- Entering Data into a List
- Sorting Data in a List
- Using Filters to Sort Lists
- Auditing Excel Data
- Other Validation and Error Checking
- More About Validation for Data Entry
- Performing Queries
- Exporting Data from Excel
- Linking Data Pt.1
- Linking Data Pt.2
Working With Charts
- About Charts
- Creating Your Chart
- Modifying & Relocating Your Chart
- Other Changes to Your Chart
Sharing & Collaborating With Excel 2003
- Sharing Your Worksheet or Workbook
- Sending Your Workbook for Review
- Using Online Collaboration
- Protecting Your Workbook
- Change Different Versions of a Workbook
- Adding/Editing/Deleting Comments
- Creating & Sharing a Workbook Template
Credits
- About this Author
If you would like to own this Excel 2003 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.