Excel Advanced

These courses are designed to develop the learner’s skills with spreadsheet software and give them the tools necessary to produce professional spreadsheets.

Excel Advanced - 6 hour course

● 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