Excel Weekly News from Contextures Jan 28, 2014
Pivot table filters + more Excel tips
In this week's Excel news, you'll see how to apply multiple filters on a pivot field, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Multiple Selection Drop Down With Codes
There is a sample file on my website that has VBA code for selecting multiple items from a data validation drop down list. You can insert all the selected items into the active cell, or down the adjacent column, or across a row.
I've updated the file to insert matching codes into the adjacent cell. So, if you select three products, their codes would appear in the cell to the right.
Click here to see the details, and watch the video: Multiple Selection Drop Down With Codes
Apply Multiple Filters on a Pivot Field
By default, a pivot table is set up to allow only one filter per field -- Label, Value or Manual. However, if you want to use more than one filter per field, you can change one of the Pivot Table options.
Click here to see the details: Apply Multiple Filters on a Pivot Field
Calculate Survey Scores with Option Buttons
Set up a survey forms, with option buttons to select an answer. For scoring, use the default value of each button, or build a lookup table with your own scores. The sample file has a macro that sets up the survey, similar to last week's macro for check boxes.
Click here to see the details: Calculate Survey Scores with Option Buttons
Excel Dashboard Reminder
Just a reminder that registration for Mynda Treacy's Excel Dashboard Course closes on January 30th.
I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of my time-saving Contextures Excel Tools add-in. Just enter the Referral Code – DebraD – in the box just below the Buy Now button.
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Jon Peltier shows how users can select specific data to display in an interactive chart.
- Is your Excel file big and slow? Jeff Weir suggests a couple of ways to fix things.
- Using option buttons, Oscar Cronquist shows how to highlight groups of data in a bar chart.
- John Gagnon uses calculated fields to show marketing results in a pivot table
- And finally, for a humorous peek at what other people are saying about Excel, read the weekly collection of Excel tweets, on my Excel Theatre blog.
Video: Show a Warning Message Before Printing
Laste week, we saw how to show a warning message in your Excel workbook by using a macro. This video explains how to automatically show a message, before a sheet is printed..
Shells on Shells
Some days the beach is smooth, with only a few odd shells or bits of seaweed. The day that I took this picture, thousands of tiny shells had washed up onto the beach, with a few larger ones perched on top.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.