Training
Excel Lookup Functions Made Simple(ish)
A quick run through of the Excel lookup functions and how they are developing in Microsoft 365.
A quick run through of the Excel lookup functions and how they are developing in Microsoft 365.
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…
A handy gude to getting the answers you need from the worlds biggest search engine.