Check out our new website at Online PC Learning.com for great tutorials on Microsoft Office 2010

Microsoft Excel 2003

There are 3 options to find the tutorial that you need.

1. Find by searching for a key word

2. Select from a dropdown list

3. Find by category and description

Microsoft Excel Tutorial Category
The Basics	Formatting	Filter data
Data Validation	Pivot Tables	Conditional Formatting
Charts	Worksheet Setup	Database Analysis

	Excel : The Basics
	Tutorial 1	Overview of the excel interface	Video
	Tutorial 2	Create a destop shortcut	Video
	Tutorial 3	Copy paste and cut	Video
	Tutorial 4	Sort data	Video
	Tutorial 5	Costum lists	Video
	Tutorial 6	Working with named ranges	Video
	Tutorial 7	Creating dynamic named ranges	Video
	Excel : Formatting
	Tutorial 8	Comments	Video
	Tutorial 9	Format text alignment text direction	Video
	Tutorial 10	Format borders and interior colors	Video
	Tutorial 11	Format numbers	Video
	Tutorial 12	Comments and formatting changing the shape	Video
	Excel : Data Filters
	Tutorial 13	Autofilter your data	Video
	Tutorial 14	Advanced filters	Video
	Excel : Data Validation
	Tutorial 15	Data validation	Video
	Tutorial 16	Data validation from a separate worksheet	Video
	Tutorial 17	Data validation and vlookup	Video
	Excel : Pivot Tables
	Tutorial 18	Pivot tables the basics	Video
	Tutorial 19	Pivot tables calculated fields	Video
	Tutorial 20	Pivot tables formatting the completed table	Video
	Excel : Conditional Formatting
	Tutorial 21	Conditional formatting	Video
	Tutorial 22	Conditional formatting using formulas	Video
	Tutorial 23	Conditional formatting examples to download	Video
	Excel : Charts
	Tutorial 24	The basics of charting	Video
	Tutorial 25	Creating your first chart	Video
	Tutorial 26	Formatting your charts	Video
	Tutorial 27	Make your charts dynamic	Video
	Tutorial 28	More dynamic charts autofilters	Video
	Tutorial 29	Make your charts dynamic (between dates)	Video
	Excel : Database Analysis
	Tutorial 30	Databases in Microsoft excel (Data lists)
	Excel : Worksheet Setup
	Tutorial 31	Set print area and page breaks	Video
	Tutorial 32	Protect the worksheet	Video
	Tutorial 33	Columns and rows ( insert and delete)	Video
	Tutorial 34	Freeze panes and split screens	Video
	Tutorial 35	Hide columns and rows	Video
	Tutorial 36	Hide worksheets and veryhidden worksheets	Video
	Tutorial 37	Move, copy, delete your worksheets	Video
	Tutorial 38	View multiple worksheets	Video
	Tutorial 39	Create an excel template	Video
	Excel : Formulas
	Tutorial 40	Count Counta CountBlank Functions	Video
	Tutorial 41	Countif Function (Part1)	Video
	Tutorial 42	Countif Function (Part2)	Video
	Tutorial 43	Vlookup Functions (Part1)	Video
	Tutorial 44	Vlookup Functions (Part2)	Video
	Tutorial45	Sumproduct Functions (Part1)	Video
	Tutorial 46	Sumproduct Functions (Part2)	Video
	Tutorial 47	Sum Function	Video
	Tutorial 48	Sumif Function	Video

                    

                       Thank you for taking the time to offer feedback and suggestions.
                       Is there a topic you would like to know a little more about then
                       please click the link above or email the suggestion and I will try
                       to access the needed information.