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… →
Whether you’re an excel rookie or a black belt, keyboard shortcuts are one of the fundamental things you should learn. If you can master just a few of the excel keyboard shortcuts in this post, you …
