J-Walk & Associates, Inc.

Missing File Posted

If you purchased a copy of Excel 2007 Formulas, you might have discovered that the CD-ROM is missing a workbook file that lists and describes all of the worksheet functions. You can download it here: Excel 2007 Function List.

The data is arranged in a table, with the following columns:

• Function Category
• Function Name
• Description
• New?
• Help Topic ID
• Help Link

Click the link in the Help Link column, and your browser opens to the corresponding Help topic at Microsoft's site.

Just for fun, I created a pivot table that counts the functions by category, and applied the Data Bars formatting:

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By Ron de Bruin. Comment posted 22 August, 2008 11:41am

   Hi John
   
   Maybe also add a macro that call the offline help is useful for people that have no internet connection.
   
   Sub Example_Show_2007_Help()
   If Val(Application.Version) = 12 Then
   Application.Assistance.ShowHelp Cells(ActiveCell.Row, "E"), ""
   End If
   End Sub
   
   
   I have more info on this page
   http://www.rondebruin.nl/id.htm
2. By Monkey. Comment posted 19 April, 2011 7:37am

   Walking in the presence of giants here. Cool tihkning all around!