Curriculum
- 1 Section
- 21 Lessons
- 204 Weeks
Expand all sectionsCollapse all sections
- Excel Interactive Dashboards with Formulas & ChatGPT21
- 2.01. Introduction1 Minute
- 2.1Course Materials
- 2.22. Overview9 Minutes
- 2.33. Vlookup, Match, Index21 Minutes
- 2.44. Row, Rows, Column, Columns8 Minutes
- 2.55. Sumif, Sumifs, Countifs. ifs18 Minutes
- 2.66. If, Nested if, and, or25 Minutes
- 2.77. Sumproduct9 Minutes
- 2.88. Offset21 Minutes
- 2.99. Form Controls- Scroll Bar & Spin Button16 Minutes
- 2.1010. Check Box3 Minutes
- 2.1111. Option Button & Combo Box14 Minutes
- 2.1212. Custom Bar Chart19 Minutes
- 2.1313. Custom Column Chart9 Minutes
- 2.1414. Progress Chart17 Minutes
- 2.1515. Target Line Chart7 Minutes
- 2.1616. Date Range Chart24 Minutes
- 2.1717. Dashboard (Pivot)51 Minutes
- 2.1818. Dashboard (KPI) part-135 Minutes
- 2.1919. Dashboard (KPI) part-240 Minutes
- 2.2020. ChatGPT Guideline3 Minutes