MS Office Templates

XL Diary 2004.zip - Track appointments for multiple people or resources in Excel.
This simple spreadsheet can be shared allowing a team of people to all make changes at the same time.
Unlike most calendar apps, you can view several people or resources on the same page.

Also the same thing for 2005 Diary.xls

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 preferred address. (VBA macros)

Calendar.dot - Simple calendar with a VBA macro to set the 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]

Toolbar.doc - MS Word Toolbar - options to quickly add (and remove) formatting.

Procedures.dot - Need numbered paragraphs - this makes it simple.

Apportionment.xls - Budget Allocation - Although mostly known to accountants, this technique can be useful anywhere you need to parcel out unequal resources, e.g. disk quotas.

Benfords Law.xls - Simple example of Benford's Law

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

BatchCommands.xls - Build command strings using spreadsheet functions.

Sums.xls - Named Ranges and Converting units.

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

QuestionnaireForm.xls - Excel Forms and formatting examples including questionnaire design.

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 in Office 2000/XP either save to your TEMPLATES folder or set Macro Security to Medium.

MS Office Websites

Calendar Tools from Slipstick.com
MSofficeMag.net - MS Office
John Walkenbach - Excel
Excel Functions - Peter Noneley's website listing every Excel function.
MVPS - The MS Access Web
MVPS - Word FAQ
MVPS - Powerpoint tips
AntiWord - Cross-platform MS Word reader.

Newsgroups - Word | Excel | Access | Powerpoint

Books

Microsoft Office XP Resource Kit by Microsoft Corp
Deploy, support, and optimize MS Office XP.

VBA Developer's Handbook, by Ken Getz, Mike Gilbert
MS Office automation (VBA, OLE and ActiveX).

Books in association with Amazon.com