Course Description:
The (MS)Microsoft Officeis a suite of software applications designed for productivity and office tasks, including document creation, spreadsheet analysis, presentation creation, and more. It’s a widely used software suite known for its comprehensive features and is essential for many professionals in various fields.
Key Features of Course Divine:
Career Opportunities After MS Microsoft Office:
Essentials Skills You will Develop MS Microsoft Office:
Tools Covered:
Syllabus:
Module 1: Introduction to Microsoft Office & File Management Overview of Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Access) Office 365 vs. Desktop Versions File management: creating, saving, opening, and organizing files Using OneDrive and cloud storage.
Module 2: Microsoft Word – Basics to Intermediate Interface, ribbons, and navigation Creating and editing documents Formatting text, paragraphs, and pages
Using styles, themes, and templates Inserting tables, images, charts, and symbols
Proofing tools: spelling, grammar, thesaurus Page layout and printing options.
Module 3: Microsoft Word – Advanced Features Mail merge (letters, envelopes, labels) Track changes and collaboration tools Table of contents, footnotes, citations, and bibliographies Creating forms and using content controls Working with macros and document protection.
Module 4: Microsoft Excel – Basics to Intermediate Spreadsheet fundamentals: rows, columns, cells Data entry, formatting, and basic formulas Functions: SUM, AVERAGE, COUNT, IF Sorting, filtering, and conditional formatting Charts and graphs (line, pie, bar, combo) Using templates and themes.
Module 5: Microsoft Excel – Advanced Features Advanced formulas: VLOOKUP, HLOOKUP, INDEX/MATCH, IFERROR PivotTables and PivotCharts Data validation and drop-down lists What-If Analysis tools (Goal Seek, Scenario Manager) Recording and running macros Protecting worksheets and workbooks.
Module 6: Microsoft PowerPoint – Basics to Advanced Creating presentations and using themes Slide layouts, transitions, and animations Inserting multimedia (audio, video, charts, etc.) Master slides and custom templates Presenter view and rehearsal tools Exporting presentations as PDF/video.
Module 7: Microsoft Outlook – Email & Communication Setting up and managing accounts Composing, sending, and organizing emails Using folders, flags, and categories Managing contacts, calendars, and tasks Meeting requests and scheduling Using rules and automatic replies.
Module 8: Microsoft Access – Introduction to Databases Understanding relational databases Creating tables, fields, and relationships Designing queries, forms, and reports Importing/exporting data Simple SQL concepts.
Module 9: Office 365 Tools & Collaboration Overview of Office 365 apps (Teams, Planner, Forms, OneNote) Sharing and co-authoring documents in real-time Using Microsoft Teams for communication and meetings Creating surveys and quizzes with Microsoft Forms Notes management with OneNote.
Module 10: Project, Exam Preparation & Certification Hands-on project using Word, Excel, PowerPoint Real-world business scenario applications Practice exams for MOS certification Tips for test-taking strategies Final assessment and feedback.
Industry Projects:
Who is this program for?
How To Apply:
Mobile: 9100348679
Email: coursedivine@gmail.com
You cannot copy content of this page
