Word and Excel templates:
Project Plan Gantt - Simple project planning in Excel with an automatic Gantt Chart, just requires the Analysis ToolPak Add-in to be turned on (under Tools-Add Ins)
Calendar.xls - Perpetual Excel Calendar
Calendar.dot - Word Calendar (contains VBA macros.)
Shifts.xls - Work out shift patterns for groups of staff.
This demonstrates the use of fractions to display part of an hour e.g. 4 1/2 hours.Apportionment.xls - Budget Allocation - Although mostly known to accountants, this technique can be useful anywhere you need to parcel out new resources in proportion to the existing allocation, e.g. disk quotas.
Microsoft Access Form References - Refer to Forms, sub-forms and controls in SQL and VBA.
Benfords Law.xls - Spot fradulent transactions in data, simple example of Benford's Law
Charts.zip - Excel Charting - add new rows of data and the chart will automatically update.
Procedure.dot - Number paragraphs like 1.5.1 – 1.5.2 – 1.6.0
QuestionnaireForm.xls - Excel Forms and formatting examples.
UK Company Car Tax Calculator.xls - Updated July 2005 - UK CO2 Tax.
Lottery.xls - Excel Lottery Game - Run the macro and watch the numbers spin. (VBA macros)
Some of the files above include VBA macros - to run these either save to your TEMPLATES folder or set Macro Security to Medium.
Related
Q283686 - Office
Setup.exe switches
Q210565 - Command-line switches for MS Word
Q291288 - Command-line switches for MS Excel
Q209207 - Command-line switches for MS Access
Q830040 - Command-line switches for MS powerpoint
Q823372 - Word Documents slow to open
Remove
Hidden Office Data - Microsoft.com
Office 2003
Resource Kit by Microsoft Corp
Office 2007 Resource Kit by Microsoft Corp (free download)
Calendar Tools from
Slipstick.com
Spreadsheet page - Excel Tips
Excel Functions - Peter Noneley's list
of Excel functions
Q222101 - Office object model
Newsgroups - Word | Excel | Access | Powerpoint
