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! →
I find SUBTOTAL to be a wild card function, so to speak. You can use SUBTOTAL in many different ways (Adding, counting, averaging, etc.), but the most usefulness I get out of this function is to use …
Continue Reading about The SUBTOTAL Function – Total Filtered Lists →
Just like anything else in excel there are more than one way to accomplish something, and averaging values is no different. The AVERAGE function helps you accomplish this efficiently and it works the …
Continue Reading about The AVERAGE Function – One-hit Averages! →
Of all the functions in excel, SUM is probably one of the most widely used. As the name suggests, it is used to sum, or total, numbers together. If you are familiar with this function feel free and …
Continue Reading about The SUM Function – Add numbers quickly! →
From my experience teaching excel, one of the main things people forget about when writing formulas and functions are their absolute and relative cell references. The funny thing is lots of people are …
Continue Reading about Absolute vs Relative References – This is simple, but easy to forget… →
