Sale!
$395.00 $295.00
Excel Expert Dashboards
Learn to combine 8-15 functions with ActiveX controls to produce dynamic reports and charts.
SKU: Excel Expert Dashboards
Categories: Excel, Microsoft
Tags: advanced microsoft excel course, dashboards, excel class, excel course, excel training, learn excel
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 | ||