Ideal for those with a good knowledge of Excel, who are responsible for the analysis and manipulation of data to automate spreadsheets.
- Using date and time functions
- Linking data across spreadsheets
- Sorting and filtering data
- Writing Logical Functions
- Lookup tables
- Introduction to Pivot Tables
Increased productivity using functions to automate calculations be able to structure data allowing easy analysis, to reduce manual data entry and errors from everyday tasks.