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