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 …
I’m not sure why, but less people use the IFERROR function than I would expect. If you’re someone that likes to see neatly organized and clean spreadsheets (like me) then this section is for you. I …
Continue Reading about IFERROR – Make pesky formula errors go away →
The IF function in Microsoft Excel is one of the most important, versatile, and powerful tools excel has to offer and a must have for anyone becoming an excel pro. This function allows you to build …
Continue Reading about IF Function in Microsoft Excel: With Examples →
Why is VLOOKUP so awesome? The purpose for VLOOKUP is to help you find a single piece of information in a table based on a single criterion. Watch my video tutorial and learn all about …
Continue Reading about VLOOKUPS – What is the big deal anyway? →
Check out my SUMIFS video tutorial here: These three functions can be some of the most robust and powerful functions in excel and a strong addition to your arsenal. I’ll discuss what each one …
Continue Reading about SUMIFS, AVERAGEIFS, COUNTIFS – Make Intelligent Calculations →
