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.

Contextures Posts

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.

  • 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.
  • 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!

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

Excel Books

  • 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.”

Excel Summit

  • 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!

Weekly Excel Roundup http://blog.contextures.com/

_____________________

Links to Recent Excel Books on Amazon.com

   

_________________________________