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.

Calendar.xlsx - Jan-Dec Perpetual Excel Calendar (.xls version)

CalendarFY.xlsx - April-March Perpetual Excel Calendar (.xls version) - Word Calendar (VBA macros.)

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

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


Q283686 - Office Setup.exe switches
Q210565 - Command-line switches for MS Word
Q291288 - Command-line switches for MS Excel
Q830040 - Command-line switches for MS powerpoint
Q823372 - Word Documents slow to open
Remove Hidden Office Data -
Office 2010 Engineering Blog
EuSpRIG European Spreadsheet Risks Interest Group
Office Resource Kit by Microsoft Corp 2003 | 2007 | 2010 (free download)
MS Office Professional 2010 by Microsoft Corp (Disc)
Calendar Tools from
Spreadsheet page - Excel Tips
Excel Functions - Peter Noneley's list of Excel functions
Q222101 - Office object model

Copyright © 1999-2017
Some rights reserved