Excel Video Tutorials

Developer Microsoft Latest Release version 2007 Operating System Microsoft Windows Website Microsoft Excel Description Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for Excel 2008 for Mac OS X, a macro programming language called VBA (Visual Basic for Applications). It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993[citation needed], and is bundled as part of Microsoft Office. Excel is one of the most popular microcomputer applications to date.

Introduction

First Glance at Excel 2003  (VTC.com)
Why Choose Excel 2003  (VTC.com)
About Spreadsheets  (VTC.com)
Touring Excel – Pt.1  (VTC.com)
Touring Excel – Pt.2  (VTC.com)
Features New to Excel 2003  (VTC.com)
Spreadsheet uses  (Lynda.com)
Toolbars and menus  (Lynda.com)
Moving around  (Lynda.com)
Get help  (Lynda.com)
Introduction to Microsoft Excel 2003 (Running Time: 5:56)  (learnoffice2003.com)
Workbooks and Worksheets (Running Time: 23:45)  (learnoffice2003.com)

Installing

Recommendations Before You Install   (VTC.com)
Minimum System Requirements  (VTC.com)
Using Excel Setup   (VTC.com)
Troubleshooting Excel 2003 Installation  (VTC.com)
Performance Issues with Excel 2003   (VTC.com)

Getting Help and Assistance

Ways to Increase Your Aptitude   (VTC.com)
Exploring the Assistance Menu  (VTC.com)
Type a Question for Assistance   (VTC.com)
Using Microsoft Office Online   (VTC.com)

Basics

Opening new workbooks  (Lynda.com)
Entering data  (Lynda.com)
Inserting a new worksheet  (teach-ict.com)
Moving a worksheet  (teach-ict.com)
Making a copy of a worksheet  (teach-ict.com)
Commenting and saving  (Lynda.com)
Inserting a comment  (teach-ict.com)
Making the comment box visible all the time  (teach-ict.com)
Freezing panes  (teach-ict.com)
Hiding a column  (teach-ict.com)
Adding a hyperlink to a web page or within the workbook  (teach-ict.com)
Importing external data  (teach-ict.com)

Intermediate

Using Paste Special  (datapigtechnologies.com)
Using Text to Columns  (datapigtechnologies.com)
Using Goal Seek  (datapigtechnologies.com)
Protecting particular cells in a worksheet  (teach-ict.com)
Basics of Protecting a Worksheet  (datapigtechnologies.com)
Basics of Using Subtotals  (datapigtechnologies.com)
Grouping Tabs to Save Time  (datapigtechnologies.com)
Drop down pick list  (teach-ict.com)

Formatting

Adding a border to a table  (teach-ict.com)
Changing the background colour of cells  (teach-ict.com)
Clearing all cell formats  (teach-ict.com)
Adding headers/footers  (teach-ict.com)
Using the Format Painter tool  (teach-ict.com)
Showing and hiding gridlines  (teach-ict.com)
Merging cells  (teach-ict.com)
Wrapping text in cells  (teach-ict.com)
Hiding sheet tabs  (teach-ict.com)
Hiding scroll bars  (teach-ict.com)
Formatting Tricks  (datapigtechnologies.com)

Conditional Formating

Conditional Formatting  (teach-ict.com)
About Conditional Formatting  (datapigtechnologies.com)
Conditional Format with Four Conditions  (datapigtechnologies.com)
Alternate Shading with Conditional Formatting  (datapigtechnologies.com)

Sorting, Filtering, and Searching

Tips on Filtering with AutoFilter  (datapigtechnologies.com)
Sorting data in a table  (teach-ict.com)
Goal Seek  (teach-ict.com)

Functions and Formulas

Basics

Absolute cell reference  (teach-ict.com)
Autofill to copy formulae  (teach-ict.com)
Showing formulae  (teach-ict.com)
Hiding formulae  (teach-ict.com)
Picking up a value from the same sheet by using a formula  (teach-ict.com)
Picking up a value from another sheet by using a formula  (teach-ict.com)

Specific functions and formulae

Average formula  (teach-ict.com)
CountA formula  (teach-ict.com)
CountIF formula  (teach-ict.com)
Using the COUNTIF() to Find Duplicates  (datapigtechnologies.com)
Cell Information Functions  (datapigtechnologies.com)
IF formula  (teach-ict.com)
IF(AND()) and IF(OR())  (datapigtechnologies.com)
Matrix Lookup Formula (Index and Match)  (datapigtechnologies.com)
Max formula  (teach-ict.com)
Min formula  (teach-ict.com)
Multiplication formula  (teach-ict.com)
Sum formula  (teach-ict.com)
SumIF formula  (teach-ict.com)
Using the SumProduct() Function  (datapigtechnologies.com)
Vlookup  (teach-ict.com)
VLOOKUP formulas made easy  (datapigtechnologies.com)
Text and String Functions  (datapigtechnologies.com)
Set Duplicates Warning with Data Validation  (datapigtechnologies.com)
Basics of Nested Formulas  (datapigtechnologies.com)
Conditional Sums and Array Formulas  (datapigtechnologies.com)
Formula to convert your dates to quarters  (datapigtechnologies.com)
Using the SUBTOTALS Function  (datapigtechnologies.com)

Charts

Axis - changing values  (teach-ict.com)
Chart type - changing it   (teach-ict.com)
Colours - changing them  (teach-ict.com)
New chart - making one  (teach-ict.com)
Pie chart - adding labels  (teach-ict.com)
Formatting Charts  (datapigtechnologies.com)
Combo Charts and Formatting Data Points  (datapigtechnologies.com)
Create Dynamic Chart Labels  (datapigtechnologies.com)
Create a Histogram Chart  (datapigtechnologies.com)
Create a Basic Water Fall Chart  (datapigtechnologies.com)
Using the Bar to Pie Chart  (datapigtechnologies.com)
Add Average Line to a Chart  (datapigtechnologies.com)
Invert Negatives in a Chart  (datapigtechnologies.com)
Get Graphical without Charts  (datapigtechnologies.com)
Use Excel Charts in PowerPoint Without Bloat  (datapigtechnologies.com)
Quick and Easy Organizational Chart  (datapigtechnologies.com)

Validation

Data Validation in Excel  (datapigtechnologies.com)

Macros

All About Recording Macros  (datapigtechnologies.com)
Quick overview of VBA  (datapigtechnologies.com)
Understanding Reference Libraries  (datapigtechnologies.com)
Declaring Variables  (datapigtechnologies.com)
Using If Statements  (datapigtechnologies.com)
Using Select Case Statements  (datapigtechnologies.com)
The Basics of the Do Loops  (datapigtechnologies.com)
Using For Next Loops  (datapigtechnologies.com)
Looping with For Each Statements  (datapigtechnologies.com)

Visual Basic for Excel

Pivot Tables

Create a Basic Pivot Table  (datapigtechnologies.com)
Sorting in a Pivot Table  (datapigtechnologies.com)
Create a Drill Down Effect with a Pivot Table  (datapigtechnologies.com)
Adding a Calculated Field in a Pivot Table  (datapigtechnologies.com)
Grouping in a Pivot Table  (datapigtechnologies.com)
Creating Pivot Charts  (datapigtechnologies.com)
Using Pivot Table Advanced Options  (datapigtechnologies.com)

Printing

Basics of Print Setup Options  (datapigtechnologies.com)
Gridlines  (teach-ict.com)
Orientation - PortraitandLandscape  (teach-ict.com)
Print Preview  (teach-ict.com)
Print area - how to set it  (teach-ict.com)
Printing to one page  (teach-ict.com)
Row and column headers - displaying  (teach-ict.com)

Previous Versions of Excel

Excel 2002 (XP)

About Excel  (VTC.com)
Open, Save, Close Workbooks   (VTC.com)
What’s Inside the Workbook   (VTC.com)
Menus and Toolbars  (VTC.com)
What’s on a Worksheet  (VTC.com)
Get Assistance from Excel   (VTC.com)
Select and Navigate Cells   (VTC.com)
Enter Data  (VTC.com)
Edit and Delete Data  (VTC.com)
Undo and Redo   (VTC.com)
Cut, Copy, Paste  (VTC.com)
About the Office Clipboard   (VTC.com)
Drag and Drop   (VTC.com)
AutoFill   (VTC.com)
More Ways to Enter Repetitive Data   (VTC.com)
AutoCorrect   (VTC.com)
Use a Data Entry Form   (VTC.com)
Validate Data During Entry  (VTC.com)
Resize Rows and Columns   (VTC.com)
Insert and Delete Rows, Columns, Cells  (VTC.com)
Rename Worksheets  (VTC.com)
Move and Copy Worksheets   (VTC.com)
Insert and Delete Worksheets   (VTC.com)
Freeze and Split a Worksheet  (VTC.com)
Open Multiple Windows   (VTC.com)

Excel 2000

Introduction to Excel  (uncfsu.edu/itts/training/tutorials.htm)
Building the Worksheet: Adding Labes and Values  (uncfsu.edu/itts/training/tutorials.htm)
Entering Data and AutoFill  (uncfsu.edu/itts/training/tutorials.htm)
Calculating Totals  (uncfsu.edu/itts/training/tutorials.htm)
Formatting the Spreadsheet  (uncfsu.edu/itts/training/tutorials.htm)
Create a Default Bar Chart - F11  (uncfsu.edu/itts/training/tutorials.htm)
Create an Embedded Chart  (uncfsu.edu/itts/training/tutorials.htm)
Copying or moving a hyperlink  (pcshowandtell.com)
Get Started  (VTC.com)
The Interface   (VTC.com)
Menus  (VTC.com)
Toolbars   (VTC.com)
Formula Bar   (VTC.com)
Columns and Rows   (VTC.com)
Scroll Bars   (VTC.com)
Sheet Tabs  (VTC.com)
Status Bar  (VTC.com)
Interface Review   (VTC.com)
Workbooks and Worksheets  (VTC.com)
Open and Close Workbooks   (VTC.com)
Save Workbooks  (VTC.com)
Get Help   (VTC.com)
Select and Navigate Cells  (VTC.com)
Enter Data  (VTC.com)
Edit and Delete Data  (VTC.com)
Cut, Copy and Paste  (VTC.com)
Undo and Redo  (VTC.com)
Drag and Drop  (VTC.com)
Auto Fill  (VTC.com)
AutoCorrect  (VTC.com)
Zoom Control  (VTC.com)
Views  (VTC.com)
Resize Rows and Columns  (VTC.com)
Insert Cells  (VTC.com)
Delete Cells  (VTC.com)
Insert and Delete Rows and Columns  (VTC.com)
Rename Worksheets   (VTC.com)
Insert and Delete Worksheets  (VTC.com)
Move and Copy Worksheets  (VTC.com)
Hide and Unhide   (VTC.com)