Business Analytics Reporting with Microsoft Excel

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
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines