DataPig Freeware

Helping you survive the dirty world of data analysis

Home About | Excel Tutorials | Access Tutorials | Freeware | Add to Favorites

FTP

To contact me about the freeware listed here, use this email address, replacing the word "at" with the @ symbol.

mike at datapigtechnologies.com

Excel Freeware

Excel Explosion 3.0 See Tutorial see install instructions

This Utility will split your Excel dataset into separate Excel workbooks or separate tabs based on criteria you define! So you can create a separate workbook for each Employee in your dataset or each City, or State...etc. All this with one click! (For MS Excel 97,2000,2002,2003)

New for Excel 2007!
DataPig Custom Button Builder for Excel 2007 See Tutorial

This utility allows you to add your own custom tabs and buttons to the Excel 2007 Ribbon without dealing with XML or complicated RibbonX code. You simply fill out a table and select your output method. With this utility, even an intermediate Excel user can create custom user interfaces that tie back to existing macros.

Source code is free for all to see and build upon. (For MS Excel 2007)

Access Freeware

File Manager 4.0 Updated to work with Office 2007!

- Search for and Index all files on your system!
- Create a centralized spreadsheet listing all files with hyperlinks to those files!
(For MS Access 2002,2003, 2007)

Access Tools 4.0 Updated to work with Office 2007!

- Perform compact and repair on all your Access .mdb and .accdb files at once!
- Create an index of all Tables and Fields in every Access database on your system!
- Create an index of all Queries in every Access database on your system!
(For MS Access 2002,2003, 2007)

DataPig Access Explosion See Tutorial
This Utility will split your Access datasets into separate Access Tables, Excel workbooks or separate Excel tabs based on criteria you define! So you can create a separate workbook for each Employee in your dataset or each City, or State...etc. All this with one click!

DataPig Instant TreeView See Tutorial

Ever wanted to add a Treeview to your application, but didn't know how? DataPig Instant Treeview does all the work! Just point to your hierarchy table and a custom Treeview is created instantly. Best of all, you can incorporate this form into any one of your applications!

DataPig Google-Eye

A utility that allows you perform advanced Google searches through an Access form! Search for a topic, search for a definition, get weather info, get stock quotes, and search for movie reviews. This is an excellent tutorial on making use of the Web Browser Active X control.

DataPig ROI/ROE Calculator

Basic Return on Investment/Return on Equity calculator that makes use of Access Slider Controls in order to allow for "what if analysis"

MORE TO COME...