Excel Roundup 20141208
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.
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
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
Even You Can Learn Statistics and Analytics, by David M. Levine and David F. Stephan
"Now fully updated for "big data" analytics and the newest applications…Simple jargon-free explanations help you understand every technique, and extensive practical examples…all updated for the newest versions of Microsoft Excel…downloadable practice files, templates, data sets, and sample models – including complete solutions you can put right to work!
Registration is open for Felienne Hermans’ MOOC Course: "Using video lectures and hands-on exercises, we will teach you cutting-edge techniques and best practices that will boost your data analysis and visualization skills."
You can audit this 8-week course for free, and classes start Apr. 6, 2015.
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!
Links to Recent Excel Books on Amazon.com