The SUBSTITUTE function is incredible for cleaning up text. You can replace a string of text with whatever you’d like,
I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how
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
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the
When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?