Course Contents

Introduction to computers, Microsoft DOS Prompt, Microsoft Windows, Microsoft Office

Microsoft Word

• Text Formatting
• Insertion of Table, Picture, Shape, Smart Art, Chart and its settings
• Paper setting Background insertion, Paragraph Setting
• Creation of professional Letter
• Mail Merge
• Spelling Grammar Correction, Thesaurus, Word count
• Creation of Resume

Project Work with all tools

Microsoft Excel

• Working with Formulas
  • Basic Formulas (SUM, AVERAGE…. Etc)
  • Conditional Operators (If, Countif, Sumif)
  • D Functions
  • Hlookup,Vlookup Functions
• Text Formatting
  • Conditional Formatting
• Creating Formats (like Invoices)
• Inserting
  • Analyzing data with Pivot Table
  • Working With Chart, Shapes, Hyperlink
• Working with DATA Tools
  • Filtering Records
  • Scenario Manager, Goal Seek, Data table
  • Work with List box & Combo box

Exercise Works  for all tools

Microsoft PowerPoint

• Creation slides
• Changing Layouts
• Applying Designs, Animation, Transitions

Project Work with all tools