Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • Contact
Excel
Index Match in Excel

How to use INDEX and MATCH together

I’d probably list INDEX-MATCH in the top 5 things to know in excel if you want to add the skill to your resume and not

Excel
paste special

How to use Paste Special in Excel

Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values

Excel
Autofill in Excel

Using AUTOFILL in Excel – Part 2

(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste

Excel
Autofill in Excel

Using AUTOFILL in Excel – Part 1

The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the

Excel
Using iferror in Excel

Using IFERROR to trap and handle errors

When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?

Excel
count functions in excel

How to Use Excel’s COUNT Functions

There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post

Excel
text to columns

Text to Columns – Excel

Text to Columns is a very fun feature of Excel. This feature will help you break apart cells that have information that

Excel
text - len, right, left, mid

Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

Excel
if function in Excel

The IF Function in Excel & Boolean Logic

If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to

Posts navigation

« 1 2 3 4 »
  • Articles
  • Excel Training Videos
  • 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