Course Details

Excel is one of the most widely used tool in corporates across sectors and across functions

Excel has become an integral part of everyday operations, making it a necessity for continuous flow of business

Proper understanding of an Analytical tool like Excel helps in better Conceptualization of Business Problems and provide better solutions to companies

Excel saves a lot of time, cost and energy


Why?

  • Dynamic Formulas 
  • Learn Data Analytics & Data Visualization
  • Create Business Dashboard
  • Business Simulation
  • VBA Coding for Automation
  • Shortcut Techniques
  • Examples from Finance, Marketing, Operations & HR
  • 20+ hours of learning
  • Lifetime access to online course
  • Completion Certificate


Course Brochure for more details - 01. Business Analytics - Advanced Excel.pdf

Course curriculum

  • 1

    Basic & Advanced Excel Tools

    • Download Practice File

    • 1. Overview of Excel

    • 2. Cell Referencing

    • 3. Excel Formatting & Shortcuts

    • 4. Paste Special

    • 5. Data Sort

    • 6. Data Filter

    • 7. Advanced Data Filters

    • 8. Conditional Formatting

    • 9. Go To Special

    • 10. Printing & Protection
  • 2

    Basic & Advanced Formulas

    • 11. Basic Formulas

    • 12. Logical - IF

    • 13. Logical - IF AND OR

    • 14. Logical - NESTEDIF

    • 15. Statistical Formulas

    • 16. Date & Text Formulas

    • 17. Financial Formulas

    • 18. Lookup Formulas

    • 19. Dynamic Lookups

    • 20. Advanced Conditional Formatting
  • 3

    Visualization Charts & Pivot Tables

    • 21. Charts

    • 22. Advanced Charts

    • 23. Pivot Tables
  • 4

    Business Simulations & Management Dashboards

    • 24. What If Analysis - Goal Seek & Data Table

    • 25. Scenario Manager

    • 26. Solver (Excel Add-in)

    • 27. Management Dashboards
  • 5

    Automation - Macros & VBA

    • 28. Macros - Basics & Recording

    • 29. VBA Coding - Basics

    • 30. VBA Coding - Advanced

    • 31. VBA User Defined Function

    • 32. VBA - Creating a User Interface

  • 6

    Case Study & Assessment

    • Case Study for Practice

    • Case Study Solution

    • Assessment