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