Connected successfully Syllabus || SNS Courseware
Subject Details
Dept     : MBA
Sem      : 3
Regul    : 23
Faculty : Ms. S.Keerthana
phone  : 7339335532
E-mail  : keerthana.s.mba@snsct.org
73
Page views
11
Files
3
Videos
3
R.Links

Icon
Syllabus

UNIT
1
INTRODUCTION TO SPREADSHEET

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

UNIT
2
ELEMENTARY MODELLING

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

UNIT
3
VBA MACROS PROGRAMMING

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

UNIT
4
ADVANCED DATA ANALYSIS AND FORECASTING TECHNIQUES

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

UNIT
5
SIMULATION AND OPTIMIZATION

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

Reference Book:

Alexander, M. (2015). Excel Macros for Dummies (2nd ed.). Hoboken, NJ: Wiley. Jelen, B., & Syrstad, T. (2018). Excel 2019 VBA and Macros. Indianapolis, IN: Que Publishing. Bullen, S., Bovey, R., & Green, J. (2010). Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (2nd ed.). Boston, MA: Addison-Wesley Professional. Cumming, G. (2012). Understanding The New Statistics: Effect Sizes, Confidence Intervals, and Meta-Analysis. New York, NY: Routledge. Albright, S. C., & Winston, W. L. (2015). Business Analytics: Data Analysis & Decision Making (5th ed.). Stamford, CT: Cengage Learning.

Text Book:

Walkenbach, J. (2015). Excel 2016 Bible. Indianapolis, IN: Wiley. Winston, W. L. (2019). Microsoft Excel 2019 Data Analysis and Business Modeling. Redmond, WA: Microsoft Press.