MS Office Templates

Formatting

Word 2002 (XP) Normal Template
The Normal.dot as supplied with Office XP forces the use of popup Task Panes for almost everything, luckily there are ways to make Word XP behave more like Word97
This Normal.dot is suitable for the typical/occasional user.
The Power User Normal.dot includes the Style & Style by Example menu options that are missing from the Microsoft version.

Letter.dot and Fax.dot - This pair of templates demonstrate how to provide a standard letterhead across a large organisation - the Windows registry is used to remember the user's preferred address. (VBA macros)

Procedure.dot - Number paragraphs like 1.5.1 – 1.5.2 – 1.6.0

QuestionnaireForm.xls - Excel Forms and formatting examples.

Dates and Times

XL 2005 Diary.xls - Track appointments for multiple people or resources in Excel. This spreadsheet gives a diary view for several people on one 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 times such as [ 2 1/2 hours]

Others

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 your data, simple example of Benford's Law

Bits and Bytes.xls - Convert figures in Mb to Gb or Tb.

Charts.ZIP - Excel Charting - add new rows of data and the chart will automatically update.

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
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 - list of every Excel function.
AntiWord - Cross-platform MS Word reader.
Newsgroups - Word | Excel | Access | Powerpoint