Word and Excel templates:
Project Plan Gantt - Simple project planning in Excel with an automatic Gantt Chart, requires the Analysis ToolPak Add-in.
Mortgage.xlsx - Calculate a monthly repayment mortgage (capital + interest) compare longer/shorter terms (Years).
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.
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.
RideShare.xlsx - Car pool scheduling, members who don't ride every day are still treated fairly, Algorithm: Fagin / Williams 1983 [x].
Procedure.dot - Number paragraphs like 1.5.1 – 1.5.2 – 1.6.0
Lottery.xls - Excel Lottery Game - Run the macro and watch the numbers spin. (VBA macros)
Calendar.xltm - Month on each Worksheet - Excel Calendar.
Calendar.xlsx - Year on one Worksheet - Jan-Dec.
CalendarFY.xlsx - Year on one Worksheet - April-March.
Calendar.dot - Word Calendar (VBA macros.)
Some of the files above include VBA macros - you may have to allow these to run under Macro Security settings.
Q210565 - Command-line switches for MS Word (2000-2010)
Q291288 - Command-line switches for MS Excel
Q823372 - Word Documents slow to open (missing template)
EuSpRIG European Spreadsheet Risks Interest Group
Office Resource Kit by Microsoft Corp 2010 (free download)
Calendar Tools from Slipstick.com
Spreadsheet page - Excel Tips
Excel Functions - Peter Noneley's list of Excel functions.