Business Analytics Reporting with Microsoft Excel

Course Duration

8 hours, 1-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Description

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
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

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

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph