Practical Course: Advanced Excel

• 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