Microsoft Excel Training Course & Tutorial

Microsoft Excel is a spreadsheet program that enables you to turn data into useful information. It has a powerful set of tools to help you perform highly sophisticated analysis of numerical, financial and graphical data.

This training course contains a series of video based tutorials which are designed to teach users the essential spreadsheet skills. It begins with the basics of the Microsoft Excel spreadsheet and quickly advances to cover the more advanced features, including functions, formulas, charts, importing and exporting data, Excel help and tips, and much more. You learn how to use Microsoft Excel in hours, not days.

Excercise files can be downloaded by subscribed members so you can follow along each tutorials and learn at your own pace.

Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.

Microsoft Excel training course 2003 image

Training Courses

Microsoft Office 2007 Training

Microsoft Excel 2003 Training

Excel VBA Training

Microsoft Access 2003 Training

Microsoft Access 2007 Training

Access VBA Training

Dreamweaver 8 Training

PowerPoint 2003 Training

Windows XP Training

Links

Please see below the Microsoft Excel training course outline. Access to all tutorials will be activated immediately when you subscribe.

Subscribe now or try a sample tutorial below

Sample tutorial: Creating Excel Formulas

Training Course Outline

Training Course Introduction

Getting Started

The interface

The menus

Customizing toolbars I

Customizing toolbars II

Navigating techniques

Getting help & assistance

Creating/Working with Excel Workbook

Creating a new workbook

Entering & editing data

Commenting

Managing Excel Workbooks

Saving & converting file to a web page

Opening a workbook

Securing an file

Adding and deleting worksheets

Adding rows & columns

Sharing files

Managing Excel Data

Working with data

Find & replace data

Naming cells & cell ranges

Creating lists

AutoFilter

Using data form

Data validation

Formatting Excel Worksheets

Formatting cells I

Formatting cells II

Adjusting width & height

Copying cell formatting

Using AutoFormat

Freeze/unfreeze rows & columns

Advanced Excel Worksheet Formatting

Using styles

Conditional formatting

Protecting cells

Inserting graphics

Working with Excel formulas

Operators

Creating formulas

Relative & absolute references

External references

Creating named constants

Concatenation

Working with Excel Functions

Functions & the function wizard

Common functions

Text functions

Date & time functions

Lookup functions

Working with charts

Creating charts

Editing charts

Formatting charts

Adding graphics to charts

Importing & Exporting Data

Importing data

Querying external database I

Querying external database II

Exporting data

Printing Excel Worksheets

Setting up

Headers & footers

Print what you want

Other Handy Excel Tips

Compare workbooks

Handy tricks

Useful shortcuts

	Microsoft Office 2007 Training \| Excel Training \| Microsoft Access Training \| Excel VBA Training \| Access VBA Training
	Dreamweaver Training \| PowerPoint Training \| WindowsXP Training \| Course List