Excel Weekly News from Contextures July 30, 2013
Scroll through pivot filter + more Excel tips
In this week's Excel news, you'll see how to scroll through items in a pivot table filter, show the temperature in a color scale, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
The winner of last week's giveaway, for John Walkenbach's book, 101 Excel 2013 Tips, Tricks & Timesavers, was Neil, with comment 22. He has collected his prize, and I'm sure that he'll enjoy it.
This week, you can enter the giveaway for a chance to win Jon Peltier's awesome Excel Chart Utility. With this add-in, you can quickly create custom charts, such as a waterfall or cluster stack chart. It also has 6 charting tools, a data tool, and 3 general tools
Go to my blog post, read the rules, and add your comment, to explain which feature you would use most, and why, to enter the draw for this utility. The deadline is Monday, August 5th, at 12 noon, Eastern time.
Click here to see the details, and to enter the giveaway: Excel Charting Utility Giveaway
Slicers were added in Excel 2010, and they make it easy to select an item from a pivot table filter. If you're using an older version of Excel, or if you don't have room for Slicers, you can use Spin Buttons to quickly scroll through the items in a Report Filter.
Click here to see the details, and to download the sample file: Scroll Through Report Filter Items
With Excel's conditional formatting, you can use a color scale to highlight the current temperature in shades from red to blue. We usually select a block of cells for this technique, but in this example, one of the cells is off on its own, and the rest of the cells are hidden. You can try this in Excel 2007, and later versions.
Click here to see the details, and to watch the video: Show Temperature in Excel Color Scale
Here are a few more Excel articles that I read this week, that you might find useful:
Textbox formatting was improved in Excel 2010. With its new features, you can now set the textbox to resize automatically, if you add text, and you can turn on word wrap too. Watch this short video to see the steps.
To download the sample file, please visit my Contextures website: Excel TextBox AutoSize
For a limited time, Mynda Treacy from My Online training Hub is opening her Excel Dashboard course, and if you sign up by 8 pm Pacific time tomorrow, July 31st, you can get the course for 20% off.
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.
The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues.
Click here to find out find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.
Remember, if you sign up by July 31st, you can get the dashboard course for 20% off.
You might have seen Canada geese flying in their V-shaped formation, heading south for the winter. We were at the park on Sunday, and saw this gaggle of geese swimming in an orderly line. It looked like a water parade! I'm not too fond of these big birds, and the mess that they make, but they did look majestic, swimming along the river.
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.
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.