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:

• Microsoft named a Leader in 2023 Gartner® Magic Quadrant™ for Unified Communications as a Service for the fifth year in a row  December 7, 2023
  We are honored to announce that Gartner® has recognized Microsoft as a Leader in the 2023 Gartner® Magic Quadrant™ for Unified Communications as a Service (UCaaS)—this is the fifth consecutive year we’ve received this recognition. The post Microsoft named a Leader in 2023 Gartner® Magic Quadrant™ for Unified Communications as a Service for the fifth year in […]
  Nicole Herskowitz
• 3 reasons why now is the time to go cloud native for device management December 5, 2023
  Discover these three recent customer stories to better understand the full value of becoming cloud native. The post 3 reasons why now is the time to go cloud native for device management appeared first on Microsoft 365 Blog.
  Michael Wallent

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.