Introduction – Importance – Formulae in MS-Excel – Difference Between Worksheet, Workbook and Spreadsheets – Different types of Data in MS Excel – Working across sheets – Formatting Spreadsheets

Excel IF Statement - Nested IF – Count() and Countif() function – Sumif() and Sumifs() functions – Average Functions - Look Up Functions(VLOOKUP Function – HLOOKUP Function) – INDEX and MATCH Functions Charts & Graphs: Basic chart types – Move and resize charts – Change chart styles and types – Modification in chart elements

Creating and Recording a Macro – Excel VBA MsgBox – VBA Variable Declaration - Subroutines and Functions - IF Else Statement in VBA – Excel VBA Case Statement – VBA for Loop in Excel – Excel DO Loops – VBA Range

Pivot Table: Filter Data using Slicers in Multiple Pivot Table – Visualize Aggregate Data using Pivot Table Time Series Forecasting – Regression - Event Impact Analytics Sensitivity Analysis: Goal Seek - Data Table – Scenario Analysis

Monte Carlo Simulation – The Monte Carlo Simulation Formula –Summary Statistics Solver – Linear Programming for Optimization – Intrinsic Value Calculation Models