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.
Excel 2007 | 2010 Tutorials
Scroll down the page to see my Excel 2003 tutorials or click here
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.
Click Here to Start Excel 1
Note: this is a recording of a live webinar
Begin: Introduction to
3:21: Ended PowerPoint presentation | Windows logo key | How to open Excel | Create an Excel shortcut on desktop | Show desktop icon
5:23: Overview of Excel | Excel toolbars | Comparing Excel to Word | What is a workbook? | What is a worksheet? | Sheet 1, sheet 2 & sheet 3 | Workbook name | Title bar | Columns & Rows | Name box | Cells | Moving around a spreadsheet | Arrow keys | Page up & page down keys | How many rows? | Keyboard shortcuts | How many columns? | Find & Replace
17:20: Why use Excel | Is Excel the best choice?
19:10: Starting to use Excel | Example: tracking employee information | Entering information | Anticipating what I type | Zoom | Cell spillover | Resizing columns & rows | Leading zeros | Selecting multiple cells | Should I be thing about a template? | Undo & Redo
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.
38:10: Introducing Tony's Place | Formatting Tony's Place: making it look better | Cleaning up the numbers | Increase and decrease decimal: cleaning up the numbers | Working with round numbers | Editing contents of a cell | Formula Bar
43:50: Calculations: Adding together multiple cells | AutoSum | Dancing black ants
45:30: The 1/3, 1/3, 1/3 Rule
46:42: Manipulating data in a spreadsheet | Discussing the data | There's a problem | Insert a comment | Viewing a comment | Be careful with comments | Hiding a column or row | Unhide | Rows and columns are the same
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
Begin: Quick review of Excel 1: Includes formatting | Increase & decrease decimal point | Formula bar | AutoSum | Creating formulas | Using control and shift key to select cells | Understanding an existing spreadsheet | Using Google to help with Excel | Working with tabs | Tab colors I Tab scroll bar.
15:01: AutoFilter | Zooming in and out | Selecting multiple columns or rows | Filtering multiple columns | Drilling down filtered results.
23:11: PivotTables | Understanding your data | PivotTable wizard, selecting data for your PivotTable | PivotTable field list | Organizing PivotTable data | Filtering a PivotTable | Practice makes perfect.
32:41: Excel options | Recent file list count | Reviewing different tabs | Password protection | Zero values | Comment options and more.
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.
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)
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)
INTRODUCTION TO COMPUTERS
Basics: Computers 101
The Ribbon & more
Microsoft Excel: Introduction
Microsoft Excel: Advanced
Google Search Tips
Free Google Tools
iPhone Tips and Tricks
AMAZING FREE RESOURCES
Harvard and MIT
TED: Ideas Worth Spreading
Smarterer: Test Yourself