Learning Objectives
5 objectives- Understand the core applications within the Microsoft Office Suite and their primary functionalities.
- Develop proficiency in Microsoft Word, Excel, PowerPoint, Outlook, Access, and OneNote through practical application.
- Learn effective collaboration techniques using Microsoft Office tools and cloud services.
- Customize Microsoft Office applications to improve productivity and workflow.
- Prepare for Microsoft Office certification exams with knowledge of resources and benefits.
Content Outline
PreviewUnit 877: Comprehensive Microsoft Office Suite
1. Introduction to Microsoft Office Suite
- Overview of Microsoft Office Suite
- Key applications and their purposes
- Integration and interoperability among applications
2. Microsoft Word: Word Processing Essentials
- User interface and navigation
- Document formatting (fonts, paragraphs, styles)
- Using and creating templates
- Working with tables
- Mail merge: concepts and practical use
3. Microsoft Excel: Data Analysis and Manipulation
- Workbook and worksheet basics
- Functions and formulas: SUM, IF, VLOOKUP, etc.
- Creating and formatting charts
- Introduction to pivot tables and pivot charts
4. Microsoft PowerPoint: Professional Presentations
- Slide layouts and templates
- Adding and formatting text, images, and multimedia
- Using transitions and animations
- Managing speaker notes and presentation mode
5. Microsoft Outlook: Email and Personal Information Management
- Setting up and managing email accounts
- Composing, organizing, and managing emails
- Calendar scheduling and appointments
- Task tracking and reminders
- Managing contacts and address books
6. Microsoft Access: Database Management Basics
- Understanding database concepts
- Creating tables and defining relationships
- Designing queries to extract data
- Building forms for data entry
- Generating reports for data presentation
7. Microsoft OneNote: Digital Note-taking and Organization
- Creating notebooks, sections, and pages
- Adding text, images, audio, and attachments
- Using tags and search functionality
- Organizing and sharing notes
8. Collaboration in Microsoft Office Suite
- Sharing documents and setting permissions
- Real-time co-authoring features
- Using OneDrive for cloud storage and collaboration
- Version control and document history
9. Customizing Microsoft Office
- Keyboard shortcuts and quick access toolbar
- Creating and managing custom templates
- Applying themes and styles
- Using and installing add-ins to extend functionality
10. Microsoft Office Certification
- Overview of certification paths (MOS Specialist, Expert, Master)
- Exam formats and key topics
- Recommended preparation resources and practice tests
- Benefits and career opportunities with certification
Unlock the full outline
Get the complete content outline, learning outcomes and assessment methods for Microsoft Office Suite.
KSh 20 one-off, or included with a plan
Learning Outcomes
Unlock the outline above to see learning outcomes.
Assessment Methods
Unlock the outline above to see assessment methods.