Pivot Table Demo Workbook
Category: | [Item URL]
- Description: Would you like to explore the wonderful world of Excel pivot tables, but you don't have a good set of data to play around with? If so, here's one for you. This workbook contains a nice set of data, very well suited for a pivot table. I even made two pivot tables, and you can make more. The data is my Amazon.com affiliate income for 2009. I downloaded their report, and imported it into Excel. Requires Excel 2007 or later.
- Has Macros? No
- Download: amazon_referrals_2009.xlsx
King James Bible
Category: General Files | [Item URL]
- Description: Version 2, for Excel 2007 and later. Not to be confused with the Excel Bible, by yours truly. This is the King James Bible in an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell. Features: a hyperlink table of contents,summary formulas to calculate key stats for each book, a word count feature, a random verse generator, and a spiffy new Ribbon interface. If you use a version before Excel 2007, here's the old version.
- Has Macros? Yes
- Download: king-james-bible.xlsm
Light Box Demo
Category: Developer Files | [Item URL]
- Description: You've seen Web sites that "go dim" when a window is displayed on top of the page. This is known as a light box effect. This file contains VBA code that demonstrates how to get a similar effect in Excel. It displays a UserForm or a Message Box while Excel's window is darkened.
- Has Macros? Yes
- More Information: Click here
- Download: xllightbox.xls
Word Clock
Category: General Files | [Item URL]
- Description: Based on a screen saver by Simon Heys. It displays the current date and time in words, updated every second. Completely useless, but you might find it interesting. For Excel 2007 and later.
- Has Macros? Yes
- Download: word clock.xlsm
Generate Meeting Bingo Cards
Category: General Files | [Item URL]
- Description: Generate meeting bingo cards to liven up boring meetings. Contains 186 buzzwords, randomly arranged in a 5x5 grid. Or, customize this file for other types of bingo games (such as political speeches).
- Has Macros? No
- Download: meetingbingo.xls
Day Calculations
Category: | [Item URL]
- Description: A workbook that contains formulas to perform calculation such as the "first Tuesday in October", the "second Sunday in August", and "the last Friday in July."
- Has Macros? No
- More Information: Click here
- Download: datecalculation.xls
Workbook Taskbar Add-In
Category: Add-Ins | [Item URL]
- Description: This add-in displays a toolbar that makes it easy to switch among all active workbooks. It is compatible with Excel 97 through Excel 2003. Note that this add-in may not work properly with other files that use event procedures.
- Has Macros? Yes
- Download: taskbar.xla
Functions To Quantify Color Contrast
Category: General Files / Developer Files | [Item URL]
- Description: This workbook contains VBA functions that can help you select legible colors for cell background and text.
- Has Macros? Yes
- More Information: Click here
- Download: color-difference.xls
Excel 2007 Function List
Category: General Files | [Item URL]
- Description: An Excel 2007 workbook that contains a list of all worksheet functions, in a table. Each function has a brief description and a hyperlink to its help topic at Microsoft's site. This file was accidentally omitted on the CD-ROM that accompanies my Excel 2007 Formulas book.
- Has Macros? No
- Download: worksheet functions.xlsx
Speech Control Ribbon Enhancement
Category: Add-Ins | [Item URL]
- Description: Install this add-in, and you'll have a new group on the Review tab of the ribbon: Text to Speech. Use these controls to read the contents of cells.
This add-in does not work with versions prior to Excel 2007.
- Has Macros? Yes
- More Information: Click here
- Download: speechcommands.xlam
[Next page]
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
All Downloads
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: