· Recap on user interface, environment and shortcuts
· Absolute references
· Naming cells and ranges
· Referring to named cells and ranges in formulae
· Editing named cells and ranges
· Setting up entire workbooks with group editing
· Using lookup statements to retrieve data
· Editing lookups and ensuring accuracy in returned data
· Linking spreadsheets and workbooks together with formulas and functions
· Utilising If statements to assist decision making
· If statements and calculations
· Analysing data with the all new conditional formatting features
· Databases in Excel understanding fields and records
· Sorting data numerically and alphabetically
· Filtering data for range and precision analysis
· Setting up data validation to ensure integrity of the data
· Attaching security to a spreadsheet
· Selective protection i.e.: protecting formulas while allowing data entry
· Setting up and utilising templates
· Creating and formatting charts
· Adding trend lines to the chart
· Utilising custom chart types |
