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,
DATE vs. DATEDIF Functions
It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
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
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
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.
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
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
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
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