Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Merch
  • Excel Courses
Excel
rate of change excel

How to Calculate the Rate of Change in Excel (Shortcut)

In this post I’ll show you a quick excel shortcut for calculating a rate of change. Rate of change is defined as the

Excel
Two lists in excel

How to Compare Two Lists in Excel

When analyzing data you often have to compare two lists to see if They both contain the same data You’re missing data

Excel
sutbstitute formula excel

Using SUBSTITUTE and CHAR to remove a block of unwanted text

The SUBSTITUTE function is incredible for cleaning up text. You can replace a string of text with whatever you’d like,

Excel
top things to know in Excel

Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

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
dates in excel

Dates in Excel – Part 1

Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the

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

Posts navigation

« 1 2 3 »
  • 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