How to set up a running total column in Excel

200 level, Excel
[wp_ad_camp_1] [wp_ad_camp_4] Have you needed to set up a running total column in Excel? Perhaps you needed to maintain an account balance in the far right column of a worksheet. And then did you find yourself using one formula for the first row in the column, and then another formula to start adding the current row to the previous row? Well, as you know that method works. It's just a bit quirky looking -- and if you want to use that method in a table you aren't able to take advantage of the autofilling capabilities of the table. Here is a simpler way. It uses a mix of absolute and relative references on a range within the sum function. So, if you originally had a series of formulas that looked…
Read More

How you can “pin” the current date or time in Excel

200 level, Excel
Have you ever used the TODAY() or the NOW() function in Excel? They make it super easy to insert the current date and time into your worksheet. So long as you want the value to always be current those functions are great. If you open the worksheet tomorrow, the date or time information will reflect that moment in time. But, what if you wanted to put this moment in time into your worksheet -- and have that date or time be persistent. Or, what if you wanted to insert more of a timestamp than a dynamic date or time value? Here's a hot-key combination that makes that super easy too. Press CTRL+; (that's control and the semicolon) to insert the current date. Press CTRL+SHIFT+; (that's control, shift, and the semicolon)…
Read More