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
Here’s what I posted recently:
- Highlight numbers that are found in another list, with conditional formatting. This example uses lottery numbers, and you could use the same technique for other types of lists, such as names, or dates.
- 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.
- In a follow up to the ActiveX control problems caused by a Microsoft Security update in December, Jan Karel Pieterse announced that Microsoft’s March 10th update should automatically fix the problem.
- 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!
- John Weathington lists 5 things that every data scientist should know about Excel. He claims it’s been his secret weapon for decades, but the article’s tone seems condescending.
- Jeff Weir wants to know which features you’d like to see improved in Excel? Or do you thinks it’s perfect, just the way it is?
- In last week’s roundup, Doug Glancy suggested a great story about data interpretation, in an excerpt from the book, How Not to be Wrong. Scroll down to the section titled, Abraham Wald And The Missing Bullet Holes.
- Chris Webb adds the AGGREGATE function to his table, so he can use Slicers to filter his Power Query results. You can download the sample file, to see how it works.
- Is your budget spreadsheet a bully? Kathleen Elkins, at Business Insider, found a way to conquer hers, and find a bit of happiness.
- Ben Orlin, from Math With Bad Drawings, explains that when it comes to calculating area, everything is rectangles.
- Richard Harker shows how to create a dynamic 12 month rolling column chart, from horizontal data.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- 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!
Links to Recent Excel Books on Amazon.com