Microsoft Office Applications

This certificate provides hands on experience on Microsoft Office Applications such as MS Word, MS Excel, MS Access and MS PowerPoint, completion of the assignments will result in Microsoft Office 365 applications knowledge and skills.



6 Months, 520 hours
20 hours / 4 per day


Total Fee: PKR 30,000

Per Month: PKR 5000

Home >> Academics >> Certificate Courses >> Microsoft Office Applications Certificate

About Microsoft Office Applications Certificate

Microsoft Office Applications or simply MS Office is a course that will train the young professional who are looking for jobs in the office administration sector, or any other professional organization or industries. Knowledge in Office 365 is essential across a multitude of industries. You’ll learn invaluable skills that will benefit you in everyday life and also make your Curriculum Vitae (CV) stand out from the crowd. This course will provide you efficient training in order to increase your knowledge, confidence, skills and employability. It will serve to objectively validate your IT skills and assist you in your advancement in your chosen career such as office administration, office manager, education & training and various jobs. Office 365 is vital software for every industry having a high demand for skilled professionals.


  • Give students an in-depth understanding of why computers are essential components in business, education and society.
  • Introduce the fundamentals of computing devices and reinforce computer vocabulary, particularly with respect to personal use of computer hardware and software, the Internet, networking and mobile computing.
  • Provide hands-on use of Office 365 applications Word, Excel, Access and PowerPoint. Completion of the assignments will result in MS Office applications knowledge and skills.
  • Provide foundational or “computer literacy” curriculum that prepares students for life-long learning of computer concepts and skills. Completion of course fulfills pre-requisite to enroll in other computer science courses required for a certificate.

Who should join Microsoft Office Applications Certificate?

Young and keen-sighted individuals having a passion to establish proficiency in one or more types of Microsoft Office Suite: Word, Excel, PowerPoint, Access, and Outlook. Designed Cater to the needs of everyone, from beginners to professionals MOA (Microsoft Office Application) certification equips the user with the technical ability to command the full features and functionality of Microsoft Office and prepare them for future academic or workforce opportunities. There are no specific prerequisites that you require in order, to begin with, the MOA certification.

Skills You Will Learn From Microsoft Office Applications Certificate

  • Windows Operating system & systems software, applications software
  • Office 365 Installation
  • Word processing using MS Office
  • Making Spreadsheets using MS excel
  • Configuring Microsoft Outlook for email composition and management.
  • Using Microsoft Access for basic database creation & management.
  • Creating presentation using Microsoft PowerPoint

Tasks You Can Perform (Competencies) On the Completion of Certificate

  • Install Office 365 with its various tools
  • Use Microsoft Word to create letters, papers and reports in a professional manner.
  • Use Microsoft Excel to manage data and present it visually using graphs, charts, etc
  • Use Microsoft Access integrate scripting with object oriented concepts
  • Work on latest scripting language frameworks to enhances capability of web sites

Total Course Duration (6 Months)

Weekly Class Hours

20 hours/4 per day

Total Contact Hours

520 hours


30% Theory, 70% Practical

Career Prospects

  • Data Entry Operators
  • Administrative Assistants
  • Office Manager
  • Office Clerks
  • Project Officers
  • Data Management Officer
  • Secretaries
  • Data Analyst
  • Inventory Control Officer

Skills Oriented Learning Modules

(5 weeks)

  • 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

(7 weeks)

  • 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
  • (7 weeks)

    • 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 Office 365 program

    (7 weeks)

    • Structuring Databases
    • Create Access databases
    • Create and modify tables
    • Define and modify field types
    • Modify field properties
    • Create and modify one-to-many relationships
    • Create and modify queries
    • Create forms
    • Add and modify form controls and properties
    • Create reports
    • Add and modify report control properties
    • Entering Data
    • Enter, edit and delete records
    • Find and move among records
    • Import data to Access
    • Create and modify calculated fields and aggregate functions
    • Modify form layout
    • Modify report layout and page setup
    • Export data from Access
    • Back up a database
    • Compact and repair databases


    Engr. Shahzad Ahmad Malik


    January 25, 2022@ 06:16 AM