Free Microsoft Excel Training

Microsoft Excel 2003 | 2007 | 2010
First and foremost, if you have any questions about how to make the most out of my free training simply call me to discuss what you are trying to accomplish. I love talking to my students!

Tony Holowitz: 781-728-9777 | Skype: tony.holowitz

Most of my Microsoft Excel training videos were recorded using Excel 2003. If you are using Excel 2007 or Excel 2010, the fundamentals you’ll learn in the Excel 2003 videos will carry over to these newer versions. The biggest change in Excel 2007 and 2010 is the new Ribbon navigation system and I have videos about the Ribbon. Quite simply, if you learn how to drive a car (Excel 2003), you don’t have to learn all over again when a new model (Excel 2007 | Excel 2010) is released.

Microsoft Excel 2007 | 2010 Tutorials
Scroll down the page to see my Excel 2003 tutorials or click here

Microsoft Excel 2007 | 2010: Reviewing the New Microsoft Ribbon
Start Here: Take me to the Ribbon page for a series of tutorials

Introduction to Excel 2007 | 2010 Part 1 (55:00)

Excel 2007 1

Introduction to Microsoft Excel 2007 2010 Part 2

Pasting spreadsheet data from Excel into Microsoft Word (3:00)
Microsoft Word: linking to data in an Excel spreadsheet (4:00)
Protecting a worksheet and workbook (2:00)

Microsoft Excel 2003

Excel 1 and 2 are full length classes. Excel 3 is made up of a series of short tutorials.

I have broken down these classes with time stamps, so you can move forwards or backwards to the point in the class that you want to review.

Excel 1 (58:00)

Click Here to Start Excel 1
Note: this is a recording of a live webinar

17:20: Why use Excel | Is Excel the best choice?

27:11: Formatting cells | Formatting Columns & Rows | Phone numbers, social security numbers, currency, zip code | Rethinking a template

31:25: Moving information | Pointer Shapes | Duplicating the contents of a cell (fill) | Completing patterns | Creating a numbered list

35:50: Saving a Template as an Excel file | See: Template tutorial | NOTE: on the tape I say I'm taking a break (it was a live class), please disregard, I edited it out.

43:50: Calculations: Adding together multiple cells | AutoSum | Dancing black ants

45:30: The 1/3, 1/3, 1/3 Rule

52:16: Adding a row or column | How it impacts a formula | Adding multiple rows or columns

53:58: Introduction to formulas | Cheating to remember! | Closing remarks

Excel 2 (55:00)

Click Here to Start Excel 2

15:01: AutoFilter | Zooming in and out | Selecting multiple columns or rows | Filtering multiple columns | Drilling down filtered results.

39:11: Creating a copy of a worksheet | Deleting a worksheet | Selecting data in multiple worksheets | Changing data in multiple worksheets.

44:11: Side-by-side comparisons.

46:43: A bunch of little things: naming a series of cells | Creating a commissions formula | Using a formula with a named cell | Conditional formatting and closing comments.

Excel 3: A Series of Short Tutorials (136:00)

Creating Formulas (8:00)
Filtering Data (6:00)
PivotTables 1 (6:00)
PivotTables 2 (7:00)
Save vs. Save As (7:00)
Adding a shortcut to Save As to the toolbar (3:00)
What is an Active Cell? (1:00)
Always Show Full Menus in Word, Excel & PowerPoint (2:00)
Pick from a dropdown list (2:00)
Add a custom list to Excel (3:00)
Excel's help feature: I'd use Google (4:00)
Excel's Spell check feature (2:00)
Concatenate Formula: Merging Stuff Together (5:00)
Putting same thing in multiple cells (1:00)
Excel paste options (6:00)
Creating a Fill Series (4:00)
Understanding autofill options (3:00)
Tony's Place quick review (to help with upcoming tutorials) (2:00)
AutoSum and some common Excel formulas (3:00)
Working with rows and columns (3:00)
Excel options (2:00)
Formatting text options (3:00)
AutoFormat (1:00)
Freeze Panes (2:00)
Two common formula errors (2:00)
Copying and pasting a formula (3:00)
Absolute and relative reference (3:00)
Now formula (2:00)
Editing worksheet tabs (2:00)
Specialty formatting (3:00)
Conditional formatting (2:00)
Printing a spreadsheet (3:00)
Data validation (2:00)
Named cells: naming a range (5:00)
Creating formulas with named ranges (6:00)
Creating a formula using multiple worksheets: Part 1 (3:00)
Creating a formula using multiple worksheets: Part 2 (2:00)
Linking a formula to a second workbook (3:00)
Introduction to Excel Charts: I love charts, I hate charts (7:00)
Showing (exposing) formulas in a spreadsheet (2:00)
Adding a calculator to the toolbar (2:00)
Adding a comment in Excel (4.00)
VLOOKUP Introduction: The Scenario & Example (6.00)
VLOOKUP Part 2: Looking at the formula (4.00)
VLOOKUP Part 3: A search engine for your spreadsheet (8.00)