212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Intermediate-Advanced Excel Class

$0.00

Intermediate-Advanced Excel Class

The advanced Excel Training looks at advanced formulas and functions, formula auditing techniques, data-analysis with pivot tables.

    • 295 $
    • 295 $
    • 295 $
    • 295 $
    • 295 $
    • 295 $
    • 195 $
    • 195 $

Description

Intermediate-Advanced Excel Class

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

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