Language: English
Awarding Body: Microsoft
Duration: 64 Hrs
Associated Exams: Exam MO-110: Microsoft Word (Microsoft 365 Apps)
Exam MO-210: Microsoft Excel (Microsoft 365 Apps)
Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps)
Course Description:
Microsoft office is a suite of desktop/cloud-based applications and services such as Word, Excel, PowerPoint, and Outlook. A certification in Microsoft Office Apps will demonstrate skills to get the most out of Office desktop applications/Microsoft 365 Apps. This expertise can be used to gain all kinds of work-related benefits. Also, the skills acquired will help to make work much easier and streamlined.
Pre-Requisite:
Familiarity on working with Windows Operating system
Course Objectives:
After taking this course, you should be able to:
- Manage documents
- Insert and format text, paragraphs, and sections
- Manage tables and lists
- Create and manage references
- Insert and format graphic elements
- Manage document collaboration
- Manage worksheets and workbooks
- Manage data cells and ranges
- Manage tables and table data
- Perform operations by using formulas and functions
- Manage charts
- Manage presentations
- Manage slides
- Insert and format text, shapes, and images
- Insert tables, charts, SmartArt, 3D models, and media
- Apply transitions and animations
Course Content:
Microsoft Office Word 2021: Part 1
- Lesson 1: Getting Started with Word 2021
- Lesson 2: Formatting Text and Paragraphs
- Lesson 3: Working More Efficiently
- Lesson 4: Managing Lists
- Lesson 5: Adding Tables
- Lesson 6: Inserting Graphic Objects
- Lesson 7: Controlling Page Appearance
- Lesson 8: Preparing to Publish a Document
Microsoft Office Word 2021: Part 2
- Lesson 1: Organizing Content Using Tables and Charts
- Lesson 2: Customizing Formats Using Styles and Themes
- Lesson 3: Inserting Content Using Quick Parts
- Lesson 4: Using Templates to Automate Document Formatting
- Lesson 5: Controlling the Flow of a Document
- Lesson 6: Simplifying and Managing Long Documents
- Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels
Microsoft Office Word 2021: Part 3
- Lesson 1: Manipulating Images
- Lesson 2: Using Custom Graphic Elements
- Lesson 3: Collaborating on Documents
- Lesson 4: Adding Document References and Links
- Lesson 5: Securing a Document
- Lesson 6: Using Forms to Manage Content
- Lesson 7: Automating Repetitive Tasks with Macros
Microsoft Office Excel 2021: Part 1
- Lesson 1: Getting Started with Excel 2021
- Lesson 2: Performing Calculations
- Lesson 3: Modifying a Worksheet
- Lesson 4: Formatting a Worksheet
- Lesson 5: Printing Workbooks
- Lesson 6: Managing Workbooks
Microsoft Office Excel 2021: Part 2
- Lesson 1: Working with Functions
- Lesson 2: Working with Lists
- Lesson 3: Analyzing Data
- Lesson 4: Visualizing Data with Charts
- Lesson 5: Using PivotTables and PivotCharts
Microsoft Office Excel 2021: Part 3
- Lesson 1: Working with Multiple Worksheets and Workbooks
- Lesson 2: Sharing and Protecting Workbooks
- Lesson 3: Automating Workbook Functionality
- Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing
- Lesson 5: Forecasting Data
- Lesson 6: Creating Sparklines and Mapping Data
Microsoft Office PowerPoint 2021: Part 1
- Lesson 1: Getting Started with PowerPoint 2021
- Lesson 2: Developing a PowerPoint Presentation
- Lesson 3: Formatting Text
- Lesson 4: Adding and Arranging Graphical Elements
- Lesson 5: Modifying Graphical Elements
- Lesson 6: Preparing to Deliver Your Presentation
Microsoft Office PowerPoint 2021: Part 2
- Lesson 1: Customizing Design Templates
- Lesson 2: Adding Tables
- Lesson 3: Adding Charts
- Lesson 4: Working with Media
- Lesson 5: Building Advanced Transitions and Animations
- Lesson 6: Finalizing a Presentation
- Lesson 7: Modifying Presentation Navigation
- Lesson 8: Securing and Distributing a Presentation
