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.
Microsoft Access Form References - Refer to Forms, sub-forms and controls in SQL and VBA.
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.
Q283686 - Office
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
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
Newsgroups - Word | Excel
© Copyright SS64.com 1999-2013
Some rights reserved