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. 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.
         19. 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. 
         20. Working with bullets and numbering in PowerPoint Presentation 
       Multilevel numbering and Bulleting, 
        Creating List, 
        Page bordering, 
        Page background, 
        Aligning text, 
        Text directions, 
        Columns option. 
         21. 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 
 
      
         22. The World of Internet 
       Browser, URL and Links, Websites, Searching 
         23. e-Mail  
       e-Mail Concepts, creating e-MailID, sending emails and attachments, spam emails, CC, BCC, etc.
      
         24. 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.