Business Modelling using EXCEL

Theme

Key Topics

EXCEL Features & Functions

Range Names, Lookup Functions, Index, Match, Text Functions, Date and Time Functions, Net Present value, Internal rate of return, Finance Functions, Circular references, If, Paste Special, Three Dimensional formula, Auditing tool, Data Tables, Sensitivity Analysis, Goal Seek, Scenario Manager, Conditional arithmetic, Offset, Indirect, Conditional Formatting, Sorting, Tables, Form tools (Spinner Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes), Array formulas

Solver

Optimization, Optimal product mix, Workforce scheduling, Transportation Problem, Distribution problem, Capital Budgeting, Financial Planning, Rating, Warehouse location, Penalties, Travelling salesman

Data Operations

Import data to excel, import from internet, Data validation

Statistical usage

Histograms, Outlier Identification, Pivot Tables, Slicers, Data Model, Power pivot, Power view, Sparklines, Database functions, Data Filter, Remove duplicates, Data Consolidation, Subtotals, Linear Regression, Exponential growth, Power curve, Multiple Regression, Dummy variables, Non linearities, One way ANOVA, Two way ANOVA, Randomized blocks

Time Series

Moving Average, Winter’s Method, Ratio to Moving Average, Forecasting during special events

Probability Distributions

Random Variables, Binomial, Hyper-geometric, Negative Binomial, Poisson, Exponential, Normal,Weibull, Beta, Machine Life modelling, Probability Statements from forecasts, Lognormal Random variable for stock prices, Monte carlo simulation

Monte Carlo Simulation

Optimal Bid, Stock Prices, Asset allocation, Gambling, Sporting event probabilities, Resampling, Stock Option pricing, Customer value, Economic Order Quantity Inventory Model,

Others

Queuing Models, Demand curve, Product pricing, Non linear pricing

Faculty Profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared.