Tony Gwynn’s Hit Database
Category: General Files | [Item URL]
- Description: An Excel database table with information about Tony Gwynn's first 3,000 hits. It's a good practice file for learning pivot tables to summarize the data in various ways. (Tony Gwynn was a baseball player for the San Diego Padres.)
- Has Macros? No
- Download: gwynn2.xls
Gantt Chart Demo
Category: General Files | [Item URL]
- Description: Demonstrates how to create a "time line" (Gantt) chart in Excel. This type of chart is often use to depict various tasks in a project.
- Has Macros? No
- Download: gantt.xls
Keno For Excel
Category: General Files | [Item URL]
- Description: Of all the popular gambling games, none has worse odds than Keno. If you don't believe it, try your hand at this Excel implementation.
- Has Macros? Yes
- Download: keno.xls
Employee Time Sheet
Category: General Files | [Item URL]
- Description: This workbook makes it easy for an employee to track his or her daily work hours. The employee simply enter the times, and the formulas calculate the hours. It even tracks overtime hours on a weekly basis (set up as 40 hours, but easily modified).
- Has Macros? Yes
- Download: time sheet.xls
Analog Clock Chart
Category: General Files / Developer Files | [Item URL]
- Description: This workbook contains an XY chart that displays a working analog clock. It uses VBA to update the clock every second. This is really not a practical application. Rather, it's an interesting charting demonstration that uses VBA. The VBA project is not protected, so you can view the code.
- Has Macros? Yes
- Download: clockchart.xls
Dice Roller
Category: General Files / Developer Files | [Item URL]
- Description: This workbook simulates rolling two dice. It keeps track of the results, and plots the distribution in a chart (along with the expected distribution). This may be useful in an elementary probability/statistics course -- or, some of the VBA techniques may be of value (the VB Project is not protected).
- Has Macros? Yes
- Download: diceroller.xls
An Animated Hypocycloid Chart
Category: General Files / Developer Files | [Item URL]
- Description: This workbook displays an infinite number of dazzling animated charts, similar may remind you of Hasbro's popular Spirograph toy.
- Has Macros? Yes
- More Information: Click here
- Download: hypocycloid - animated.xls
Climate Data Workbook
Category: General Files / Developer Files | [Item URL]
- Description: A highly interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.
- Has Macros? No
- More Information: Click here
- Download: climate_data.xls
[Previous 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: