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 | ||
