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


You may also like...

7 Responses

  1. Doug Glancy says:

    Thanks Debra! I am walking with a limp now, (probably due more to a mishap with a sledgehammer).

    The word cloud post is interesting, and I love that Bruce Springsteen’s third most frequent lyric word is “wanna.”

    • Thanks Doug, and sorry about your limp. Be careful out there! Maybe we should do a word cloud from Shakespeare’s works, to see how frequently he used “wanna”, or its equivalent from his time period.

      • Doug Glancy says:

        I like the Shakespeare idea. I was thinking maybe “prithee.” I did a search for Shakespeare word clouds and he seems to be a fairly unselfish fellow in the aggregate: lots of “thee’s” and “thou’s” and “love’s,” at least in the sonnets.

        Circling back to my autofilter post, I’d like to point out that snb took it the next (several) levels at http://www.snb-vba.eu/VBA_Autofilter_en.html. For anybody who hasn’t visited snb’s site, it’s quite an amazing VBA encyclopedia.

        • Doug,

          just to clarify: “wanna” is the third most common word only on Darkness on the Edge of Town (the record, not the song), not in Springsteen’s entire oeuvre. But it can get even worse: on Lucky Town (the record), “I’m” is the most common word…

          Seriously, in defense of the Boss (yes I admit, I am a fan): we have to be careful about the single words in a word cloud. That’s why word clouds are only good for infographics, not for serious data analysis. There are a lot of “I wanna” in the lyrics of Darkness on the Edge of Town, but also “you wanna” and one of my all-time favorite Springsteen lines: “poor man wanna be rich, rich man wanna be king”. Furthermore, the 200 most common words in English are excluded in my Excel Word Cloud. If they weren’t, the most common word would probably always be “the”.

          Love Debra’s Shakespeare idea, by the way.

          Many thanks for the link to snb. Looks amazing. Thanks for sharing.

  2. Thanks for the mention, Debra. Much appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *