Services
|
Excel
|
Information
Home
|
Profile
|
Services
|
Excel Solutions
|
Back Office
|
Info Center
|
Seminars & Events
|
Contact
Free Excel Downloads
File
Size
Description
_01_FS Sample and Notes.xls
395 KB
Financial Statements with Notes
_01_Navigation.XLS
7.15 MB
Spreadsheet navigation
_01_Survey.xls
52 KB
Techniques used in Survey calculations
_09_Budget.xls
133.5 KB
Budget Excel Example
_02_Nav_Book.XLS
109.5 KB
Spreadsheet navigation
_02_RangeNames.xls
65.5 KB
Defined (range) names
_03_DATABASE.XLS
112 KB
Database example
_04_Assets.XLS
73 KB
Updating monthly reports
_04_Assets_Adds.XLS
13.5 KB
Updating monthly reports-additions
_05_YTD.XLS
64.5 KB
Year to date monthly update
_06_CustomList.xls
30 KB
Custom Sorts and custom data fill
_06_ZeroOut.xls
90.5 KB
Zero out for new month
_07_EditFillJustify.xls
19 KB
Word wrap in Excel
_07_Gprofit.XLS
16.5 KB
Formula exercise
_08_PROFILE.XLS
371.5 KB
Mail merge concept in Excel
_12_BadDownloads.XLS
515 KB
Working with bad downloads
_13_BadDownLoads2.xls
2.24 MB
Working with bad downloads 2
_15_RecordCellChanges.xls
77 KB
Record a record of all cell changes
_18_CalendarCoolToDo.XLS
97 KB
Cool calendar in Excel
_20_diceroller.xls
181 KB
Great examples of advanced reporting in a game.
_21_StopLightSample.xls
23 KB
Advanced reporting-concepts to build a dashboard
_22_StopLightDashboard.xls
518.5 KB
Advanced reporting - dashboard
_25_File List Inventory.xls
271 KB
Excel to list all files in a directory
_30_Rand.xls
46 KB
Random numbers
_35_Dates-Expiration.xls
80.5 KB
Track upcoming dates
_45_VLOOKUP.XLS
74 KB
Vertical lookup examples
_46_VLOOKUP2.XLS
58 KB
Vertical lookup examples-more
_51_Hide Menus.XLS
69 KB
Macros to Hide or Disable and Unhide or Enable Excel menu items. Very useful file security tool.
020-AD cells.xls
399.5 KB
Fun File-Place your cursor on certain cells and see the surprising results
_80_Macros Intro.xls
64.5 KB
An Intro to writing macros. These are the notes used in Jim's presentations
_90_Excel 2007.xls
37 KB
A list of key changes in Excel 2007
_61_SumIf-DSum.XLS
112.5 KB
Working with =COUNT, COUNTIF, SUMIF and DSUM
_10_ListBox.xls
30.5 KB
No Description
_55_PivotTable.xls
1.23 MB
No Description
_71_Aging.XLS
173.5 KB
No Description
_51_Hide Menus p.XLS
67.5 KB
No Description
Home
|
Profile
|
Services
|
Excel Solutions
|
Back Office
|
Info Center
|
Seminars & Events
|
Contact
© Jim Colville CPA . All Rights Reserved.