MS Office Templates

Some Word and Excel templates you may find useful:

Bytes.xls - Quick conversion of MB.. GB, GiB, TB etc

TimePlanner.xls - Track appointments for multiple people or resources in Excel. Small enough to fit on a floppy disk - so plans can be sent around via email. One spreadsheet covers one year - one month per page.

Calendar.dot - Calendar with a macro to fill in the correct dates for any month.

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. As published by PC Mag UK in 1997.

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.

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.

Just for Fun...

Lottery.xls - Excel Lottery Game - Run the macro and watch the numbers spin. (VBA macros)

mcp.doc - Get your MS Certificate - No Exam required!

NightOutCalculator.xls - See the effect that varying levels of alcohol might have on you.

OrgChart.pps - Animated Organisation Chart (you need Powerpoint XP for this one)

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 XP Resource Kit by Microsoft Corp
Calendar Tools from Slipstick.com
MSofficeMag.net - MS Office
John Walkenbach - Excel Tips
Excel Functions - Peter Noneley's list of Excel functions
Q222101 - Office object model
Newsgroups - Word | Excel | Access | Powerpoint