Search Contextures Sites
Your Weekly Excel Tips Newsletter
August 8, 2015
Results from our Excel survey, dashboard tips, and much more, in this week's Excel news.
- Debra - firstname.lastname@example.org
During the summer months I'll publish the newsletter once every two weeks, so you will get the next issue on August 18th.
Excel Version Survey Results
In the last newsletter, I asked for your opinion in a short survey, and thank you for all the responses (133 so far). As expected, most of the respondents use Windows (97%), but results for the other two questions might surprise you.
- Most people are using Excel 2013 (61) or 2010 (53), but 2 people are still in Excel 2003!
- The overall "Like" score was quite high -- 7.9 -- so that's good news. If you spend all day in a program, it helps if you like it.
To see all the details, you can download the workbook from my Contextures website. Go to the Sample Files page, and in the Pivot Tables section, look for PT0041 – Show Survey Results in Pivot Tables.
Show Chart or Data on Dashboard
Instead of putting several charts and data tables on a dashboard, you can add let people choose what they want to see. Add a drop down list of items, along with a linked picture. Then, choose an item in the drop down list, and that items is shown in the linked picture. This saves space on the dashboard, and doesn't require macros.
Here are a couple of Excel articles I read recently, that you might find interesting and useful.
Seating Chart -- If you have to organize table seating for an event, download the Excel Seating file from Oz du Soleil's blog. You can specify which guests don't want to sit at the same table, and who insists on sitting together. This will be a big help if you're planning a family reunion, or wedding, or company party. Excel will help you keep everyone happy. ;-) (Level - Intermediate)
Dashboard Color Scheme -- When you're creating a dashboard, choosing a color scheme can be tricky. You want the dashboard to look good, but you don't want to spend hours playing with different color combinations. To make the task easier, download a copy of Mike Alexander's free Color Scheme Selector workbook. It has 75 combinations set up, and you can add your own. (Level - Intermediate)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog.
- Excel Dashboard Course: Mynda Treacy has opened registration for her acclaimed Excel Dashboard course, and the deadline is this Thursday, August 6th. The course is a great investment, and you can read my review for the highlights, and more information.
- Free Dashboard Webinars: Mynda is also offering two free one-hour webinars -- 1) How to Build Excel Dashboards, and 2) Dashboards with Power Query and Power Pivot. Get the details, and sign up for a date and time that is convenient for you.
The Garden Helper
The weeds were taking over my back garden this month, until my son stopped by for a visit, and cleared them all out. When he was finished, I snapped a photo of the nice, tidy garden. That reminded me of a long ago picture, when he also liked to help me in the garden, but wasn't quite good at pulling weeds!
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/20150804ctx.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 ©2015
All rights reserved.