Excel Roundup 20150302
Spreadsheets are already fun, but Tableau wants to make them even more exciting, with its newest smartphone app, Elastic. In this video, Tableau’s VP of Mobile & Strategic Growth, Dave Story, opens a spreadsheet file (csv format) from his inbox, and shows how Elastic works.
I don’t see any information about the expected release date or pricing.
Here’s what I posted recently:
- Resize Excel comments to a consistent width, with a macro. Sometimes comments get too wide, or too narrow, and this macro can quickly fix them.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- To help you get started with Excel on the iPad, Microsoft Press explains how to store and retrieve data. It’s a free chapter from Microsoft Office for iPad Step by Step.
- Ken Puls uses Power Query to combine the data from multiple workbooks, into one table. All the files have a similar structure.
- Doug Glancy worked on VBA code to filter a table field, based on the filters applied in a different table. He made some interesting discoveries, and came out alive.
- NPR’s Planet Money podcast covers the history of spreadsheets, and the topic was inspired by Stephen Levy’s 1984 article, A Spreadsheet Way of Knowledge. There is an explicit language warning on the podcast, so listen at your own risk!
- Scott Lyerly finally learned what was causing the error, “That Command Cannot Be Used On Multiple Selections”. He’ll be more careful with his hidden sheets in the future!
- If you’re using Excel on an Android tablet, you can download the free Excel keyboard, with a number pad, that was recently released by Microsoft’s Garage.
- Robert Mundigl shows how to create word clouds in Excel, an update from his earlier method. Download his sample file, and try it out. And remember, don’t look a gift horse (or word cloud) in the mouth!
- When you don’t have fancy project management software, Sumit Bansal shows how to build a Gantt chart in Excel.
- Mike Alexander uses event code to automatically delete pivot table drilldown sheets, when the workbook closes.
- Gašper Kamenšek uses the TEXT function, with Locale codes, to show the day and month names in a variety of languages.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- Frankie and Matilda Learn Excel, by Denise Humphrey
- This is the first Excel book I’ve seen that’s aimed at children (ages 6-18)
- “Frankie (a dog) and Matilda (a cat) have been arguing all day about who eats the most food and they decide the best solution is to create a spreadsheet in Excel…You can create a spreadsheet like Frankie and Matilda’s as you follow the story and you can download data to practice in your own time if you wish.”
- Microsoft Office for iPad Step by Step, by Joan Lambert
- “This is learning made easy. Get productive fast with every Office for iPad app–plus OneNote, too! Jump in wherever you need answers–brisk lessons and colorful screen shots show you exactly what to do, step by step.”
- Problem Solving Cases In Microsoft Access and Excel, by Ellen Monk, Joseph Brady, Gerard S. Cook, Emillio Mendelsohn
- “Helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge as they walk you step-by-step through each software application’s capabilities, while 12 all-new case studies present scenarios and problems common in today’s business practice.”
- Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year’s summit was an outstanding success, and registration will open soon, for this year’s event. Registration is now open, and you can click here to register.
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