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.