Excel tips and tutorials
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
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.
In this week’s roundup, create a rolling total, chart tricks, unmerge cells, clean data, and much more.
In this week’s roundup, find errors, lock slicers, plan for the holidays, use keyboard shortcuts, and much more.
In this week’s roundup, prevent duplicate totals, build an Excel dashboard, formatting nit-picks, and much more.
In this week’s roundup, combine data, select multiple items, power query tips, better reports, and much more.
In this week’s roundup, delete sheets, hide passwords, use Boolean logic, and many more tips. I hope you’ve recovered from your Spreadsheet Day celebrations, and are ready to start a new week.
Happy Spreadsheet Day 2015! Thanks for stopping by, and please vote in the survey below, for the Spreadsheet Hall of Fame.
We celebrate on October 17th because that is the date on which VisiCalc was first released, way back in 1979 – and that was 36 years ago. How time flies when you’re having fun with spreadsheets!
In this week’s roundup, listing comments, LEGO, option buttons, and inheriting an Excel workbook.
In this week’s roundup, get started with Office 2016, nominations for a Spreadsheet Hall of Fame, and much more.