Training
Excel Lookup Functions Made Simple(ish)
A quick run through of the Excel lookup functions and how they are developing in Microsoft 365.
Blog
General blog posts
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
Handy Hints
Don’t Forget About Bing
It isn’t just Google that has advanced search refining and built in calculator and conversion apps. In this article we cover the similar feature previously referenced for Google search.
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.
Handy Hints
Google As A Calculator
A reminder that Google can also act as a calculator and unit convertor right from the search bar.
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