Details
Who is it for?
Want to bring data in from another table or file automatically? Excel Lookup functions are a great way to do just that and If you need to add more control to what users can enter then data validation is a must! You should have a basic understanding of what a function is.
What will I learn?
How to use data validation to restrict data entries and how to use the lookup functions in Excel.
How will it help me?
Reduce data entry errors which can cause problems with aggregation and summarising data. Qualify or expand data from different data sets based on matching values and create data groups.