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
Excel Chart Utility Giveaway
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
Scroll Through Report Filter Items
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
Show Temperature in Excel Color Scale
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
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- One of the early spreadsheet programs was Trapeze, and Andrew Wulf talks about developing it, and other programs, in his blog post: How I Did Agile Long Before It Was A Thing
- On Microsoft's MVP blog, Ben Currier shows examples of using the new functions in Excel 2013.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- On his PeltierTech blog, Jon Peltier shares explains how to create custom axis labels and gridlines in an Excel chart.
- If you're an avid golfer, Dick Kusleika shows how to average your best 4 out of 5 golf scores.
Video: Excel TextBox Auto Resize and Word Wrap
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
Excel Dashboard Course Recommendation
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.
Swimming in Formation
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.
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 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.