Search for a title:

Microsoft Excel 2003 Tutorial - Training Videos

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 2003

Microsoft Excel 2003 Tutorial CD

Affordable Training you can depend on
This Microsoft Excel 2003 video tutorial 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 are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs 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 the Microsoft Excel 2003 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. 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 greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

 Description

This Microsoft Excel tutorial video is presented by Kate Chase and takes the user on 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, the beginners will benefit greatly from the narrated videos that make learning even the more complex areas simplistic. By the conclusion of this video based Microsoft training course users will have progressed far beyond the basics and be able to accomplished complex tasks using Excel. Topics covered 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

 Hide Description

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

Introduction To Excel 2003



Installing Microsoft Excel 2003



Getting Assistance With Excel 2003



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


  24 in Stock

BENEFITS OF THIS TRAINING COURSE

  • Master Microsoft Excel 2003 in the shortest time possible
  • Self paced tutorial, training on video, 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.

RELATED TUTORIALS


NEW TRAINING TITLES


CLIENT TESTIMONIALS

'I have been using your 'Photoshop CD to demonstrate Photoshop technique to my students. I have been encouraging them to purchase it on their own, as I believe it to be an excellent training instrument, and the best instructional CD on this subject to date. Not only is it well-thought out and presented clearly, but it is also a bargain.
Joe Doyle
Vista Community College, Berkeley, CA ;

Site Map | Free Demos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434-878-4158
Fax: 1 207 433 4356
Email: