Mortgage.xlsx Calculate a monthly repayment mortgage (capital + interest) compare longer/shorter terms (Years). Shifts.xlsx 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 an existing allocation. Benfords Law.xlsx Spot fradulent transactions in data, simple example of Benford's Law convertxls.xlsm Excel Macro to bulk-convert multiple .XLS to .XLSX files (Windows only). Convert Word .DOC to .Docx Word Macro to bulk-convert multiple files (Windows only). Diary.xltx An Excel diary/day calendar. Emergency.docx Emergency & Medical ID Card template. Lottery.xlsm Excel Lottery Game - Run the macro and watch the numbers spin. (VBA macros). normal.dotx A minimal Word template with just the basic styles: 'Normal', 'Heading 1-3' and 'Title'.
Use this as a starting point to add your own custom styles such as 'Body Text' etc.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). Procedure.dotx Number paragraphs like 1.5.1 – 1.5.2 – 1.6.0 RideShare.xlsx Car pool scheduling, members who don’t ride every day are still treated fairly, Algorithm: Fagin / Williams 1983 [×].
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.
word.cloud.microsoft
excel.cloud.microsoft
powerpoint.cloud.microsoft
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).
Office-Reset (archive) - Switch between Office 365 and a local installation (By Paul Bowden).
Remove Office license from a Mac - Switch between Office 365 and a local installation.
Microsoft Support and Recovery Assistant - Repair an Office installation (use if a quick repair in the control panel/Apps doesn't work).
Word and Excel Templates from Microsoft.
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
