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.
Training
Posts relating to training, hints and tips
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
More On Excel Tables
In an earlier post I looked at why we might want to use names in Excel, especially with Tables to ease readability and remove sources of error. In this post I will look at another use for tables, creating dynamic data validation lists and also look at some other Table Read more…
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.
Training
Page Numbering in Microsoft Word
A quick guide on how to get the right page numbering for more complex Microsoft Word documents.
Blog
Advanced Google Searches
A handy gude to getting the answers you need from the worlds biggest search engine.
Blog
Getting Started with Microsoft Teams
Microsoft Teams is a really powerful tool that has blossomed during the Covid-19 lockdown period, allowing many colleagues who are isolated in their own homes to keep in touch and collaborate with one another remotely. The product is very feature rich (and getting ever more so) so can be a Read more…