IT Tools

Microsoft Excel 2010 Advanced

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.

Available Sessions
Course not available for public enrollment at this time.
To schedule for your organization, contact Customized Training