Search Contextures Sites
Custom Search


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

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 -

Summer Schedule

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.

Excel Articles

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 Announcements

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



Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2015
All rights reserved.