Course Overview
Following on from the intermediate level Microsoft Excel course, this advanced course will continue to develop and expand your skills in using the software. This course will teach more powerful features such as statistics manipulation and some programming topics.
Course content includes:
-Absolute cell references
-Naming/editing cells and ranges
-Setting up entire workbooks with group editing
-Using VLOOKUP/HLOOKUP statements to retrieve data
-Editing lookups and ensuring accuracy in returned data
-IF statements and calculations
-Analysing data with the all new conditional formatting features
-Sorting and filtering data
-Setting up data validation to ensure data integrity
-Attaching security to a spreadsheet
-Selective protection i.e. protecting formulas while allowing data entry
-Setting up and utilising templates
-Creating, formatting and adding trend lines to charts
