Info-Stat                                                                 Jim Colville, CPA
 
       
   
  This page is now on Jim Colville's new site. JimColvilleCPA.com  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.



 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 

 
 
Top




See also www.jimcolvillecpa.com