Excel Advanced
Who is this course for?
Familiarity with the standard functionality of Excel, or completion of the Excel Extra course
What will I learn?
These courses are designed to develop the learner’s skills with spreadsheet software and give them the tools necessary to produce professional spreadsheets.
- Sorting
- Multiple Column Sorts
- Custom Lists and Sorts
- Printing a Selection
- Displaying & Printing Formulas
- Formulas that Produce Errors
- Data Validation
- Use Drop down list with Vlookups
- Relative and Absolute Referencing
- Mixed Referencing
- Multiple IF Functions
- Lookup Functions
- Nested IF Functions - AND, OR
- Lookup Functions - H, V and X
- Macros
- PivotTables
- Scenario Manager
- Goal Seek
- Advanced Functions
- Excel and AI
Location
Coleg Cambria Yale, Grove Park Road, Wrexham, LL12 7AB
Skills tags:
- data
- spreadsheet
- excel