Ms-Office

Microsoft Office is a family of client software, server software, and services developed by Microsoft.

About the Course
Ms-Office

Microsoft Office is a collection of office-related applications. Each application serves a unique purpose and offers a specific service to its users.It mainly consists of Word, Excel, PowerPoint, Access, OneNote, Outlook and Publisher applications.

Duration: 30 Days

Know More

Requirements

Basic computer knowledge

What you’ll learn in Ms-Office?

MS WORD BASICS: 

Introduction to MS Office and its components, 

Introduction to MSWord

Features & area of  Use. Working with MS Word

Menus & Commands;

Toolbars & Buttons;

Shortcut Menus, 

Wizards & Templates

Creating a New Document; saving document, saving as different Format,

Different Page Views and layouts; applying various Text Enhancements;

Working with ‐ Styles, Text Attributes; Paragraph and Page Formatting‐ Using page

Border and watermark, Text Editing using various features;

Bullets, Numbering, Auto Formatting, word count, various page view options, 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 section breaks and page breaks, Working with Columns, Tabs & Indent‐s; Creation

& Working with Tables including conversion to and from text;

Margins & Space Management in Document;

Adding References ‐ footnotes, endnotes, and Table of

Contents, Insert drawing, Mail Merge, Envelops & Mailing Labels, protect and secure

Documents in MS Word, Working in different languages in MS Word.

Using Unicode in MS Word, Insert WordArt and other objects like shapes, clipart, charts and Smart Arts,

Symbol in Document. Using Macros in Word‐ Record, edit and run macros.

MS EXCEL:

Introduction and area of use; Working with MS Excel.

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; Zooming, Column Freezing, Labels, Hiding,

Splitting etc.

using different features with Data and Text; Use of Formulas, Calculations

using various type of Functions‐Logical, string, date & time, math’s and other types; Cell

Formatting including Borders & Shading; conditional formatting, sorting data items,

Working with Different Chart Types;

Printing of Workbook & Worksheets with various

options.

Import and export excel sheets to/from various format, add headers and

footers, using macros in excel sheet‐ Record, edit and run 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,

Insert WordArt and other objects like shapes, clipart, charts and Smart Arts, symbol in

PowerPoint,

Designing & Presentation of a Slide Show; Master slide, Adding custom

Animation and effects in your presentation, Add time to your slide,

Slide Sorting, Printing Presentations, Notes, Handouts with print options, Package your

presentation for CD.