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
Accessibility for Office Documents
A quick overview of how to make your Office documents more accessible using simple built-in tools.
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…