J-Walk & Associates, Inc.

J-Walk & Associates is a small company owned by me: John Walkenbach. I've been using spreadsheets since the early days of VisiCalc. I've written many Excel books, and I also developed Power Utility Pak, a popular add-in for Microsoft Excel. [more about John]

This site contains information about my books and Excel-related products, plus lots of free tips, downloads, and other stuff for Excel mavens. Explore the menu at the top, and dig around. There's an excellent chance that you'll find something you didn't know.

For the latest information, and the opportunity to comment on recent entries, head straight to The Spreadsheet Page Blog (updated 3 days, 1 hour ago).

My Books & Add-In Products

I've written nearly 50 Excel books for users of all levels.

• Books for Excel 2007
• Books for Excel 2003
• Books for older versions of Excel

PUP is an an Excel add-in that adds dozens of new features and functions to Excel. A free 30-day trial version is available.

• PUP v7 (for Excel 2007 only)
• PUP v6 (for earlier versions)

The J-Walk Enhanced Data Form is a free Excel add-in that provides a general-purpose data entry dialog box. VBA code is available for a small fee.

• Enhanced Data Form v3

What Else Is Here?

• Excel Tips - A variety of useful (and mostly non-trivial) tips to help you get the most out of Excel.
• Free Excel workbooks and add-ins - Some of the files demonstrate useful techniques that you can adapt to your own work. Others are just for fun.
• Excel Help Resources - How to get help, how to use newsgroups, Excel blog links, etc.
• Excel Oddities - Observations on some weird stuff in Excel.
• Excel Expert E-Letter Archives - David Hager's old developer newsletter, preserved for future generations.
• Excel Blog Headlines - Links to the latest content at Excel blogs, including a handy way to add them to your RSS reader.
• Spreadsheet jokes - Need a break?  A few are even funny.

What's New?

The most recent content (excluding blog posts) added to the site. New material is also announced in the Spreadsheet Page Blog, where you can discuss the item and ask questions.

• User-Defined Function Argument Descriptions In Excel 2010 (posted Feb-17 in Excel Tips)
• Pivot Table Demo Workbook (posted Jan-24 in Downloads)
• King James Bible (posted Jan-16 in Downloads)
• Dual Monitors And UserForms (posted Jan-10 in Excel Tips)
• Unlinking A Pivot Table From Its Source Data (posted Nov-29 in Excel Tips)
• Old-Style Menus In Excel 2007 (posted Nov-2 in Excel Tips)
• Light Box Demo (posted Oct-23 in Downloads)
• Text Effects In Text Boxes (posted Oct-6 in Excel Tips)