06. COUNTIF & COUNTIFS function

Introduction
- 01. Introduction
Logical Function
- 02. IF function
- 03. Nested IF
- 04. AND Function
- 05. OR function
- 06. COUNTIF & COUNTIFS function
- 07. SUMIF & SUMIFS function
- 08. IFERROR function
Data Finding Function
- 09. VLOOKUP
- 10. HLOOKUP
- 11. Index - Match
MS Excel Advance
- 12. Pivot Table
- 13. Slicer
- 14. Data Analysis tool pack
- 15. Goal Seek
- 16. Solver
- 17. Power Query
- 18. Error Handle
Data Visualization
- 19. Pie Chart
- 20. Bar Chart, Column Chart and Histogram
- 21. Combo Chart , Pivot Chart
- 22. Tree map
Dashboard
- 23. Dashboard Making
Keyboard Shortcuts
- 24. Keyboard Shortcuts
Resource Files
- Excel for Professionals: Resource File
- Assessment and Certificate