B.Com. (Honours with Research) with Specialization in Business Management Data Handling Skills for Business Managers MS Excel Syllabus - Mumbai University
This is the FY BCom BM syllabus under NEP 2020, in force from the academic year 2024-25. The University clubbed this degree with B.Com., B.Com. (Accountancy) and B.Com. (Business Economics) on 25 May 2026 and now awards it as B.Com. (Commerce and Management), with Business Management as the Major: the papers below are the ones its own Board of Studies sets, so your exam form may name the degree differently from your admission letter.
Loading syllabus...
Syllabus for Data handling skills for business Managers MS-Excel
Module I: Introduction to MS-Excel for handling data of Business
- Create and Format Workbooks and Worksheets : Create a workbook, Add a worksheet, copy and move worksheet, search for data within a workbook, navigate to a named cell, range, insert and remove hyperlinks
- Format Worksheets: Data entry, Insert and delete rows and columns, adjust row height and column width, change worksheet tab colour, change workbook themes, insert header and footer, hide and unhide columns and rows, hide and unhide worksheets
Module II: Excel operations with formulas and functions for analyzing data
- Insert Tables and Charts: Create tables, add or remove table rows and colums, sort and filter data, create and format charts, add or modify chart elements, charts layout and styles, Insert shapes and images and smart art
- Perform calculations and Application of Basic functions: Create and reuse formulas, perform basic calculations, Insert and edit functions, Apply basic functions like SUM, MIN, MAX, COUNT, AVERAGE, IF, SUMIF
References
- Excel Quick Start Guide from Beginner to Expert by William Fischer
- Excel 2016 Bible by John Walkenbach
- Excel with Microsoft Excel: Comprehensive and Easy Guide to Learn Advanced
- MS Excel by Naveen Mishra
- Excel 2016 for Dummies by Greg Harvey
- Excel 2016 from Scratch by Peter Kalmstrom
Reproduced from the University of Mumbai syllabus for B.Com. (Business 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.