MS-Office

Certificate Course in MS-Office

Duration: 2 months
Software: Microsoft Office 2019

COMPUTER BASICS

Introduction To Computing
  • Hardware & Peripheral Devices
  • Introduction To Personal Computer
  • System Software
  • Application Software
  • Software Evolution
  • Operating Systems
Introduction To GUI (Graphic User Interface)
  • Basic Customization With The Control Panel
  • Printers & Printing With Operating System
  • Using Fonts Effectively
  • Multimedia In Operating System
  • Object Properties & The Right Click
  • Working With The File System
  • Sharing Data Between Application
  • Simple Word Processing
  • Painting Pictures
  • Using Other Accessories
  • Using The System Tools
  • Using Compression Utilities
  • Introduction To Secondary Storage Devices (Zip Drives, Cd Writers)
MICROSOFT WORD
  • What Is MS Word And Its Various Applications
  • Creating A New Document
  • Working With Page Setup
  • Saving Files, Opening Files
  • Closing Files And Exiting
  • Formatting- Bold, Underline, Italics, Fonts,
  • Alignment, Font Color
  • Cut-copy-paste, Undo, Redo, Select All
  • Format Painter, Find And Replace Commands
  • Working With Bullets, Numbers & Multilevel Lists
  • Paragraph Formatting – Alignment, Indentation
  • Spacing, Borders & Shading
  • Header & Footer Options
  • Background, Change Case, Drop Cap
  • Auto Format, Style Gallery, Templates
  • Table Operations
  • Inserting Table In A Document
  • Converting Text To Tables And Vice Versa
  • Page Layout- Inserting Page Breaks
  • Inserting Date, Pictures, Etc.
  • Working With Tabs
  • Auto Text Facility Of Word
  • Hyperlink Options
  • Protecting Documents
  • Autocorrect Mail Merge Facility In Word
  • Using Merge With Envelopes & Mailing Labels
  • Creating & Running A Macro
MICROSOFT EXCEL
  • What Is A Spreadsheet?
  • Worksheet Organization
  • Using Toolbars Working With Multiple Sheets
  • Moving, Inserting & Renaming Sheets
  • Inserting & Deleting Cells, Rows, Columns & Sheets
  • Sum, Avg., Max, Min, Round, If Condition, Etc.
  • Using Auto Format Cell Borders, Background Colors & Patterns
  • Referencing Cells Of Other Sheets In Formula
  • Protecting Worksheets
  • Split & Freeze Panes Options, Fill Option: Series, Dates, Etc.
  • Working With Charts, Selecting Different Types Of Charts
  • Data Sorting, Validation, Conditional Formatting
  • Auto Filter Option, Advanced Filter
  • Macros In Excel, Subtotaling Option
  • Use Of Goal Seek Command, Creating Scenarios
  • Using Solver, Using Pivot Tables To Arrange Data
MICROSOFT POWER POINT
  • Page Setup Using Readymade Templates
  • Basic Steps For Planning A Presentation
  • Creating A Simple Slide, Moving From Slide To Slide
  • Editing Presentation, Using Formatting Commands On Slides
  • Changing The Slide Designs – Inserting Slide Number, Picture, Object
  • Working With Slide Masters, Inserting Word Art And Clipart Objects
  • Adding A Graph Or Chart, Rearranging Using The Slide Sorter View
  • INTERNET BASICS

    What is Internet?
    • History
    • Communication
    • Software/ Hardware/ Network Etc.
    • Getting Connected
    • WWW ( World Wide Web )
    • FTP , IRC , Web News , Etc.
    • E- Mail , Chat
    • Search Engines
    • Utility Sites, Services, Education, Info, Jobs, Etc.
    • Internet Telephony
    • Introduction To Advanced Internet Technology
    JOB OPPORTUNITIES

    Data Entry Operator, Back Office, Administration, Receptionist

    Features of the course


    Advance Lab

    Excellent Trainers

    Reasonable Fees

    Apply Now