Your Weekly Excel Tips Newsletter
August 4, 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.
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.
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.
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.
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: https://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 ©2018
All rights reserved.