Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

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

excel formulas

  • Home
  •   »  
  • excel formulas
Excel
dates in excel

Find the Difference Between Two DateTimes in Excel

Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding

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
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 Functions Excel Math Functions
RANDBETWEEN – Excel Function

RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

Excel Functions Excel Math Functions
RAND – Excel Function

RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

Excel Functions Excel Math Functions
AVERAGE – Excel Function

AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

Excel Functions Excel Math Functions
SMALL – Excel Function

SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

Posts navigation

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