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
18
Mar
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
03
Mar
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,
31
Dec
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
06
Oct
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
06
Oct
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
30
Sep
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
30
Sep
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
27
Sep
Using AUTOFILL in Excel – Part 1
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the
27
Sep