Search Contextures Sites
Excel Weekly News from Contextures Sept 25, 2012Save time with a pivot table add-in, create an in-cell chart for stock prices, Excel 2013 articles, and other tips, in this week's Excel news from Contextures.
PivotPower Premium Excel Add-in
Every time you build a new pivot table, you have to change its settings, so it works the way you need it to. There's no built-in way to store your preferred default settings, to make that job easier.
I got tired to changing those settings for every new pivot table, and I've created a premium version of my PivotPower add-in, with more features. You can store your pivot table default settings in the add-in, and then apply those settings to any pivot table, and the active sheet and workbook.
There are other time-saving features, such as the Currency SUM command, which changes the values from COUNT, or other summary functions, to SUM, and formats them as Currency.
The PivotPower Premium add-in is $30, and you can read the details here: PivotPower Premium Excel Add-in
The free version of the PivotPower add-in, with fewer features, is still available. You can get the free version here: PivotPower add-in
Excel Dot Plot Chart for Stock Prices
Create an in-cell chart that shows the current stock price, compared to the lowest and highest, over the past 52 week period. Using the REPT function, the formula calculates where the marker should fall in the range, and places a dot for the latest price on a scale that runs from the lowest to the highest price.
Click here to read the instructions and watch the video: Excel Dot Plot Chart for Stock Prices
Calculate Differences in a Pivot Table
Use the built-in custom calculations in pivot tables, to show amounts other than a simple sum or count. For example, use the Difference From calculation, which subtracts one pivot table value from another, and shows the result.
Read the details and watch the video here: Calculate Differences in a Pivot Table
Excel 2013 Articles
Are you eager to update to Excel 2013 when it hits the store shelves? Some of its new features sound great, and the Excel team has been writing about the new version.
I'm collecting links to the Excel 2013 articles, so you can go back and read them again, or find the articles that you missed. The list is on my Contextures website, and I'll be updating it whenever I find new articles: Excel 2013 Information
Listing Printers In VBA
Chip Pearson has a great Excel website, and he has just added some code for getting a list of printers from the system registry. You can use VBA to create a list of printers connected to the PC, and use this list to allow the user to select a printer from your application.
Visit Chip's site to get the sample code: Listing Printers In VBA
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.