Excel Roundup 20150316

In this short video, Sara Silverstein shows how to analyze several years of NCAA revenue data, by using a pivot table. Can you predict which sport brings in the biggest revenues?

Or watch on YouTube: Use Excel pivot tables to analyze massive data sets

Contextures Posts

Here’s what I posted recently:

  • 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 related articles that I read recently, that you might find useful.

  • Matthew Eaton uses a simple table, and a Pareto chart, to track his personal habits, and calculate his success rate.
  • Aaron Souppouris takes a look at the new Office 2016 for Mac preview. He suggests that you try it, and warns you to "keep Office 2011 around for the important stuff."
  • Which would you choose to have in your workbook – an Excel Table, or Custom Views? Gašper Kamenšek would like to have both!
  • Is your budget spreadsheet a bully? Kathleen Elkins, at Business Insider, found a way to conquer hers, and find a bit of happiness.

Excel Announcements

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

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 this year should be even better! 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...

3 Responses

  1. Doug Glancy says:

    I agree about that John Weathington spends too much energy reassuring us we can still use Excel and show our faces in respectable data science establishments (not that you exactly said that). I like his simple point about using the filter dialog listbox to quickly eyeball the range of data in a column. It’s odd that he doesn’t talk about tables, which are much more effective than named ranges for organizing data, and have been for years.

  1. March 31, 2015

    […] Blog for giving me some much appreciated traffic by featuring the first post. I am grateful for you shining the spotlight on […]

Leave a Reply

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