Purna Tech LMS

MS Office Complete Course

Categories: Office Productivity
Wishlist

About Course

Master the essential Microsoft Office skills required for education, business, administration, data entry, and office-based careers.

The MS Office Complete Course is a practical, job-oriented program designed for beginners. It covers Computer Fundamentals, Windows File Management, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Outlook, cloud collaboration, professional documentation, interview preparation, and real-world office projects.

Students will learn how to create professional documents, work with formulas and functions, manage business data, prepare charts and PivotTables, design effective presentations, write professional emails, organize office files, and complete integrated workplace projects.

What You Will Learn:

• Computer Fundamentals and Windows File Management
• Microsoft Word – Basic to Advanced Document Creation
• Microsoft Excel – Essentials and Intermediate Functions
• Formulas, Logical Functions and Lookup Functions
• Charts, PivotTables and Workplace Reports
• Microsoft PowerPoint Presentation Design
• Animations, Transitions and Presentation Delivery
• Microsoft Outlook and Professional Email Management
• OneDrive, PDF and Office Collaboration Tools
• Resume, Business Letter and Office Documentation
• Practical Office Projects and Interview Preparation
• Final Capstone Project and Assessment

This course includes step-by-step video lessons, practical demonstrations, module quizzes, assignments, workplace projects, interview preparation, and a final assessment.

By the end of the course, learners will be able to use Microsoft Office applications confidently and perform common office, administrative, data-entry, academic, and business tasks professionally.

Show More

Course Content

Module 1: Introduction to Computers and MS Office
This module introduces learners to computer fundamentals, hardware and software concepts, operating systems, file management, and the Microsoft Office ecosystem. Learners will develop the essential computer skills required to use Word, Excel, PowerPoint, and Outlook confidently.

  • Lesson 1: Introduction to Computers
  • Lesson 2: Computer Hardware and Software
  • Lesson 3: Input, Output and Storage Devices
  • Lesson 4: Operating Systems and Windows Basics
  • Lesson 5: Introduction to Microsoft Office

Module 2: Windows and File Management
This module develops essential Windows and file-management skills. Learners will practise creating folders, organizing documents, copying files, searching for information, managing storage devices, and using common keyboard shortcuts.

Module 3: MS Word Fundamentals
This module introduces the Microsoft Word interface and the basic process of creating, editing, saving, and printing documents. Learners will practise text entry and essential document operations.

Module 4: Text and Paragraph Formatting in Word
This module teaches learners how to format text and paragraphs to create clean, readable, and professional documents.

Module 5: Page Layout and Document Design
This module focuses on page setup and document design. Learners will create professionally structured documents using margins, orientation, columns, page breaks, headers, footers, and page numbers.

Module 6: Tables, Pictures and Graphic Elements in Word
This module teaches learners how to enhance Word documents using tables, pictures, shapes, icons, SmartArt, WordArt, and text boxes.

Module 7: Advanced Document Tools in Word
This module introduces productivity and document-management features such as proofing, references, navigation, comments, track changes, document protection, and PDF conversion.

Module 8: Mail Merge and Professional Word Documents
This module teaches learners how to create personalized letters, labels, envelopes, certificates, resumes, and other workplace documents using Mail Merge and templates.

Module 9: MS Excel Fundamentals
This module introduces Microsoft Excel and the basic concepts of workbooks, worksheets, cells, data entry, editing, saving, and worksheet management.

Module 10: Excel Formatting and Data Presentation
This module teaches learners how to format worksheets and present information clearly using number formats, alignment, borders, styles, and printing tools.

Module 11: Excel Formulas and Basic Functions
Topic Summary This module introduces formulas, operators, cell references, and essential mathematical and statistical functions used in everyday office work.

Module 12: Logical and Conditional Functions
This module develops decision-making skills in Excel using logical and conditional functions for results, grades, eligibility, commissions, and business analysis.

Module 13: Text, Date and Time Functions
This module teaches learners how to clean text, combine information, extract characters, and perform practical date and time calculations.

Module 14: Data Management and Analysis in Excel
This module covers essential data-management techniques such as sorting, filtering, validation, duplicate removal, tables, subtotals, and basic data summarization.

Module 15: Lookup Functions and Data Retrieval
This module introduces essential lookup techniques used to retrieve information from student, employee, product, inventory, and sales databases.

Module 16: Charts and PivotTables
This module teaches learners how to summarize data and communicate results through charts, PivotTables, Pivot Charts, slicers, and simple reports.

Module 17: Excel Workplace Projects
This module applies Excel skills to realistic office scenarios such as attendance, payroll, inventory, billing, budgeting, and MIS reporting.

Module 18: Microsoft PowerPoint Fundamentals
This module introduces Microsoft PowerPoint and teaches learners how to create, edit, organize, save, and present slide-based content.

Module 19: PowerPoint Visual Design
This module teaches learners how to create visually attractive presentations using pictures, shapes, icons, SmartArt, tables, charts, and multimedia.

Module 20: Animations, Transitions and Presentation Delivery
This module develops presentation delivery skills through transitions, animations, timings, hyperlinks, interactive navigation, and Slide Show tools.

Module 21: Microsoft Outlook and Email Management
This module teaches learners professional email communication and essential Outlook features such as folders, attachments, signatures, contacts, calendars, and meeting invitations.

Module 22: Office Integration, Cloud and Collaboration
This module shows learners how to combine Word, Excel, PowerPoint, Outlook, PDF, and cloud-storage tools in practical office workflows.

Module 23: Professional Office Documentation Projects
This module provides practical experience in creating commonly required workplace documents and managing them as complete office projects.

Module 24: MS Office Interview Preparation
This module prepares learners for MS Office-related interviews, practical tests, and workplace assessments through frequently asked questions and application-based exercises.

Module 25: Capstone Project and Final Assessment
This final module evaluates the learner’s complete Microsoft Office skills through an integrated workplace project, theory examination, practical examination, and final submission.

Student Ratings & Reviews

No Review Yet
No Review Yet