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)

Intermediate and Advanced Excel 2007 | 2010

Guest Instructor
John Donovan, consultant and instructor at www.TeachMSOffice.com has an innate ability to take very complex Microsoft Excel topics and make them easy and simple to understand. John has been kind enough to allow me to post links to his YouTube videos here at teachanolddognewtricks.com for my students.

If you like John’s teaching style please consider subscribing to his training at www.TeachMSoffice.com. In addition, John does Excel consulting and development.

NOTE: If your IT department restricts access to YouTube, you will have difficulty reviewing these tutorials.

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.