Microsoft Office Templates

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 - 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]. - 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. - 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
Spreadsheet page - Excel Tips
Excel Functions - Peter Noneley's list of Excel functions.

Copyright © 1999-2019
Some rights reserved