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