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 →
The pivot table is one of the most powerful data analysis tools in excel, and one of the most asked about as well. Pivot tables can take a large amount of data and organize it in a way that is easy to …
Continue Reading about Pivot Tables – Powerful analysis in seconds →
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 →
There are many functions in excel that were intentionally created for use within other functions. To an excel novice, these functions seem useless. But not a pro who can spot the importance of such …
Continue Reading about Information Functions – Is it, or is it not? →
Whenever you need to cross reference two lists, the MATCH function is a pretty useful function to have in your arsenal. Just as the name implies, it checks whether an item in one list is present in …
