Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • Contact

Excel

  • Home
  •   »  
  • Excel   »   Page 2
Excel
Sumifs in Excel

Using SUMIFS in Excel to Analyze a Budget

Creating a budget in Excel can be a painstaking process. Auditing what you spend on groceries, entertainment, rent,

Excel
date vs. datedif function

DATE vs. DATEDIF Functions

It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a

Excel
average, averagea, and averageifs

AVERAGE vs. AVERAGEA vs. AVERAGEIFS

The AVERAGE functions in Excel are nice set of functions to get under your tool belt if data analysis is at all part of your

Excel
Clean up Large Text Strings in Excel

Seven Excel Text Functions

Following up on our post about some of the most commonly used Excel text functions, today we’re going to focus on

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.

Excel
min and max

Min and Max Functions in Excel

Very often in Excel you want to summarize a set of data to pull out insights. The MIN and MAX functions can help you do

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
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

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