Bachelor of Management Studies (B.M.S.) Advance Excel for Manager Data Analysis Syllabus - Mumbai University
This is the FY BMS syllabus under NEP 2020, in force from the academic year 2024-25, examined under form 2225161. The University still sets the earlier Choice Based papers alongside it — forms 2M00155 and 2M00156, whose documents are below — so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Advance Excel for Manager Data Analysis
Module I: Data Analysis through Charts & Graphs
- Shapes, SmartArt, Creating charts and graphs.
- Creating PivotTables, manipulating Pivot Table, changing calculated value fields, PivotTable Styles
- Grouping, sorting and filtering Pivot Tables, Working with Pivot Charts, use of sliders
Module II: Data Analysis through Excel, Security & Printing
- What If Analysis
- Using Solver, Linear Programing problem, Transportation Problem, scheduling, Investment Decisions, XLMiner, statistical analysis through XL-Miner
- Securing & Protecting Spreadsheets
- Proofing and Printing
Reference Books
- Information Technology for Management, 6TH ED (With CD ) By Efraim Turban, Dorothy Le idner, Ephraim Mclean, James Wetherbe (Ch1, Ch2)
- Microsoft Office Professional 2013 Step by Step By Beth Melton, Mark Dodge, Echo Swinford, Andrew Couch
- Tata McGraw Hill Joseph, P.T. : E-commerce An Indian Perspective (Ch-13,Ch-14)
- Electronic Commerce - Technologies & Applications. Bharat,Bhaskar Scheme of Assessments for courses of 4 credits (100 Marks)
Reproduced from the University of Mumbai syllabus for Bachelor of Management Studies (B.M.S.) 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.