B.Com. (Investment Management) Application of MS Excel in Business Syllabus - Mumbai University 2026
This is the FY BCom IM 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 Application of MS Excel in Business
Module I: Integration of MS Excel in Business
- A) Basics of MS Excel: Managing Worksheets and Workbooks: Labeling and Naming Worksheets and Workbooks, Adding, Deleting and Saving Worksheets and Workbooks, Reposition Worksheets and Renaming Worksheets, Copy Worksheets, printing a Workbook, Formatting a Worksheet, Adding Elements to a Workbook, Protecting Worksheet and Workbook. Inserting and deleting rows and columns. Inserting and deleting cells.
- B) Data Representation using MS Excel: Entering, Editing and Formatting Data, Uses of mathematical, logical and Financial and Date and Time formulas, Import external data, Creating Table, Sorting Data, Data Validation, Consolidation, Creating Pivot table. Charts: Chart elements: Titles, legend, data labels, creating a New Chart, Formatting Chart, Types of charts, Using Chart Templates, Pivot chart.
Module II: Statement Analysis using MS Excel
- A) Preparation of Financial Statements, Preparation of Profit & Loss Account, Balance Sheet, Perform Ratio Analysis and Financial Statement
References
- "Business Applications of Excel" by Subhas Chandra Misra (Publisher: McGraw Hill Education India Pvt. Ltd.)
- "Business Intelligence with Microsoft Excel" by Alberto Ferrari and Marco Russo (Publisher: BPB Publications)
- "Mastering Excel: Power Tools for Business Professionals" by Gaurav Kumar (Publication: Wiley India)
- "Excel for Business Analytics: A Comprehensive Guide" by Ashish Gupta and Nitin Goel (Publication: Pearson)
Reproduced from the University of Mumbai syllabus for B.Com. (Investment Management) 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.