Info-Stat                                                                 Jim Colville, CPA
  This page is now on Jim Colville's new site.  You can review the files on either site. The files on this page will eventually all be moved to the new site and removed from this page.

This page contains the files from various Excel presentations done by Jim Colville over the last three years.

The files will open in Excel. Click File Save As to save to your PC. If you have trouble with the download, right click on the link and Save Target As, then open the file from your PC.

The files were created or updated in Excel 2000 or 2003.

These files have been completely updated for my October 11, 2006 presentations.

Click here if you attended the Controller's Council presentation.

Click here if you attended the August 31st ISACA presentation.
Financial Statements  8/24/06

Defined Names

Database and Custom Sort  

Copy, Paste Special Values, File Linking  

Data to Link  

YTD Update

Zero Out, GoTo Special

Word Wrap in Excel

Mail Merge in Excel

*** Budget / FS Sample ***  8/28/06

Creating Drop Down List Box  8/27/06

Fixing a Bad Download

Fixing Bad Download, Another Example

*** Excel File Inventory ***  8/31/06

*** Recording All Changes to a Worksheet ***  8/24/06

Listing all Sheets in a File  8/31/06

Hiding and Unhiding Menu Items  8/31/06

Random Numbers  9/30/06

Tracking Due Dates  10/11/06

VLookup  10/11/06

VLookup Advanced, Index Match  10/11/06

Cool ToDo Calender in Excel  8/23/06

Fun and Cool Concepts

Fun and Cool Concepts #2

Fun and Cool Concepts #3

Controlled Groups

Corporation Tax Computation Excel Worksheet

Feel free to contact me if you have any trouble with these files or the links. My contact info is on the handout.

Not all the files have instructions or other obviouse pointers. They may be just data files for education or demo purposes. Other files contain in-depth documentation and instruction.

This site is being set-up to be an ongoing resource of Excel information. Check back from time-to-time to see what's been added.

This page was set up in late September 2005 and significantly upgraded in August 2006 and is being updated continously. Please check back as the example you were looking at may have been substantially upgraded. The red date indicates the update.




See also