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

Excel Expert Dashboards

Sale!

$295.00

Excel Expert Dashboards

Learn to combine 8-15 functions with ActiveX controls to produce dynamic reports and charts.

    • $
    • $

Description

Excel Expert Dashboards

Course Topics

Functions

Features

And Calendar Control
Cells.Address Charts
CountA Chart Forecast
Day Charts – Dynamic
Eomonth Checkbox Controls
GetPivotData Conditional Formatting
If Data Validation
IfError Image controls
Index Match As SumIfs Criteria Macros
Index Match Match Named Ranges
Indirect Option Button Controls
IsBlank Scenarios
Match Spinner Controls
Month Tables
Not
Offset
Offset with Array Formulas
SumIfs/CountIfs/AverageIfs – One Criteria
SumIfs/CountIfs/AverageIfs – Two Criteria
SumIfs/CountIfs/AverageIfs – Three Criteria
SumIfs With Index Match
Year