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 →
If you use excel enough you’ll notice that after you make a decently complicated calculation, excel gives you the result in its entirety no matter how many decimals the result contains. The thing is, …
Continue Reading about ROUNDING FUNCTIONS – No More Rounding Differences (Sort of) →
I’m not talking about this guy… Sometimes we just need to count things (I guess that’s what makes us accountants). Excel provides huge efficiencies with its counting functions; COUNT, COUNTA, …
Continue Reading about COUNT – You can even count sheep with this! →
