Microsoft Excel 2003 - Tutorial Videos - Training CD

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 2003

Affordable Training you can depend on
This Microsoft Excel 2003 tutorial video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 6 hours long these Microsoft Excel 2003 tutorials on CD are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Tutorial Video CD to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of these Microsoft Excel 2003 training videos we have made the first 3 chapters of this tutorial available for free viewing online. The purchased version of this video training course contains all the topics listed below. Please Note: the free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far higher.

THIS TUTORIAL VIDEO COVERS THE FOLLOWING:

Details

This Microsoft Excel Tutorial Video course is presented by Kate Chase and provides the user with an interesting look into just how to use Microsoft Excel in the workplace. No time is wasted on theory as Kate jumps right in from the start with an array of real life examples. Beginners will benefit greatly from the narrated instructional videos that make learning even the more complex concepts simple. By the conclusion of this video-based training, users will have progressed far beyond the basics and be able to accomplished complex tasks using Excel. Topics covered in this tutorial video series include Labels, Functions, Queries, Smart Tags, XML, Embedding and Links, Security, Lists and much more. Full course contents and free demos can be seen below. Customers who viewed this also viewed Beginners Microsoft Excel Tutorial Video. All titles can be purchased online or on CD / DVD format.

The Blue Links below are free demos, when you purchase the video tutorial CD the enitre content listings below are included , not just the free demo videos.

Select the format in which to view the free demos:

Introduction To Excel 2003

Installing Microsoft Excel 2003

Getting Assistance With Excel 2003

The purchased version of this product contains all the movies listed below as well as all the featured samples above.

US$ 99.95

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 Tutorials 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 Tutorials 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 Microsoft 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

Microsoft Excel 2003 Tutorial VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Excel 2003
Instructor	:	Kate J. Chase
Price	:	US$ 99.95
Duration	:	6 hours - 117 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33508

BENEFITS OF THIS TUTORIAL TRAINING VIDEO

Learn Microsoft Excel 2003 in the shortest time possible
Self paced tutorial, training on video, learn at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.

Prove your Skills. Free Certification with every course.

With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.