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 17 hours, 50 minutes 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 - Weird stuff in Excel
• Excel Expert E-Letter Archives - David Hager's old developer newsletter, preserved for future generations
• 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.

• Extracting An Email Address From Text (posted Aug-27 in Excel Tips)
• Rude Warning Mode (posted Aug-26 in Spreadsheet Jokes)
• Quantifying Color Choices (posted Aug-25 in Excel Tips)
• Functions To Quantify Color Contrast (posted Aug-25 in Downloads)
• Excel 2007 Function List (posted Aug-22 in Downloads)
• Speech Control Ribbon Enhancement (posted Aug-21 in Downloads)
• Add The Speech Controls To The Ribbon (posted Aug-21 in Excel Tips)
• A Macro To Count Word Frequencies (posted Aug-20 in Excel Tips)