Search Contextures Sites
Excel Weekly News from Contextures Sept 11, 2012Troubleshoot a worksheet, select functions from a drop down list, create colour coded maps, and other tips, in this week's Excel news from Contextures.
Change Functions With Excel Drop Down ListSelect a function name from a drop down list, to change the formulas in a worksheet summary.
For example, choose COUNT, to see the number of orders and then choose SUM, to see the total amount in the lists of orders
Visit my Contextures blog for a video, and a link to the written instructions and sample file: Change Functions With Excel Drop Down List
Format Excel Worksheet for TroubleshootingUse colour codes to identify cell contents for #Excel troubleshooting. Where are the formulas? Which cells contain constants?
Visit my Contextures blog for a video, and written instructions: Format Excel Worksheet for Troubleshooting
Clear All Fields From a Pivot TableOccasionally, you might want to tear down a pivot table, and rebuild it. You don't have to delete the pivot table though - you can clear all the fields, and then start adding the ones you want.
In the latest post on my Pivot Tables blog, you'll see how to clear a pivot table manually, or with programming.
Visit my Excel Pivot Tables blog for the sample code, and written instructions: Clear All Fields From a Pivot Table
Charting Overview for Office 2013On Microsoft's Excel blog, they discussed the new charting features that will be included in Excel 2013. One of those new features is Chart Recommendations, which will help you select the best chart type for your data.
Read the details here: Charting Overview for Office 2013
Handicap History ChartOn the Daily Dose of Excel blog, Dick Kusleika shows how he created a chart of his golf handicap from the past five years.
Even if you don't play golf, you'll find some interesting charting tips and techniques in this two-part article.
Handicap History and Handicap History Chart
Colour Map With Conditional FormattingOn his Clearly and Simply blog, Robert Mundigl shares his improved code for coloured shapes in a map. One interesting new feature is the popup comments that appear when you point to the shapes, and those are created with hyperlinks.
Read the details and download his sample file here: Fast Choropleth Map with Enhanced Features
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2019
All rights reserved.