Excel Roundup 20141215
Thank you for reading my Excel Roundup every Monday, and after this week, I will be taking a couple of weeks off, to enjoy the holidays. There will be a blog post here this Thursday, and the next roundup will be posted on January 5th.
To help you celebrate, here is a no-macro animated Christmas tree, created in Excel, of course. Just move the scroll bar, to add lights, tinsel, a star, and presents, to the tree. You could use this technique for less festive projects too, like a business dashboard. Read the details on my Contextures website.
Here’s what I posted recently:
- Select multiple items from a long drop down list, using a popup form with combo box and list box.
- 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.
- The ModelOff 2014 Financial Modeling World Championship has ended, and the winner was 29-year-old Diarmuid Early, from Ireland.
- You can download the first chapter of Ben Jones’ book, Communication Data with Tableau. The chapter is titled “Communicating Data”, and the concepts can be applied to your work in Excel too.
- Diane Poremsky shows how to use a macro, to send a list of all messages and attachment names from an Outlook folder, to Excel.
- Many knitters use Excel to create their patterns, including Victoria Lewin, who made this moose hat, like the one Macaulay Culkin wears in Home Alone.
- Charles Verdon uses Excel 2013 with the Power BI add-ins, to analyze data from a Facebook page.
- University students share their VBA projects, after taking a one semester course at Brigham Young University. There is a wide variety of topics, including Laser Tag, Murphy Bed Job Costing, and Forecasting Automation
- Last week, an Office update broke the ActiveX controls in Excel, and Jan Karel Pieterse shows how to fix the problem
- Celia Emmelhainz analyzes the data from a librarian survey, using Excel, even though she finds it clunky, and it only lets you do simple stuff.
- XOR LX shows how to create a unique, ordered list of most frequent numbers in a two-dimensional range, and admits that it’s not the most straightforward solution.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
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