Overview

SUIT Mardan Ms. Office Training Complete Course for young professional looking for a job in Office administration sector? or working in a professional organization? Knowledge in Microsoft Office is essential across a multitude of industries. You�ll learn invaluable skills that will benefit you in everyday life and also make your CV stand out from the crowd.
MS Office Course will significantly increase your confidence, skills and employability with Microsoft Office. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career such as office administration, office manager, education & training and various jobs as Microsoft Office is vital software for every industry having a high demand for skilled professionals.

Lesson-01 Basic Computing

• Introduction to Computer
• Input and Output Components
• Window Installation
• Utility Programs
• Storage Devices Configration
• Typing
• software and Hardwares Practical tranings

Lesson-02 MS Office

• Ms office Overview
• Ms office Installation

Module-01 Ms Word

Formatting Content
• Create custom styles for text, tables and lists
• Control pagination
• Format, position and resize graphics using advanced layout features
• Insert and modify objects
• Create and modify diagrams and charts using data from other sources
• Organizing Content
• Sort content in lists and tables
• Perform calculations in tables
• Modify table formats
• Summarize document content using automated tools
• Use automated tools for document navigation
• Merge letters with other data sources
• Merge labels with other data sources
• Structure documents using XML
• Formatting & Collaborating Documents
• Create and modify forms
• Create and modify document background
• Create and modify document indexes and tables
• Insert and modify endnotes, footnotes, captions, and cross-references
• Create and manage master documents and subdocuments
• Modify track changes options
• Publish and edit Web documents
• Manage document versions
• Protect and restrict forms and documents
• Attach digital signatures to documents

Module-02 Ms Excel

• Organizing and Analyzing Data
• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• Add, show, close, edit, merge and summarize scenarios
• Perform data analysis using automated tools
• Create PivotTable and PivotChart reports
• Use Lookup and Reference functions
• Use Database functions
• Trace formula precedents, dependents, and errors
• Locate invalid data and formulas
• Watch and evaluate formulas
• Define, modify and use named ranges
• Structure workbooks using XML
• Formatting Data and Content
• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics
• Format charts and diagrams
• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Import data into Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consolidate data
• Define and modify workbook properties
• Customizing Excel
• Customize toolbars and menus
• Create, edit, and run macros
• Modify Excel default settings

Module-03 Ms PowerPoint

• Creating Content
• Create new presentations from templates
• Insert and edit text-based content
• Insert tables, charts and diagrams
• Insert pictures, shapes and graphics
• Insert objects
• Formatting Content
• Format text-based content
• Format pictures, shapes and graphics
• Format slides
• Apply animation schemes
• Apply slide transitions
• Customize slide templates
• Track, accept and reject changes in a presentation
• Add, edit and delete comments in a presentation
• Compare and merge presentations
• Managing and Delivering Presentations
• Organize a presentation
• Set up slide shows for delivery
• Rehearse timing
• Deliver presentations
• Prepare presentations for remote delivery
• Save and publish presentations
• Print slides, outlines, handouts, and speaker notes
• Export a presentation to another Microsoft Office program