Christmas is only 2-1/2 weeks away, so it’s time to start planning! Of course you’ll want to organize everything in a spreadsheet, so you can download the free Excel Holiday Planner, from my Contextures website.
It has shopping lists, budget sheets, task lists, and even a dinner planner, so get your copy, and get the holidays under control.
Contextures Posts
Here’s what I posted recently:
- Type a couple of letters in one columns, and in the next column, you can see a short drop down list , with only items that contain those specific letters.
- Grouping dates creates extra items in a pivot table filter, such as “<12/08/2014”. See a couple of workarounds for hiding those items.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. There is a poll at the end, so please vote for your favourite tweet.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- After the recent file hacking at Sony Pictures, Melanie Pinoa reminds you that you shouldn’t store all your passwords in an Excel file.
- Jordan Goldmeier takes a look at complicated Nested IF formulas, and when you should use them.
- Gašper Kamenše shows how to highlight the smallest and largest amounts in a column chart.
- Ben Orlin uses his bad drawings to explain multiplication and arrays. It might help your kids (or a co-worker), if they’re struggling to understand how Excel calculates things.
- Chandoo shows how to include markers for average or a target, in an in-cell chart.
- Are your columns clean? Zack Barresse explains the difference between clean and dirty columns in an Excel table.
- Maybe you could use this in your resignation spreadsheet — David Ringstrom shows how to add a pile of poo to your iPad Excel file.
- Vijay Verma created a crossword for Excel functions – I couldn’t see the two digit numbers on my screen, but maybe it’s okay in yours
- Randy Zwitch would like you to stop using Excel, because it is destroying his data
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
_________________________________