IT & Cybersecurity

Build on the skills and concepts taught in Excel: Intermediate. Develop expertise using advanced formulas and lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and database functions such as DSUM and working with PivotTables and PivotCharts, data import/export, and external database queries. Discover analytical features such as Goal Seek and Solver, running and recording macros, and sharing Excel data via the Web.