Search Contextures Sites


Newsletter Index


Get weekly Excel tips from Debra




30 Excel Functions in 30 Days




Contextures News

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

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

Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.



Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.