Advanced Excel Training

Sale!

$279.00

Advanced Excel Training

The advanced Excel class looks at advanced formulas and functions, formula auditing techniques, data-analysis like pivot tables and forecasting, database features, and an advanced macro lesson that touches upon VBA programming.

    • $
    • $
    • $

Description

Advanced Excel Training

Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/Then, Index/Match, arrays, formula auditing techniques, what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration features.

Advanced Excel Training Objectives:

  • Review Formulas, Function, Absolute References
  • Advanced Excel Formulas: Named Ranges, Vlookup, Index, Match, If, SumIf, IsError, Text Functions, Formula Auditing
  • Advanced Data Analysis:What-If Analysis with Pivot Tables
  • Database Features: Validation, Advanced Filters, Import Excel Data and Export Excel data
  • Automate Excel with Macros