Search Contextures Sites
Excel Weekly News from Contextures Feb 12, 2013
Date picker tool, pivot table Index, and other tips, in this week's Excel news from Contextures.
- Debra firstname.lastname@example.org
Date Picker Tool
To make it easy to insert dates in a workbook, you can use this free Date Picker tool, created by Jim Cone.
Select a date in the calendar popup, then click Insert, to add it to the worksheet. You can even add a one month or one year calendar to a worksheet, just by clicking a button.
To see the details, and to download the date picker file, click here: Free Date Picker Tool
New ISFORMULA Function in Excel 2013
Last week we saw the new FORMULATEXT function, and this week we'll take a look at ISFORMULA -- another one of the new functions in Excel 2013.
You can use ISFORMULA for auditing or troubleshooting a worksheet. For example, use ISFORMULA with conditional formatting, to highlight the cells that contain formulas.
To see the details, click here: ISFORMULA Function
Compare Values With Index
In a pivot table, you can show the values summarized by SUM, COUNT, and several other functions. You can also add custom calculations, such as a Running Total.
One of the least used custom calculations is Index, which gives you a picture of each value's importance in its row and column context.
The Index custom calculation gives you an interesting view of your data, and is slightly different from the % of Grand Total view.
Click here, to read the details: Show Value Weight With Pivot Table Index
Will You Buy a Surface Pro?
On his blog, VisiCalc creator, Dan Bricklin, looks at the new Surface Pro tablet from Microsoft, and wonders if Excel might be the reason that people will buy it. When VisiCalc was released for the Apple II in 1979, it prompted thousands of people to buy an Apple II, just so they could use the amazing new spreadsheet program. VisiCalc is recognized as the first "killer application".
The Surface Pro, starting at $899 US, is expensive, but it runs Windows 8, and you can install Excel on it, not just programs that are "Excel compatible".
Is that enough of a reason for you to buy one? The Surface Pro is beyond my budget for now, because I got a new laptop, a couple of months ago. I'll have to save my pennies for a while, before I can start shopping again!
To see Dan's article, click here: Surface Killer App
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 ©2018
All rights reserved.