Excel Challenge Rolling Total
January 17, 2017
Try the Excel rolling total challenge, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
By default, when you turn on an AutoFilter, the dates are grouped by year and month in the drop down list. If you'd rather see the individual dates, you can change one of the Excel options
To turn off the date grouping in the active workbook, follow these steps, or watch my video:
NOTE: If you have my Excel Tools add-in, click the Workbook Appearance command, then click Toggle Filter Grouping.
Our last Excel challenge was fun, so here's a new one. With 24 months of financial data, across 24 columns, create a formula that will show a rolling total for prior months. Include a maximum of 12 months, and use the same formula in all 24 columns.
I'll show you my solution in next week's newsletter.
Here are a couple of recent Excel articles that you might find useful.
Excel AddIns - Excel MVP Michael Olafusi put together a helpful list of resources, if you'd like to learn how to build one of the new type of Excel Add-in. These add-ins can be used on Windows, Mac or mobile versions of Excel. (Level - Intermediate/Advanced)
Spreadsheet Threats - Maybe it's the cold medication, but this list of spreadsheet threats made me laugh. Warning - There's some mildly offensive language. (Level - All)
Last week, I made stew using one of my old cookbooks. You can tell which recipes are the favourites, based on the number of spatters on the page. I added a few of the frozen leftover wine cubes from Christmas, and it was delicious. Leftover wine is a rare item at my house ;-)
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:56 AM