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
● Macros
● PivotTables
● Scenario Manager
● Goal Seek
● Advanced Functions