Microsoft Excel | Advanced
Basic functions and features of Excel 2016.
- advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX.
- about data validation and database functions such as DSUM
- how to work with PivotTables and Pivot Charts
- to import and export data
Prerequisites: MS Excel Intermediate workshop or equivalent experience.