Free Excel Training Videos & Tutorials

Excel Training Videos:

Our goal is to have the LARGEST resource FREE high-quality Excel video tutorials on the Web! The following are Excel videos, tutorials, and different resources I have found on the web that are freely available.

Microsoft Excel is a very powerful tool and most of our students that attend a basic/intermediate Excel Course, always ask for more resources.  We recommend this site to anyone who has taking an excel training class or have even trained themselves. Last update 08/07/2013

Are you looking for QuickBooks Videos?

Are you Looking for Excel Blog Tutorials?

Free Excel Training videos from UDEMY:

• The Syntax of the IF Statement
• Nesting The IF Statement
• Use The AND Operator To Reduce Quantity…
• Use The OR Operator To Reduce Quantity…
• The NOT Operator Within AND And OR…
• SUMIF For Selective Adding Up
• COUNTIF For Selective Counting
• AVERAGEIF For The Mean Of Cells That…
• Multiple Criteria Within The Same SUM…
• VLOOKUP Explained
• Applied Examples for VLOOKUP
• HLOOKUP Explained
• HLOOKUP In Action
• Looking For A Near Match In A Lookup
• Checking For Missing Data In A Lookup
• Extending The Size Of A Lookup Table
• Nested LOOKUPs
• Creating A New Workbook
• Saving A Workbook
• Entering Text And Numbers
• Entering Numbers As Text
• Inputting Dates And Times
• Editing The Contents Of A Cell
• Using Copy And Paste
• Searching For Values In A Worksheet
• Subtotals
• Exercise: Subtotals
• Pivot Table Concept
• Exercise: Pivot Table Concepts
• Formula Basics
• Vlookup
• Intro to PivotTables
• Custom Views (Printer and Screen Settings)
• Build a simple chart
• Dynamic Labels
• Text Formulas
• Help with Functions
• Applying Conditional Formats
• Creating SparkLines
• Data Validation
• Importing a Text File
• Freeze and Split Frames
• Cell Number Formats
• Screen Layout
• Name Box
• Data Entry, Cursors, Smart Tag
• The Ribbon
• Create Formulas in a Worksheet
• Introduction to Basic Table Editing
• Basics: Introduction to Basis Cell Formatting
• Cell Color
• Basics: Introduction to Printing
• Bascis: Entering Data (2007)
• Adjusting Column Width and Row Height (2007)
• Using Zoom (2007)
• Recognizing Interface Features Unique to Excel
• Basics: Entering Text
• Basics: Modifying Workbook & Worksheet Structure
• Basics: Excel Calculations 101
• Basics: The Foundation of Functions
• Creating Named Cells
• Applying Basic Formatting
• Getting In-Cell Summaries with Sparklines
• Converting Data Ranges to Tables
• Modifying Table Formatting
• Configuring Excel Options
• Print Area, Print Titles & Sheet Options
• Basics: Entering and Editing Data
• Basics: Excel, The Excel Window And User Interface

From ExcelExposure.com  Excel 2010 Training
First, DOWNLOAD EXCEL WORKBOOK

• Beginner’s Introduction to Excel [19:44]
• Basic Formatting Techniques [08:06]
• Absolute and Relative Cell Referencing (i.e. the $ sign) [07:44]
• Math & Statistical Functions (e.g. SUM, AVERAGE) [13:53]
• Date & Time Functions (e.g. TODAY, MONTH) [13:25]
• Text Functions (e.g. LEN, CONCATENATE) [14:34]
• Logical Functions (e.g. IF, AND) [14:56]
• Lookup & Reference Functions (e.g. VLOOKUP, MATCH) [14:04]
• Naming Ranges and Cells [09:58]
• Data Validation with In-Cell Drop-Down List [08:54]
• Conditional Formatting [09:11]
• Introduction to Pivot Tables [06:57]
• Advanced Pivot Tables: Round 1 [08:18]
• Advanced Pivot Tables: Round 2 [11:19]
• Auto-Filter and Advanced Data Filtering [06:34]
• Creating and Designing Charts (including Sparklines) [14:48]
• Error Checking and Data Monitoring [16:52]
• Information Functions (e.g. CELL, ISNUMBER) [09:44]
• Formula Auditing & Formula Evaluation [07:28]
• Advanced VLOOKUP Examples [14:36]
• Advanced INDEX & MATCH Lookup Examples [09:40]
• Five Powerful Excel Tips [15:19]
• Introduction to Macros & VBA programming [13:08]
• VBA Macro Walkthrough #1: Purchase Order Generator [17:28]
• VBA Macro Walkthrough #2: Message Encoder & Decoder [16:51]
• Excel 2013: In-Depth Preview [15:29]

From Lynda.com – Excel Training videos

• Using Backstage view or the File tab – 3m 25s  
• Adding numbers using Sum and AutoSum – 6m 11s  
• Preventing errors using absolute references – 5m 57s  
• Inserting SmartArt – 6m 54s
• Using templates – 4m 9s
• Freezing panes 3m 0s  
• Creating a Basic Pivot Table
• Inserting Sparklines – 3m 54s  
• Customizing the Ribbon bar – 8m 44s  
• Excel 2013: Selecting the right chart type 4m 24s  
• 2013: Creating charts with the keyboard and the Quick Analysis tool – 2m 34s  
• 2013: Choosing a chart layout with the Quick Layout option – 3m 1s  
• 2013: Creating dynamic charts that always show the last “N” periods of data – 5m 31s  
• 2013 Basics: Using the Formula bar 1m 43s  
• 2013 Basics: Exploring data entry and editing techniques 4m 41s  
• 2013 Basics: Creating simple formulas: Totals and averages 5m 25s  
• 2013 Basics: Calculating year-to-date profits 3m 9s  
• 2013 Basics: Exploring numeric and special formatting 5m 36s  
• 2013: Creating PivotTables 8m 36s  
• 2013: Numbering rows in a range or table 2m 44s  
• 2013: Displaying a workbook’s full path 2m 6s
• 2013: Picking data from a list 1m 40s 
• 2013: Using INDEX and MATCH to look up data without using the left-most column 5m 47s  
• 2013: Creating and selecting named ranges quickly 3m 27s  
• 2013: Creating a chart by pressing one key (or two) 1m 34s
• 2013 Advanced Excel: Displaying and highlighting formulas 5m 10s  
• 2013 Advanced Excel: Understanding the hierarchy of operations in Excel formulas 3m 19s  
• 2013 Advanced Excel: Exploring IF logical tests and using relational operators 3m 33s  
• 2013 Advanced Excel: Looking up information with VLOOKUP and HLOOKUP 3m 57s
• 2013 Advanced Excel: Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF 5m 9s
• 2013 Advanced Excel: Finding the middle value with MEDIAN 2m 46s  
• 2013 Advanced Excel: Working with ROUND, ROUNDUP, and ROUNDDOWN 6m 5s  
• 2013 Pivot Tables: Creating a Recommended PivotTable 2m 6s  
• 2013 Pivot Tables: Creating a calculated field 3m 8s  
• 2013 Pivot Tables: Filtering a PivotTable using a search filter 3m 18s  
• 2013 Pivot Tables: Applying a PivotTable style 2m 36s  
• 2013 Pivot Tables: Pivoting a PivotChart 2m 24s  
• 2013 Pivot Tables: Formatting cells using icon sets 4m 10s  
• 2013 Pivot Tables: Creating a PowerPivot PivotTable 4m 21s  
• 2013 Pivot Tables: Creating a map 2m 31s

From ExcellsFun (Youtube Channel dedicated to Excel Training)

• Excel Finance Class – over 100 Excel videos ranging from Accounting, to Finance, to Investment analysis.

Other Resources:

• excelforum.com – Answers forum
• excelbanter.com – Answers Forum
• ExcelExposure.com – Excel tutorial with workbook

Excel Training Tutorials Blog Posts:

• Build more connections with new communities in Microsoft Teams and GroupMe features June 1, 2023
  Today we're announcing new updates to the free version of Microsoft Teams that will allow you to create communities from scratch, share and invite members, create and host events, moderate content with critical trust and safety features, and get notified about all important activities. The post Build more connections with new communities in Microsoft Te […]
  Amit Fulay
• Empowering every developer with plugins for Microsoft 365 Copilot May 23, 2023
  Generative AI models are ushering in the next frontier in interactions between humans and computers. Just like graphical user interfaces brought computing within reach of hundreds of millions of people three decades ago, next-generation AI will take it even further, making technology more accessible through the most universal interface—natural language. The […]
  Rajesh Jha

IF YOU CANNOT FIND WHAT YOU ARE LOOKING FOR, EMAIL US: hector@qbkaccounting.com

We can also provide customized Excel and QuickBooks Training solutions for your business.  We have Excel Basic/Intermediate courses in Davie,FL.  We can offer Advanced Excel Training as well.