Snippets
Excel – Create an Auto Incrementing Reference Number
A simple way to add reference numbers that automatically increment as new entries are added into a table.
Handy Hints
Calculating Working Days in Excel
A quick summary of how to use Excel functions to work out the number of working days available across a period of time.
Blog
Adding More Functionality To Forms
Part two in our overview of Microsoft Power Automate and how it can be used to create electronic processes using Forms. In this post, we add approvals to the process and additional communication elements.
Blog
Using Power Automate To Extend Microsoft Forms
A quick overview of how to use Power Automate to put data from a Microsoft Form into Excel
Blog
Accessibility for Office Documents
A quick overview of how to make your Office documents more accessible using simple built-in tools.
Training
Excel Lookup Functions Made Simple(ish)
A quick run through of the Excel lookup functions and how they are developing in Microsoft 365.
Training
Microsoft Excel Tables – Creating Maintainable Spreadsheets
A quick look at using Excel Tables and names to make a spreadsheet easier to understand and less prone to basic errors.