B.Sc. (Data Science) Excel for Business Syllabus - Mumbai University

This is the FY BSc Data Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Loading syllabus...

Syllabus for Excel for Business

Vocational skill course · Semester 1 · FY BSc Data Science · 2 credits · 50 marks

Module I

1. Financial Modelling: Spreadsheet and a Financial Model, Types and Purposes of Financial Models, Tool Selection, Model Design, Design Issues, The Workbook Anatomy of a Model, Project Planning Your Model, Model Layout Flowcharting, Steps to Building a Model, Information Requests. 2. Using Excel in Financial Modelling: Formulas and Functions in Excel, Handy Excel Shortcuts, Cell Referencing, Named Ranges, Basic Excel Functions, Logical Functions, Nesting Logical Functions. 3. Functions for Financial Modelling: Aggregation & LOOKUP Functions, Nesting Index and Match, OFFSET Function, Regression Analysis, Choose Function, Working with Dates, Financial Project Evaluation Functions, Loan Calculations. 4. Tools for Model Display and Financial Modelling: Basic Formatting, Conditional Formatting, Sparklines, Customising the Display Settings, Form Controls, Hiding Sections, Grouping, Array Formulas, Structured Reference Tables, PivotTables, Macros.

Module II

1. Common Uses of Tools in Financial Modelling: Understanding Nominal and Effective (Real) Rates, Calculating a Cumulative Sum (Running Totals), How to Calculate a Payback Period, Weighted Average Cost of Capital (WACC), Building a Tiering Table, Modelling Depreciation Methods, Break-Even Analysis. 2. Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling: What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods, Advanced Conditional Formatting, Comparing Scenario Methods, Adding Probability to a Data Table. 3. Presenting Model Output: Preparing an Oral Presentation for Model Results, Preparing a Graphic or Written Presentation for Model Results, Chart Types, Working with Charts, Handy Charting Hints, Dynamic Named Ranges, Charting with Two Different Axes and Chart Types, Bubble Charts, Creating a Dynamic Chart, Waterfall Charts. 10 Online References: 1. https://www.w3schools.com/EXCEL/index.php 2. Microsoft Excel Help Centre 3. https://trumpexcel.com/learn-excel/ 11 Reference Books 1. Using Excel for Business and Financial Modelling: A Practical Guide, by Danielle Stein Fairhurst, Wiley, 3 rd Edition, 2019 2. Microsoft Excel Professional 2021 Guide: Complete Excel Reference, by CA Manmeet Singh Mehta, Paperback, 1 st Edition, 2022 3. Microsoft Excel: Advanced Microsoft Excel Data Analysis for Business, by John Slavio, Hardcover, 1st Edition, 2019 4. Excel: Excel for Business, by Francesco Iannello, Createspace, 2016 12 Internal Continuous Semester End Examination: 60% Assessment: 40% 13 Continuous Evaluation Format of Question Paper: External through: Examination (30 Marks)– 1 hr duration Class test of 1 of 15 marks Class test of 2 of 15 marks Average of the two: 15 marks Quizzes/ Presentations/ Assignments: 5 marks Total: 20 marks 14 Format of Question Paper: (Semester End Examination : 30 Marks. Duration:1 hour) Q1: Attempt any two (out of four) from Module 1 (15 marks) Q2: Attempt any two (out of four) from Module 2 (15 marks)

Online References

1 https://www.w3schools.com/EXCEL/index.php
2 Microsoft Excel Help Centre
3 https://trumpexcel.com/learn-excel/
1 Using Excel for Business and Financial Modelling: A Practical Guide, by Danielle Stein Fairhurst, Wiley, 3 rd Edition, 2019
2 Microsoft Excel Professional 2021 Guide: Complete Excel Reference, by CA Manmeet Singh Mehta, Paperback, 1 st Edition, 2022
3 Microsoft Excel: Advanced Microsoft Excel Data Analysis for Business, by John Slavio, Hardcover, 1st Edition, 2019
4 Excel: Excel for Business, by Francesco Iannello, Createspace, 2016

Reproduced from the University of Mumbai syllabus for B.Sc. (Data Science) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF 2024 25 DS SEM I & II NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read

PDF 2023 24 BSc Data Science Sem V & VI Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

PDF 2021 22 BSc Data Science Sem III & IV Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

Report or request