I’ve seen a lot of questions on Quora that go a little like this: “What does it mean when Excel gives you [insert error]?” Becoming awesome at excel by learning cool tricks are important, but …
Continue Reading about Excel Errors: How to be awesome at fixing them →
Spoiler alert... nothing will happen. But, isn't that the problem? Nothing will happen! You might have the same job, drive the same car, maybe have similar pay, working for a similar manager. …
Continue Reading about What happens if I don’t learn excel? →
Imagine for a second that you’re at the job interview and the person judging whether you're a fit for their company asks how much excel you know. uh oh, you think, as you're palms get sweaty and your …
Although this Book has mainly focused on useful excel function, being an excel pro isn’t always about knowing a ton of functions. Conditional formatting is one of the areas of excel that can be …
Continue Reading about Conditional Formatting – Automatically highlight key data points →
INDEX MATCH INDEX MATCH is a set of functions nested together that essentially performs the same task that VLOOKUP does, except it does it a little differently (and more efficiently). This formula is …
Ever have a cell that contains a value and you wished you can go in and extract a small piece of the value but leave the rest behind (ie. just the last name in a list of names)? How do you go about …
Continue Reading about Text Functions – Best way to manipulate text in Excel →
