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
- 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