Go Ask Debbie BLOG

If you've been following me for any amount of time, you know I'm all about learning how to use your tools, like Microsoft Office, to save yourself time and become more productive. Tools aren't meant to slow you down, but I see it too often where people struggle and waste time because they don't know how to do things properly or they don't know how to use certain features and functions in their tool - just like Excel. So, I've put together this list of 3 Excel Tips that will S

Do you know the difference between =SUM and =SUBTOTAL in Excel? Both provide totals, but when cells are hidden, the =SUM will provide the total for the entire column of data. But, what if you only want the total for the cells that are showing and don’t want to include those that are hidden? The answer is to use the =SUBTOTAL function in Excel. The syntax requires a reference as the first parameter – 109 tells Excel to use the SUM function and to NOT include hidden cells. See