SCHEDULES


Sep 2, 2017 9:00 am 18:00 pm
REGISTER NOW

MICROSOFT

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

  • Text Functions – Left, Right, Mid
  • Lookup and Reference Functions – Vlookup, Choose, Index, Match, Offset
  • Logical Functions – If, Nested Ifs, And, Or
  • Named Ranges
  • What-if Analysis Tools  - Goal Seek, Data Table, Scenario Manager
  • Conditional Formats

Module IV : Dashboard Report

  • Pivot Tables and Charts
  • Slicers and Sparklines
  • Form Controls
  • Dashboard-making Rules
  • Dashboard Report