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   Damienne
FitzPatrick
Total Movies   132
Duration   9 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 Training Course, will show you how to create spreadsheets. Microsoft Excel allows you to analyze data with charts and graphs. You can even use VBA to create data-rich spreadsheets. This tutorial takes you from basics thorough advanced techniques . This Tutorial explains columns and rows, CSV files, Importing and exporting to Word and Access, using Mail Merge, creating workbooks and worksheets, basic and advanced formulas, how to insert graphics.

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 to Excel
  Play Me First
 Getting Started
 Interface
 Save
 Simple Printing
 Close & Exit
 Get Help
 Office Assistant

The Basics
  Selection Techniques
 Enter Data
 Edit & Delete Data
 Cut, Copy & Paste
 Drag & Drop
 Undo & Redo
 The Fill Handle
 AutoCorrect
 Spelling
 Find & Replace

Worksheet Controls
 Navigate A Document
 Zoom Control
 Insert Cells
 Delete Cells
 Resize Rows & Columns
 Hide & Unhide
 Insert & Delete Worksheets
 Move & Copy Worksheets
 Views
 Splits & Panes

Text & Number Formats
 Text Formats
Align & Text Wrap
Special Alignment Effects
Borders & Shading
Number Formats
Date & Time Formats
Custom Formats
Format Painter
AutoFormat
Conditional Formats
Styles

Simple Calculations & Functions
 Basic Formulae
Operators
Relative References
Absolute References
Sum Function
The Function Wizard
If, And, Or
Nested Ifs
Lookup
V & H Lookup
Trends

Analyses & Databases
 Goal Seek
One-Input Tables
Two-Input Tables
Scenarios
Scenario Summaries
Pivot Tables
Create A Database
Sort Data
Filter Data
Advanced Filtering
Set Criteria
Database Functions

Optimizing Techniques
 Custom Lists
Paste Special
Name Cells & Ranges
Linking
Consolidation
Automatic Subtotals
Validation
Outlining
Protect Cells
Print Preview
Headers & Footers
Print Areas
Customizing Toolbars
Create A VBA Macro
Edit A Macro

Charts
 Chart Data
Create a Chart
Chart Palette
Text & Data Labels
Axes & Gridlines
Chart & Plot Area
The Legend
Edit The Series
Custom Charts

Graphics
 Insert A Picture
Resize & Reposition
Create A Graphic
Shapes Ò Fills, Borders & Effects
Lines - Colors, Sizes & Arrows
Select, Layer & Group
Snap To & Flip
Text In Drawings
WordArt
Organization Chart

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.