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.)

A couple of the files above include VBA macros - you may have to allow these to run under Macro Security settings.


Command-line switches for Microsoft Office - 365 / 2019 / 2016.
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
Excel Function Bible - Ron de Bruin (2016)
Excel Functions.xls - Peter Noneley's list of Excel functions (2007).
ExcelJet and Excel-Easy - Tutorials.

Copyright © 1999-2019
Some rights reserved