B.Com. (Banking and Insurance) Application of MS Excel in Business Syllabus - Mumbai University
This is the FY BBI 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, Inserting, Deleting, 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 Application of IT: For Business Administration, Finance, and Commerce" by Ramesh Bangia (Publisher: Taxmann Publications Pvt. Ltd.)
- "Excel for Business Professionals" by Gini Courter and Annette Marquis (Publisher: Wiley India Pvt. Ltd.)
- "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)
Reproduced from the University of Mumbai syllabus for B.Com. (Banking & Insurance) 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.