· Review of Excel fundamentals
· Building 3-dimensional worksheets
· Worksheet templates
· Protection and security
· Grouping worksheets
· Data tables and lookup functions
· Introduction to the ‘If’ function
· Group and outline functions
· Building graphs and using trend lines
· Database features including sorting and filtering data
· Methods to validate data
· Colours based on values (getting Excel to change the formatting characteristics based on the cell contents) |
