Become a Professional Certified
MS Office Course

Learn & Earn with Xperts IT Institute


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

MS Office Three Modules

What Will I Learn?

  1. Formatting Content
  2. Create custom styles for text, tables and lists
  3. Control pagination
  4. Format, position and resize graphics using advanced layout features
  5. Insert and modify objects
  6. Create and modify diagrams and charts using data from other sources
  7. Organizing Content
  8. Sort content in lists and tables
  9. Perform calculations in tables
  10. Modify table formats
  11. Summarize document content using automated tools
  12. Use automated tools for document navigation
  13. Merge letters with other data sources
  14. Merge labels with other data sources
  15. Structure documents using XML
  16. Formatting & Collaborating Documents
  17. Create and modify forms
  18. Create and modify document background
  19. Create and modify document indexes and tables
  20. Insert and modify endnotes, footnotes, captions, and cross-references
  21. Create and manage master documents and subdocuments
  22. Modify track changes options
  23. Publish and edit Web documents
  24. Manage document versions
  25. Protect and restrict forms and documents
  26. Attach digital signatures to documents
  1. Organizing and Analyzing Data
  2. Use subtotals
  3. Define and apply advanced filters
  4. Group and outline data
  5. Use data validation
  6. Create and modify list ranges
  7. Add, show, close, edit, merge and summarize scenarios
  8. Perform data analysis using automated tools
  9. Create PivotTable and PivotChart reports
  10. Use Lookup and Reference functions
  11. Use Database functions
  12. Trace formula precedents, dependents, and errors
  13. Locate invalid data and formulas
  14. Watch and evaluate formulas
  15. Define, modify and use named ranges
  16. Structure workbooks using XML
  17. Formatting Data and Content
  18. Create and modify custom data formats
  19. Use conditional formatting
  20. Format and resize graphics
  21. Format charts and diagrams
  22. Protect cells, worksheets, and workbooks
  23. Apply workbook security settings
  24. Import data into Excel
  25. Export data from Excel
  26. Publish and edit Web worksheets and workbooks
  27. Create and edit templates
  28. Consolidate data
  29. Define and modify workbook properties
  30. Customizing Excel
  31. Customize toolbars and menus
  32. Create, edit, and run macros
  33. Modify Excel default settings
  1. Creating Content
  2. Create new presentations from templates
  3. Insert and edit text-based content
  4. Insert tables, charts and diagrams
  5. Insert pictures, shapes and graphics
  6. Insert objects
  7. Formatting Content
  8. Format text-based content
  9. Format pictures, shapes and graphics
  10. Format slides
  11. Apply animation schemes
  12. Apply slide transitions
  13. Customize slide templates
  14. Track, accept and reject changes in a presentation
  15. Add, edit and delete comments in a presentation
  16. Compare and merge presentations
  17. Managing and Delivering Presentations
  18. Organize a presentation
  19. Set up slide shows for delivery
  20. Rehearse timing
  21. Deliver presentations
  22. Prepare presentations for remote delivery
  23. Save and publish presentations
  24. Print slides, outlines, handouts, and speaker notes
  25. Export a presentation to another Microsoft Office program



Rabia Saboor




4 Weeks




Follow us on