Microsoft Excel tutorials and training courses on cd or online , master this graphics application in days, fast learning and cost effective. For for details of our Microsoft Excel Tutorials and training courses click the logo below.
Microsoft Excel Training Courses
Please select your country
USA / Canada UK & Europe Australia & Asia All other areas
    Microsoft Excel tutorials and training courses
adobe after effects tutorials and training courses

Microsoft Excel Tutorials
Microsoft Excel Tutorials
Author Name   Julia Kelly
Total Movies   163
Duration   8 Hours
 

Try before you buy

Click on any movie link in the first 3 chapters, to watch a free demo

To allow faster streaming over the web the sound and video quality has been reduced, this ensures faster download

The quality of the movies on the CDs is much better.

Please ensure that you have downloaded and installed the Apple QuickTime Plugin if needed, this is required to play the tutorial movies. If you are experiencing any problems please contact tech support . All our CD Tutorials and Online Moives are produced by expert authors and trainers, we try to design the content to represents problems that you would encounter in a real work environment. As a customer we value your comments and depend on your feed back to improve our products


This Microsoft Excel 2002 Training Course offers a introduction to Excel spreadsheets. This Tutorial will instruct users on how to use this spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To find out more about our Training Course please select a link below.

The links below are free Microsoft Excel tutorials. To watch the entire contents of this training course please purchase the CD or subscribe to the Online University

Introduction
About Excel
Open/ Save/Close Workbooks
What’s Inside the Workbook
Menus and Toolbars
What’s on a Worksheet
Getting Assistance from Excel

Getting Started
Select and Navigate Cells
Enter Data
Edit and Delete Data
Undo and Redo
Cut/Copy/Paste
About the Office Clipboard
Drag and Drop
AutoFill
More Ways to Enter Repetitive Data
AutoCorrect
Use a Data Entry Form
Validate Data During Entry

Working With Worksheets
Resize Rows and Columns
Insert and Delete Rows/Columns/Cells
Rename Worksheets
Move and Copy Worksheets
Insert and Delete Worksheets
Freeze and Split a Worksheet
Open Multiple Windows

Simple Calculations
Calculate Without a Formula
Use AutoSum to Write Formulas
Formula Structure
Create Formulas
Edit Formulas
AutoFill Formulas
Relative and Absolute References
Functions
Use the Function Wizard
Name Cells and Ranges
Use Names in Formulas

Using Advanced Functions
AVERAGE/MAX/MIN
SUMIF and COUNTIF
VLOOKUP
PMT
NOW/ TODAY/CONCATENATE
IF and Nested Functions

Organizing Data
Sort Data
Filter Data with AutoFilter
AND and OR Filters
Calculate Filtered Records
PivotTables
Consolidate Data
Subtotal a Worksheet

Formatting Cells
Text Formatting
Align and Wrap Text
Number Formats
Date and Time Formats
Custom Formats
Borders and Shading
Conditional Formatting
Format Painter
Styles
AutoFormat a Table
Transpose Tables and Merge Cells
Format Several Worksheets Identically
Save a File as a Template

Charting Data
About Charts
Create a Chart
Resize and Relocate a Chart
The Chart Toolbar
Chart Options
Legends/Titles/Axes
Series Orientation and Order
Create 3-D Charts
Explode a Pie Chart
Add Data Labels and a Data Table
Trendlines
Secondary Axes
Format Chart Elements

Printing Data and Charts
See a Print Preview
Create Page Headers and Footers
Set the Print Area
Print a Selection
Centering/ Margins/Gridlines
Print on a Specific Number of Pages
Print Multiple Worksheets/Copy/Collate Pages
Print Row and Column Labels on Every Page
Print Charts

Sharing and Protecting Data
Share Data Between Workbooks
Copying/Linking/Embedding Data
Share Data with Other Programs
Share a Workbook with Other Users
Hide Worksheets
Protect Cells
Protect Worksheets and Workbooks

Analyzing Data
Use Goal Seek to Find Answers
Use Scenarios to Compare Alternatives
Locate Worksheet Errors and Invalid Data

Customizing Excel
Customize Your Toolbars
Create a Custom Toolbar
Automate with Macros
Record a Macro
Edit a Macro
Assign a Macro to a Toolbar Button
Create a Hyperlink to Open Another File

Graphics and The Drawing Toolbar
Insert a Picture
Move/Resize/Crop
Draw Shapes and Lines
Draw AutoShapes and Assign Macros
Arrange and Group Drawing Objects
Use Drawn Objects in Charts
Create Text Boxes
Create Worksheet Comments

Microsoft Excel Training Courses | Microsoft Excel Tutorials | All Courses


List all tutorials Graphic and page layout Internet and Web Design Animation and 3D Multimedia and Video Operating Systems Business Applications Programming
All our titles play on PC or Mac, the application does not need to be installed on the system for our program to be used. Our products are being used in distance learning applications by large companies, Banks, Schools, Colleges and Universites. To get the best out of our product you may wish to down load the movie / video player, Apple QuickTime is also required.