Monthly Archives: April 2017
VLOOKUP – Approximate Match
This video shows how to use an approximate match Vlookup to find year groups of pupils based on their date of birth.
Excel Shortcut – Ctrl + Enter
How to keep the active cell in position after an entry and how to replicate data across a range.