Description

MS-OFFICE

F.Y.B.Com. (Management Studies) – Semester II

As Per NEP 2020 (w.e.f. the Academic Year 2024-25)

Syllabus

Module 1 :
Unit 1 : MS Word and MS Power Point
(a) MS Word – Menu and Tool Bars, Creating and Saving Document, Editing of Document, Formatting Text, Changing Space Between Paragraphs and Lines, Creation and Modification and Formatting of Tables, Insertion of Symbols, Special Characters, Smart Art, Watermarks, Page Formatting, Headers and Footers, Mail Merge – Concept and Uses.
(b) MS Power Point – Creating Power Point Presentation, Presentation in Different Views, Inserting Images, Audios and Videos, Creation of Animation Effects, Insertion of Designs, Slide Transitions, Slide Printing, Inserting Comments.

Module 2 :
Unit 2 : MS Excel – Basic and Advanced
(a) Basic Excel – Creating, Saving and Editing Spreadsheets, Freezing Panes and Splitting Windows, Drawing Charts, Basic Functions – Text, Math, Trig, Statistical, Date and Time, Financial, Logical.
(b) Advanced Excel – Use of VLOOKUP, HLOOKUP, Data Analysis – Sorting, Filtering (Auto and Advanced Filter), Scenarios, Pivot Tables and Charts.