Advanced Excel Class

Sale!

$295.00 $209.00

Advanced Excel Class

Learn advanced Excel topics like nested functions (2, 3, 4 functions in one formula), beginner to advanced PivotTables, macros, data analysis and more.

    • $
    • $
    • $
    • $
    • $
    • $
    • $
    • $
    • $
SKU: ADV-XL-201 Category: Tags: , , ,

Description

Advanced Excel Class

Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/Then, Index/Match, DSum, 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 techniques.

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