ProjectPlanbyColour.xlsm - Draw the Gantt Chart bars and the Dates and duration of each task are calculated automatically (VBA macros).
Project Plan Gantt.xlsx - Enter the project task dates and a Gantt Chart will be drawn automatically, requires the Analysis ToolPak Add-in (File tab ➞ Options ➞ Add-Ins ➞ Manage Excel Add-ins/Go).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.xlsx - 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.xlsx - Spot fradulent transactions in data, simple example of Benford's Law
RideShare.xlsx - Car pool scheduling, members who don’t ride every day are still treated fairly, Algorithm: Fagin / Williams 1983 [x].
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)
Calendar.xltm - Month on each Worksheet - Excel Calendar.
Calendar.xlsx - Year on one Worksheet - Jan-Dec.
CalendarFY.xlsx - Year on one Worksheet - April-March.
Calendar.dotm - Word Calendar (VBA macros.)
Some of the files above include VBA macros - you may have to allow these to run under Macro Security settings.
Related
Word - How to automate MS Word in PowerShell using a COM object.
Disable Office Telemetry in the registry - Registry Edits.
Command-line switches for Microsoft Office - 365 / 2019 / 2016.
Q823372 - Word Documents slow to open (affects multiple versions of Word).
Templates.office.com
EuSpRIG European Spreadsheet Risks Interest Group
Calendar Tools from Slipstick.com
Excel Function Bible - Ron de Bruin (2016)
Excel Functions.xls - Peter Noneley's list of Excel functions (2007).
ExcelJet and Excel-Easy - Tutorials.
Firefox tips