Bachelor of Management Studies (B.M.S.) Advance Excel for Manager Theory 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 Theory
Module I: Introduction to MS Excel, Advanced Navigation, Cell Management & Formatting
- The Excel user interface, Working with MS Excel workbook
- Worksheet Management
- Basic Excel terminologies
- Essential navigational controls
- Basic data entry with spreadsheets, cell formatting, borders, etc.
- Protecting Cell & Sheet - importance of Protecting Cell & Sheet
Module II: Hot keys, Advance Functions, Conditional Formatting, Introduction to Macros
- Shortcut Keys
- Basic Functions, Lookup Functions, Logical If Functions, Financial Functions, Statistical Functions Text Functions, etc
- Modifying worksheets with color
- Conditional Formatting and IF Conditions
- Recording macros that involve formatting & calculations
Reference Books
- Information Technology for Management, 6TH ED (With CD ) By Efraim Turban, Dorothy Leidner, 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
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.