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.

CalendarFY.xlsx - April-March Perpetual Excel Calendar. - 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.

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)

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