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
Database and Custom Sort
Copy, Paste Special Values, File Linking
Data to Link
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 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
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 www.jimcolvillecpa.com