Business Analytics Reporting with Microsoft Excel

Course Duration

8 hours, 1-day training workshop


Face to face training or online training

Course Inclusive

Training materials & certificate of completion


This course combines the concept of Business Analysis and the functionality of MS Excel to better interpret reports.

Course Content

Module I: Overview of Business Analytics

Module II: Purpose of Business Analysis

Module III: MS Excel Functions For Business Analytics
  1. Text Functions – Left, Right, Mid
  2. Lookup and Reference Functions – Vlookup, Choose, Index, Match, Offset
  3. Logical Functions – If, Nested Ifs, And, Or
  4. Named Ranges
  5. What-if Analysis Tools  - Goal Seek, Data Table, Scenario Manager
  6. Conditional Formats
Module IV: Dashboard Report
  1. Pivot Tables and Charts
  2. Slicers and Sparklines
  3. Form Controls
  4. Dashboard-making Rules
  5. Dashboard Report
    • MAKATI
    • 4th Flr. 1191 Pablo Ocampo Sr. Extension, Brgy. Sta. Cruz, Makati City, Philippines

    • Contact No.
    • 8247-5011 local 71250

    • Email Address
    • [email protected]

    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • 8247-5011 local 31100

    • Email Address
    • [email protected]