Excel Tutorial Videos

These free Excel tutorial videos will show you the basics of how to manage your workbooks in Microsoft Excel.

These are aimed at beginners in Excel but there are some advanced features, especially in the Formulas video, that non-beginners might not know.

Excel Tutorial Videos

You can find a full list of my free Excel Templates for Bookkeeping here.


If you have any questions or want to see videos on anything else, please leave a comment in the Comments section at the bottom of this page, or send me an email via the Contact Me page.

Excel Tutorial Video #1

Managing Sheets and Tabs

Managing Sheets Excel Tutorial Video - Main Contents: 

  • New Workbook Auto Add Sheets - 0:44
  • Inserting Extra Sheets - 2:34
  • Renaming Sheets - 2:54
  • Deleting Sheets - 3:25
  • Moving Sheets - 3:43
  • Grouping and Ungrouping Sheets - 3:57
  • Navigating and Editing Sheets - 5:09
  • Protecting and Hiding Sheets - 7:47

Excel Tutorial Video #2

Managing Columns

Managing Excel Columns Video - Main Contents:

"Selecting" Explained - 0:55
Insert Columns - 1:31
Delete Columns - 3:52
Hide and Unhide Columns - 4:50
Change Width, Fix #Error Symbols - 5:50
Other Editing Options - 6:57

Excel Tutorial Video #3

Managing Rows

Managing Excel Rows Video - Main Contents:

Inserting Rows - 0:28
Deleting Rows - 2:25
Fix #Ref! Error - 2:52
Hide and Unhide Rows - 3:55
Changing Row Height - 5:10
Clearing Row Data - 5:57

Excel Tutorial Video #4

Formula Basics

Excel Formulas Video - Main Contents:

Entering Formulas to Spreadsheet - 3:58
Copying or auto-filling formulas - 5:40
Sum function - 6:20
Fixing the #Value! error - 8:16
Linking cells formula - 9:50
Fixing the #Ref! error - 10:12
Transpose formula - 12:19
View all formulas - 16:57
Show and hide zero results - 17:27

DOWNLOAD THE FREE WORKBOOK TO PRACTICE
You must have Excel software or online subscription to use this Workbook.

Download WorkBook
Show / Hide

Got Questions or Want to Leave a Comment?
Contact Me