Course Description
Module 1: Introduction to Microsoft Office 2021
- Overview of Microsoft Office suite and its applications
- Understanding the new features in Office 2021
- Navigating the Ribbon and Quick Access Toolbar
- File management and cloud integration with OneDrive
Module 2: Microsoft Word 2021 – Word Processing & Document Design
✅ Basic Features:
- Creating, opening, and saving documents
- Formatting text, paragraphs, and pages
- Working with tables, images, and shapes
✅ Intermediate & Advanced Features:
- Using styles and themes for professional formatting
- Creating templates and using mail merge
- Working with references, citations, and footnotes
- Reviewing documents: Track Changes and Comments
- Exporting and printing documents
Module 3: Microsoft Excel 2021 – Data Management & Analysis
✅ Basic Features:
- Creating, opening, and formatting spreadsheets
- Working with rows, columns, and cells
- Basic formulas and functions (SUM, AVERAGE, COUNT, etc.)
- Creating simple charts and graphs
✅ Intermediate & Advanced Features:
- Working with advanced formulas (VLOOKUP, IF, CONCATENATE, etc.)
- Data validation and conditional formatting
- PivotTables and PivotCharts
- Creating macros for automation
- Importing and analyzing large datasets
Module 4: Microsoft PowerPoint 2021 – Presentation Design & Delivery
✅ Basic Features:
- Creating and formatting slides
- Working with text, images, and multimedia elements
- Using slide transitions and animations
✅ Intermediate & Advanced Features:
- Designing professional presentations with themes and templates
- Adding SmartArt, charts, and diagrams
- Inserting videos, audio, and interactive elements
- Using Presenter View and slide recording
- Exporting presentations as PDFs and videos
Module 5: Microsoft Outlook 2021 – Email & Calendar Management
✅ Basic Features:
- Setting up and managing email accounts
- Composing, sending, and organizing emails
- Using folders, filters, and rules
✅ Intermediate & Advanced Features:
- Managing contacts and address books
- Scheduling meetings and setting up reminders
- Creating tasks and to-do lists
- Configuring email security and spam filters
Module 6: Microsoft Access 2021 – Database Management (Optional)
✅ Basic Features:
- Introduction to relational databases
- Creating and managing tables
- Working with queries and reports
✅ Intermediate & Advanced Features:
- Designing and using forms
- Using advanced query techniques
- Automating tasks with macros
Module 7: Microsoft Office Integration & Collaboration Tools
- Using OneDrive for cloud storage and document sharing
- Collaborating on documents in real-time
- Integrating data between Word, Excel, and PowerPoint
- Automating workflows with Microsoft Power Automate
Course Syllabus
1: Introduction to Microsoft Office 2021
2: Microsoft Word 2021 – Word Processing & Document Design
3: Microsoft Excel 2021 – Data Management & Analysis
4: Microsoft PowerPoint 2021 – Presentation Design & Delivery
5: Microsoft Outlook 2021 – Email & Calendar Management
6: Microsoft Access 2021 – Database Management (Optional)
7: Microsoft Office Integration & Collaboration Tools