Success depends on the ability to make the best business decisions. To do that, you must make the most of the numbers available to you.

This course will greatly enhance your ability to collect, analyse and forecast business and financial data to generate valuable insights from business data.

In this course participants will learn:

  • How to turn buckets of data into sound business decisions
  • Financial modeling theory
  • Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  • To use PivotTables, Pivot Charts and Basic Macros
  • How to effectively and clearly present your findings to relevant stakeholders
  • Different forecasting techniques, including Moving Averages and Regression

Topics to be Covered in Workshop 

Section 1: Introduction

  • Turning Numbers into Better Business Decisions

 Section 2: Some Advanced Techniques

  • Functions with Superpowers
  • Array Formulae
  • Tables

Section 3: The Business Analyst's Excel Toolbox

  • Essential Excel for Business Analysis
  • Professional Tools for Business Analysts

Section 4: Collecting and Managing Business Data

  • Importing and Exporting Data
  • Power Functions for Managing Business Data

Section 5: Communicating Your Message

  • Your Stakeholders and Their Needs
  • Data Presentation Formats That Work

Section 6: Winning Charts for Business Communication

  • Professional Charting
  • Dynamic Charts
  • Some Special Charts for Business Analysis

Section 7: Excel Interactivity

  • Form Controls
  • Visual Basic and Macros

Section 8: Looking Inside Your Data (Analysis)

  • Analysing Data with Pivot Tables
  • Managing Pivot Tables Output

Section 9: Turning Data into Decisions

  • Working with External Data
  • Advanced Uses of PivotTables
  • Power Pivot

Section 10: Comparing Business Scenarios

  • Decision Making with Compared Scenarios
  • The Scenario Manager

Section 11: Looking Outside Your Data (Forecasting)

  • Time Series and Forecasting
  • Working with Moving Averages
  • Introduction to Regression

Eligibility: It's a basic level workshop so there are no prerequisites. Any one interested, can join this workshop.

Certification Policy:

  • Certificate of Merit for all the workshop participants.
  •  At the end of this workshop, a small competition will be organized among the participating students and winners will be awarded with a 'Certificate of Excellence'.
  • Certificate of Coordination for the coordinators of the campus workshops

Duration: The duration of this workshop will be two consecutive days, with 6-7 hour session each day in a total of 12-14 hours properly divided into theory and hands on sessions.

Our Clients