1. Practical based on Number Formatting
2. Practical based on Conditional Formatting
3. Create a Marksheet for Result Analysis
4. Practical based on Filter
5. Practical based on Chart with Formatting
6. Practical based on Formula
7. Basic Formulas (SUM, AVERAGE, COUNT, MAX, MEDIAN, MIN)
8. Time Formulas (TODAY, NOW, DATEDIF, YEAR, MONTH, DAY)
9. Logical Formulas (IF, OR, AND)
10. Create a Sheet and Apply Trace Precedent & Trace Dependent
11. Practical based on VLOOKUP
12. Practical based on HLOOKUP
13. Practical based on Data Validation
14. Create a Worksheet and Apply Goal Seek & Subtotal
15. Practical based on Importing Data (Web, Word, etc.)
16. Practical based on Pivot Table
17. Practical based on Workbook References
18. Practical based on Macros
19. Study of Dashboard
20. Create Dashboard in Excel