In this week’s roundup, prevent errors, break links, register for an Excel summit, download an Advent calendar, and more.
Excel Roundup 20151123
In this week’s roundup, get file creation dates, plan for Thanksgiving, create icons with number formatting, and much more.
Also, I’m making a list of Black Friday (Nov 27th) and Cyber Monday (Nov 30th) sales for Excel related products. I’ll post it here on Thursday, November 26th, so we can be ready!
If you’re having a sale, and would like it included in the list, please send me the details — ddalgleish AT contextures.com
15 Years of Excel Tips
The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because that was a loooong time ago, but it was definitely 2000 that I got the website up and running.
This week, I took a look back, and figured out how to get an Excel list that shows the original creation date of all my sample files. You can download a workbook with the sample code, below.
Excel Roundup 20151116
In this week’s roundup, create a rolling total, chart tricks, unmerge cells, clean data, and much more.
Create a Rolling Total in Excel
It’s easy to create a running total in Excel, and show the accumulated amount in each row. You can use the SUMIF function in a table, or show running totals in a pivot table.
But what if you want to show the total for a specific number of previous months – not all the previous months?
Excel Roundup 20151109
In this week’s roundup, find errors, lock slicers, plan for the holidays, use keyboard shortcuts, and much more.
Hide Formula Results Based on Date
My challenge this week was to show the running total in a list, but only for the current date and earlier. I wanted rows for future dates to appear empty, but have the formulas in them – ready to go. How would you solve that problem?
Excel Roundup 20151102
In this week’s roundup, prevent duplicate totals, build an Excel dashboard, formatting nit-picks, and much more.
Excel Subtotals With Duplicate Grand Totals
Do you use Excel’s Subtotal command to automatically create subtotals in a list? I prefer pivot tables, but still use Subtotals in a few macros for clients. Last week, one of them asked why there were duplicate Grand Totals after applying two levels of subtotals.
Continue reading “Excel Subtotals With Duplicate Grand Totals”
Excel Roundup 20151026
In this week’s roundup, combine data, select multiple items, power query tips, better reports, and much more.