Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

Excel Training Videos

  • Home
  •   »  
  • Excel Training Videos
Excel Training Videos
remove blank rows

How to Select and Remove Blank Rows (Video)

In this video we go over how to quickly remove blank rows from an Excel sheet and clean up some free space on our workbook

Excel Training Videos
compare two lists video

How to Compare Lists in Excel (Video)

In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but

Excel Training Videos
what is a pivot table

Pivot Tables (Video)

A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.

Excel Training Videos
count functions in excel

Learn the Count Functions (Video)

There are several COUNT functions in Excel. The video below will help you understand three of the most important ones.

Excel Training Videos
index and match excel

How to Use Index & Match (Video)

INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place

Excel Training Videos
Index Match in Excel

How to Use Vlookup (Video)

Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!

Excel Training Videos
30 minute excel tutorial for beginners

Excel Tutorial for Beginners (Run Time ~30 Minutes)

This is a crash in Microsoft Excel for total beginners. We’ll start by introducing ourselves to the workbook, slowly

Posts navigation

1 2 3 »
  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com