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:
Unable to display feed at this time.
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.