Excel Nerds

DATE vs. DATEDIF Functions

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

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

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

Excel

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

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

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

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

Excel

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

Excel

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