Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Excel Courses

learn excel

  • Home
  •   »  
  • learn excel
Excel
xlookup vs. index and match

XLOOKUP vs. INDEX & MATCH

The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.

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

Videos
common mistakes

Common Errors in Excel (Video)

In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero

Videos
left, right, and mid functions

Learn the LEFT, RIGHT, and MID Functions in Excel

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

Videos
delete_columns_rows

How to Delete Extra Columns and Rows (Video)

In this video we’ll cover how to delete extra columns and rows in Excel using the keyboard shortcuts! View this post on

  • Articles
  • Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Text Functions
    • Math Functions
    • Logical Functions
    • Lookup and Reference Functions
Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com