Generate A Word Frequency List
Category: General Files / Developer Files | [Item URL]
- Description: A workbook that demonstrates a VBA macro that creates a word frequency list. Put your text in Column A, with no blank cells. The text can consist of sentences, titles, etc. Run the macro, and you get a pivot table that lists every word, and the number of times it's used. The demo file contains three examples: Beatles song titles, the first few paragraphs of Moby Dick, and a George W. Bush speech.
- Has Macros? Yes
- More Information: Click here
- Download: wordfrequency.xls
Display Disk Drive Information
Category: General Files / Developer Files | [Item URL]
- Description: Contains VBA macros that display information about the drives attached to your system. It uses three functions: DriveType, DriveSize, and DriveSpaceFree.
- Has Macros? Yes
- More Information: Click here
- Download: driveinfo.xls
Slide Show Demo
Category: General Files / Developer Files | [Item URL]
- Description: Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.
- Has Macros? Yes
- More Information: Click here
- Download: chart slide show.xls
Yearly Calendar - With Holidays
Category: General Files | [Item URL]
- Description: An enhanced version of this workbook. U.S. holidays are highlighted, using conditional formatting.
- Has Macros? No
- Download: yearly-calendar-with-holidays.xls
J-Walk Chart Tools Add-In
Category: Add-Ins | [Item URL]
- Description: This add-in provides several chart-related utilities:
- Data Labels - Lets you specify a worksheet range for the data labels for a chart series. Amazingly, Excel does not provide this capability!
- Chart Size - Lets you specify an exact size for a chart, or lets you make all charts the same size.
- Export - Lets you save charts as GIF, JPG, TIF, or PNG file.
- Picture - Converts a chart to a picture (color or grayscale)
- Text Size - Freezes the size of all text items in a chart. When the chart is resized, the text elements will not change size.
- Chart Report - Generates a summary report for all charts, or a detailed report for a single chart.
Not compatible with Excel 2007.
- Has Macros? Yes
- Download: charttools.xla
Yearly Calendar Workbook
Category: General Files | [Item URL]
- Description: A worksheet that displays a yearly calendar for any year between 1900 and 2100. Use the slider at the top to select the year. Change the appearance by modifying the named styles.
- Has Macros? No
- Download: yearly-calendar.xls
MP3 File Lister
Category: General Files / Developer Files | [Item URL]
- Description: An Excel application that generates a list of MP3 files. To use it, click the 'Start" button and you will be prompted for a directory. The list includes the directory you choose, plus all nested subdirectories. When the macro finishes, the worksheet will contain a list of MP3 files with the following columns: Path, Filename, Artist, Album, Title, Track, Genre, Duration, and Size. The data can be summarized in a pivot table. This is not the fastest application, so be patient (the status bar displays the current file number).
This workbook requires a reference to Microsoft Shell Controls and Automation (shell32.dll). If it doesn't work for you, check the reference using Tools - References in the VB Editor. The VB Project is not protected, so you can view the code or modify it to suit your needs. - Has Macros? Yes
- Download: mp3filelister.xls
Animated Color Scales
Category: General Files | [Item URL]
- Description: A 62x62 range of cells contain simple formulas that use the SIN and COS functions. Color Scales conditional formatting is applied to the range. Click a button, and the colors change randomly. Click another button, and the image rescales randomly. Click the third button, and it moves. Good clean fun for the entire family.
NOTE: This will not work in versions prior to Excel 2007. - Has Macros? Yes
- Download: animatedcolors.xlsm
The Bible, In Excel
Category: General Files | [Item URL]
- Description: 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. It has a handy hyperlink table of contents so you can jump to any book. I also wrote some summary formulas to calculate the number of characters in each book, and the average number of characters per verse. Then I added a word count feature: Enter a word and it displays the number of occurrences in each book. And finally, a random verse generator. If you use Excel 2007 or later, here's an improved version.
- Has Macros? Yes
- Download: king-james-bible.zip
Smiley Chart
Category: General Files | [Item URL]
- Description: The workbook contains a chart that looks like a smiley face. The amount of smiling (or frowning) is determined by the value of a cell. If the cell contains -1, you see a big frown. If it contains +1, the face smiles. Values in between produce a corresponding expression.
- Has Macros? No
- Download: smilechart.xls
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: