Your Excel Tips - Spreadsheet Hall of Fame
Oct 6, 2015
Spreadsheet Hall of Fame, quick totals, and much more, in this week's Excel news.
- Debra - email@example.com
Thanks for sharing your memories for the Excel 30th Anniversary article. Some of you have been using spreadsheets for a loooong time! The stories were fascinating, and it's fun to see how many different ways Excel has been used.
Quick Total With Pivot Tables
Last week, someone asked me how to keep track of student and parent activities at their school. You can build similar reports for a business, tracking products, or customers, or staff.
"we are trying to find a way to track Parent and the child's name...then at the end of the month...see how many times they were late, left early, visited or Volunteered"
An easy way to get quick totals is to enter the data in a named Excel table, and then use a pivot table to get a monthly summary. I uploaded a sample solution, and you can click here to download the file.
Spreadsheet Hall of Fame
There is a Rock and Roll Hall of Fame, and a Toy Hall of Fame, so why isn't there a Spreadsheet Hall of Fame? My goal for this year's Spreadsheet Day (October 17th – mark your calendar!) is to create one, and I need your help.
Who or what should be included? People? Programs? Functions? Features? There is a short survey on my Contextures blog, so please click here to add your nomination for the first inductees.
Here are a couple of Excel articles I read recently, that you might find interesting and useful.
Convert Files -- David Ringstrom shows how you can quickly convert an xls format workbook into a new format. This is a great time-saver, if you frequently have to convert old files. The quick tip is at the end. (Level - Basic)
Filter With Slicers -- In the newer versions of Excel, Slicers are a great tool for filtering pivot tables and named tables. John Michaloudis shows a few ways to filter those Slicers – select one or multiple items. (Level - Basic)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.
A Surplus of Tomatoes
Oops! Last week I called the purple flower a Wisteria, but it's a Clematis. I appreciate hearing from you, if there's ever an error in this newsletter, so I can update the online copy. The link to that is always below my weekly photo.
We'll celebrate Thanksgiving this weekend, here in Canada, so have fun, if you're enjoying this holiday too. There are lots of tomatoes left in my garden, so those might find their way into our holiday dinner or appetizers. At least I think those are tomatoes! ;-)
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: http://www.contextures.com/newsletter/excelnews2015/20151006ctx.html
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.