Microsoft Excel 2003 Tutorials


Course Content


Excel 2003 enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. Author Kate J. Chase's extensive knowledge of Excel 2003 will have you using it like a pro by the end of the tutorial. From simple spreadsheets to complex databases, it is all covered in VTC's Microsoft Excel 2003 tutorial. To begin learning today, simply click on the links below.

To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie. «« Hide This
Introduction To Excel 2003
	First Glance at Excel 2003	(02:50)
	Why Choose Excel 2003?	(04:27)
	About Spreadsheets	(02:27)
	Touring Excel – Pt.1	(03:10)
	Touring Excel – Pt.2	(03:49)
	Features New to Excel 2003	(03:24)
Installing Excel 2003
	Recommendations Before You Install	(03:27)
	Minimum System Requirements	(03:03)
	Using Excel Setup	(03:37)
	Troubleshooting Excel 2003 Installation	(04:18)
	Performance Issues with Excel 2003	(03:42)
Getting Assistance With Excel 2003
	Ways to Increase Your Aptitude	(02:29)
	Exploring the Assistance Menu	(03:13)
	Type a Question for Assistance	(02:51)
	Using Microsoft Office Online	(03:17)
Excel 2003 Basic Concepts
	Worksheets and Workbooks	(02:52)
	Organization	(02:03)
	Differences Between Text & Data Values	(03:05)
	Labels and Names	(03:21)
	More About Labels	(02:28)
	More about Cells and Cell Ranges	(02:34)
	About Mathematical Operators & Operands	(03:03)
	About Formulas & Calculations	(02:13)
	The Role of Functions	(03:21)
	Types of Charts	(02:05)
	Forms/Including Data Forms	(02:48)
	The Job of Queries	(02:25)
	What are Workbook Audits	(02:47)
	Importing and Exporting	(01:57)
	Linking and Embedding	(01:35)
	Absolute vs Relative Cell References	(03:11)
	What About Smart Tags?	(02:14)
	What is XML?	(02:29)
	Locking/Freezing Cells/Splitting Work Area	(03:31)
	About Excel Security	(02:53)
First Hands On In Excel
	Launching Excel 2003	(03:19)
	Planning Your Worksheet or Workbook	(01:54)
	Labeling & Naming Worksheet/Workbook	(03:38)
	A Look at Our Example Layout	(02:51)
	Naming and Saving Your Workbook	(02:59)
	Renaming and Deleting a Workbook	(02:58)
	Printing Your Workbook	(02:00)
	Double Check Workbook & Exit	(02:58)
	Opening an Existing Workbook	(02:14)
Customizing Excel 2003
	About Excel Customization	(01:39)
	Customizing Excel Menu Bar	(02:01)
	Customizing Excel Toolbars	(04:31)
	Changing Page Setup	(02:32)
	Modifying Default Location of Saved Work	(03:23)
	Setting Up Options – Pt.1	(02:20)
	Setting Up Options – Pt.2	(03:14)
Entering Your Information
	About Entering Your Information	(03:35)
	Entering Labels and Values	(04:02)
	More About Multiple Entries	(02:55)
	Understanding Multiple Selections	(02:27)
	Inserting/Deleting Rows & Columns	(03:07)
	Copying & Pasting Columns/Rows & Cells	(04:06)
	Moving Columns/Rows & Cells	(03:05)
	Adding a Smart Tag	(03:59)
	Editing Your Work	(03:53)
Formatting Your Work
	Introduction to Formatting	(02:45)
	Formatting Text & Data Pt.1	(03:58)
	Formatting Text & Data Pt.2	(04:46)
	Using AutoFormat	(02:09)
	Changing AutoFormat Options	(02:09)
	Adding Colors and Patterns	(03:04)
	Adding Borders	(03:17)
	What is Conditional Formatting?	(02:30)
	Applying Conditional Formatting	(03:11)
	Copying Cell Formatting	(02:34)
	About Styles	(02:00)
	Creating a Style	(03:15)
	Applying and Modifying a Style	(02:52)
Adding Elements To A Workbook
	Introduction to Adding Elements	(02:30)
	Adding Images to a Workbook	(03:42)
	Modifying Images Inserted in Workbook	(04:14)
	Adding Clips	(02:37)
	Diagramming in Excel	(04:15)
	Adding an Organizational Chart	(02:15)
	Changing an Organizational Chart	(02:08)
	Adding WordArt	(03:10)
	Adding a Hyperlink	(04:03)
	Inserting Objects Such as AutoShapes	(05:04)
Calculation With Formulas and Functions
	About Formulas and Calculation	(02:12)
	Creating a Formula – Pt.1	(03:50)
	Creating a Formula – Pt.2	(03:19)
	Spotting Problems & Editing a Formula	(04:04)
	More About Functions	(05:10)
Managing Data With Excel
	Use it or Lose it	(04:29)
	Using Forms/Particularly Data Forms	(03:06)
	Entering Data Using a Data Form	(03:38)
	Managing Data from a Data Form	(02:21)
	About Using Excel as a Database	(02:10)
	What are Lists?	(03:47)
	Creating a List	(05:22)
	Entering Data into a List	(02:58)
	Sorting Data in a List	(03:22)
	Using Filters to Sort Lists	(04:43)
	Auditing Excel Data	(03:50)
	Other Validation and Error Checking	(04:26)
	More About Validation for Data Entry	(02:55)
	Performing Queries	(04:01)
	Exporting Data from Excel	(01:56)
	Linking Data Pt.1	(05:37)
	Linking Data Pt.2	(03:47)
Working With Charts
	About Charts	(02:24)
	Creating Your Chart	(03:40)
	Modifying & Relocating Your Chart	(03:17)
	Other Changes to Your Chart	(02:56)
Sharing & Collaborating With Excel 2003
	Sharing Your Worksheet or Workbook	(02:11)
	Sending Your Workbook for Review	(02:39)
	Using Online Collaboration	(02:32)
	Protecting Your Workbook	(03:10)
	Change Different Versions of a Workbook	(03:57)
	Adding/Editing/Deleting Comments	(03:38)
	Creating & Sharing a Workbook Template	(04:10)
Credits
	About this Author	(01:51)

Email this Page

Send us Feedback

Tutorial Information / Pricing

Title:	Microsoft Excel 2003
Author:	Kate J. Chase
SKU:	33508
ISBN:	1932072977
Duration:	6 hrs / 117 Lessons
Compatibility:	Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30

The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP	LEARN MORE »


Get this title on CD


Single User: US$ 99.95 - Purchase CD / Add to Cart Multi User (10): US$ 500.00 - Purchase CD / Add to Cart


Select Bandwidth


Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming. Select:


Select Category


Animation & 3D Audio Business Applications Databases Graphics & Page Layout Multimedia & Video Networking & Security Operating Systems Programming Internet & Web Design Special Groups New Releases All Titles Publisher or Products Adobe Tutorials Apple Tutorials Cakewalk Tutorials Corel Tutorials Dreamweaver Tutorials Macromedia Tutorials Microsoft Tutorials Oracle Tutorials Photoshop Tutorials Sony Tutorials

Microsoft Excel 2003 Tutorials

Introduction To Excel 2003

Installing Excel 2003

Getting Assistance With Excel 2003

Excel 2003 Basic Concepts

First Hands On In Excel

Customizing Excel 2003

Entering Your Information

Formatting Your Work

Adding Elements To A Workbook

Calculation With Formulas and Functions

Managing Data With Excel

Working With Charts

Sharing & Collaborating With Excel 2003

Credits