The objective of the course is to make students efficient in performing, managing

document related work using MS Office.

Office Packages: Introduction to office packages: Word Processing Spreadsheet,

Presentation, Database. Comparison of various office suites like MS-Office, Open-

Office , Libre Office etc.

MS Word Basics: Introduction to MS Office, Introduction to MS Word, Features &

area of use. Working with MS Word, Menus & Commands, Toolbars & Buttons,

Shortcut Menus, Wizards & Templates, Creating a New Document, Different Page

Views and layouts, Applying various Text Enhancements, Working with -Styles, Text

Attributes, Paragraph and Page Formatting, Text Editing using various features ;

Bullets, Numbering, Auto formatting, Printing & various print options

Advanced Features of MS-Word: Spell Check, Thesaurus, Find & Replace;

Headers & Footers, Inserting – Page Numbers, Pictures, Files, Auto texts, Symbols

etc., Working with Columns, Tabs & Indents, Creation & Working with Tables

including conversion to and from text, Margins & Space management in Document,

Adding References and Graphics, Mail Merge, Envelops & Mailing Labels.

Importing and exporting to and from various formats.

MS Excel: Introduction and area of use, Working with MS Excel, Toolbars,

Menus and Keyboard Shortcuts, concepts of Workbook & Worksheets, Using

Wizards, Various Data Types, Using different features with Data, Cell and Texts,

Inserting, Removing & Resizing of Columns & Rows, Working with Data &

Ranges, Different Views of Worksheets, Column Freezing, Labels, Hiding,

Splitting etc., Using different features with Data and Text, Cell Formatting

including Borders & Shading.

Advanced Features of MS Excel: Multiple Worksheets: Concept, Creating and Using

Multiple Worksheets; Use of Formulas, Calculations & Functions, Various types of

Functions, Cell Referencing, Absolute and Relative Addressing, Working with

Different Chart Types, Chart Wizard, Printing of Workbook & Worksheets with

various options, Database: Creation, Sorting, Query and Filtering a Database; Creating

and Using Macros

MS PowerPoint: Introduction & area of use, Working with MS PowerPoint, Creating

a New Presentation, Working with Presentation, Using Wizards; Slides & its different

views, Inserting, Deleting and Copying of Slides; Working with Notes, Handouts,

Columns & Lists, Adding Graphics, Sounds and Movies to a Slide; Working with

PowerPoint Objects, Designing & Presentation of a Slide Show, Printing

Presentations, Notes, Handouts with print options.

1. Exercise on Ms-Word .

2. Exercise on Ms-Excel .

3. Exercise on Ms-Power Point .

1. Ms Office Complete BPB Publication.

2. Ms Office Professional 2013 Plain & Simple By Katherine Murray, Microsoft

Press .

3. Ms Office Professional 2013 Step By Step. By Beth Melton & Mark Dodge,

Microsoft Press.

4. Ms Office 2010 By Ramesh Bangia.