Microsoft Office Templates

Word and Excel templates:

Project Plan Gantt - Simple project planning in Excel with an automatic Gantt Chart, just requires the Analysis ToolPak Add-in to be turned on (under Tools-Add Ins)

Calendar.xls - Perpetual Excel Calendar

Calendar.dot - Word Calendar (contains 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

Charts.zip - Excel Charting - add new rows of data and the chart will automatically update.

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)

Some of the files above include VBA macros - to run these either save to your TEMPLATES folder or set Macro Security to Medium.

Related

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 - Microsoft.com
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 Slipstick.com
Spreadsheet page - Excel Tips
Excel Functions - Peter Noneley's list of Excel functions
Q222101 - Office object model


© Copyright SS64.com 1999-2014
Some rights reserved