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.
- Topics Include:
- Logical and statistical functions
- Financial and date functions
- Lookups and data tables
- Advanced data management
- Exporting and importing
- Analytical tools
- Macros and custom functions
Prerequisites:
Microsoft Excel 2010 Essentials
or equivalent experience.
Microsoft Excel 2010 Intermediate
or equivalent experience.
login 
Cart 
