Sinet ISO Logo            Sinet Education Logo

Microsoft Office

Master the most popular office automation software in the world


Microsoft Advance Excel, Word, PowerPoint and Windows Applications

Course Duration:

Class room training:

  60 hours / One Month

Online training: 25 hours

Fee Details:

Course Fee: ₹ 4000

Sinet Education Course Offers

  FREE Internet Course

  FREE English Type Writing Course

  FREE Utility Tools Course

  FREE Placement Registration

* Conditions Apply.



  Sinet Certification
      ISO 9001 2015 logo embossed
      with Online reference.
      Cost: Free

      Show Model


  Office Works
  Spread Sheet Manager
  Computer Assistant
  Data Entry Operator

Sinet Microsoft Office Course Contents

1. Basics of Personal Computer

Computer Fundamentals, Microsoft Windows Operating System, Desktop Concepts, Accessories, Note Pad, Calculator, Creation, Rename, cut, copy, delete operations of Folder & Files.

2. English Typewriting

Understanding Keyboard typing pattern, Practice Typing using the Typing Master Application.

Microsoft Word Course Contents

3. Text Basics & Text Formatting and saving file in Microsoft Word

Typing the text Formatting text, Alignment of text, Editing Text: Cut, Copy, Paste, Select All, Clear, Find & Replace, New, Open, Close, Save, Save As, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Change the Text Case, Line spacing, Paragraph spacing, Shading text and paragraph, Working with Tabs and Indents.

4. How to create Tables in Word

Working with Tables, Table Formatting, Table Styles, Alignment option, Merge and split option.

5. Working with Microsoft Word Objects

Shapes, Clipart and Picture, Word Art, Smart Art, Columns and Orderings - To Add Columns to a Document, Change the Order of Objects.

6. Working with Objects & Header and Footer

Inserting Text boxes, Inserting Word art, Inserting symbols, Inserting Chart, Inserting custom Header and Footer, Inserting objects in the header and footer, Add section break to a document, Working with bullets and numbered lists.

7. Styles and Content in Microsoft Word

Using Built-in Styles, Modifying Styles, Creating Styles, Creating a list style, Table of contents and references, Adding internal references, Adding a Footnote, Adding Endnote.

8. Merging Documents in Microsoft Word

Typing new address list, Importing address list from Excel file, Write and insert field, Merging with outlook contact, Preview Result, Merging to envelopes, Merging to label, Setting rules for merges, Finish & Merge options.

9. Other Advanced features in MS Word

Changing Word Options, Changing the Proofing Tools, Managing Templates, Restricting Document Access, Using Protected View, Working with Templates, Managing Templates, Understanding building blocks, Check Spelling As You Type, Mark Grammar Errors As You Type, Setting AutoCorrect Options, Page Setup, Setting margins, Print Preview, Print.

Microsoft Excel Course Contents

10. Introduction and Formatting excel workbook

Introduction to Excel interface, Understanding rows and columns, Naming Cells, Working with excel workbook and sheets, New, Open, Close, Save, Save As, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline, Wrap text, Merge and Centre, Currency, Accounting and other formats, Modifying Columns, Rows & Cells.

11. Perform Calculations with Microsoft Excel Functions -1

Creating simple formulas, Setting up your own formula, Date and Time Functions, Financial Function,

12. Perform Calculations Microsoft Excel Functions -2

Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions.

13. Sort and Filter Data in Microsoft Excel

Sort and filtering data, Using number filter, Text filter, Custom filtering, Removing filters from columns, Conditional formatting

14. Microsoft Excel Charts to Present Data Visually and Effectively

Inserting Column, Pie chart etc, Create an effective chart with Chart Tool Design, Format, and Layout options, Adding chart title , Changing layouts, Chart styles, Editing chart data range, Editing data series, Changing chart

15. Analyse Data Using PivotTables and PivotCharts

Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create.

16. PivotChart from PivotTable.

Inserting slicer, Creating Calculated fields.

17. Protecting and Sharing the workbook in Microsoft Excel

Protecting a workbook with a password, Allow user to edit ranges, Track changes, Working with Comments, Insert Excel Objects and Charts in Word Document and PowerPoint Presentation.

18. Other features in Microsoft Excel

Creating and Recording Macros, Assigning Macros to the work sheets, Saving Macro enabled workbook, Page setup, Setting print area, Print titles Inserting custom Header and Footer, Inserting objects in the header and footer, Page Setup, Setting margins, Print Preview, Print, Enable back ground error checking, Setting AutoCorrect Options.

19. Advanced Excel Functions

Two-Way Lookup, Using Drop down Lists as Lookup Values, Three-way Lookup, Getting the Last Value from a List, Partial Lookup using Wildcard Characters and VLOOKUP, VLOOKUP Returning an Error despite a Match in Lookup Value, Doing a Case Sensitive Lookup, Using VLOOKUP with Multiple Criteria, Handling Errors while Using the VLOOKUP Function.

Microsoft PowerPoint

20. Setting Up PowerPoint Environment

New, Open, Close, Save, Save As, Typing the text, Alignment of text, Formatting Text: Font Size, Font Style, Font Color, Use the Bold, Italic, and Underline Cut, Copy, Paste, Select All, Clear text, Find & Replace, Working with Tabs and Indents.

21. Creating slides and applying themes in Microsoft PowerPoint

Inserting new slide, Changing the layout of slides, Duplicating the slides, Copying and pasting slides, Applying themes to the slide layout, Changing theme color, Slide background, Formatting slide background, Using slide views.

22. Working with bullets and numbering in PowerPoint Presentation

Multilevel numbering and Bulleting, Creating List, Page bordering, Page background, Aligning text, Text directions, Columns option.

23. Working with PowerPoint Objects

Shapes, Clipart and Picture, Word Art, Smart Art, Change the Order of Objects, Inserting slide header and footer, Inserting Text boxes, Inserting shapes, using quick styles, Inserting Word art, Inserting symbols, Inserting Chart.

Internet Course

24. The World of Internet

Browser, URL and Links, Websites, Searching

25. e-Mail

e-Mail Concepts, creating e-MailID, sending emails and attachments, spam emails, CC, BCC, etc.

26. Youtube & Social Media

Safe Use of Youtube, Social media Basics.

* Each Session include:
Faculty training, Lab Practice, Lab Exercises and Portal based assignments.
* Sinet Education reserved the right to alter the course contents, offers, price, certificates etc.