Microsoft 365 Apps – Level 1 (MB5924)

Module 1: Getting Started with Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Module 2: Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Module 3: Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Module 4: Formatting a Worksheet

• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Module 5: Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Module 6: Managing Workbooks

• Manage Worksheets

Module 1: Getting Started with PowerPoint

• Navigate the PowerPoint Environment
• View and Navigate a Presentation
• Create and Save a Basic Presentation
• Navigate in PowerPoint for the Web
• Use PowerPoint Help

Module 2: Developing a PowerPoint Presentation

• Create Presentations
• Edit Text
• Work with Slides
• Design a Presentation

Module 3: Formatting Text

• Format Characters
• Format Paragraphs

Module 4: Adding and Arranging Graphical Elements

• Insert Images
• Insert Shapes
• Create SmartArt
• Insert Icons and 3D Models
• Size, Group, and Arrange Objects

Module 5: Modifying Graphical Elements

• Format Images
• Format Shapes
• Customize SmartArt
• Format Icons
• Format 3D Models
• Animate Objects

Module 6: Preparing to Deliver Your Presentation

• Review Your Presentation
• Apply Transitions
• Print or Export a Presentation
• Deliver Your Presentation

Module 1: Getting Started with Word

• Navigate in Microsoft Word
• Create and Save Word Documents
• Edit Documents
• Work with Word for the Web

Module 2: Formatting Text and Paragraphs

• Apply Character Formatting
• Control Paragraph Layout
• Align Text Using Tabs
• Display Text in Bulleted or Numbered Lists
• Apply Borders and Shading

Module 3: Working More Efficiently

• Make Repetitive Edits
• Apply Repetitive Formatting
• Use Styles to Streamline Repetitive Formatting Tasks
• Customize the Word Environment

Module 4: Managing Lists

• Sort a List
• Format a List

Module 5: Adding Tables

• Insert a Table
• Modify a Table
• Format a Table
• Convert Text to a Table

Module 6: Inserting Graphic Objects

• Insert Symbols and Special Characters
• Add Images to a Document

Module 7: Controlling Page Appearance

• Apply a Page Border and Color
• Add Headers and Footers
• Control Page Layout
• Add a Watermark

Module 8: Preparing to Publish a Document

• Check Spelling, Grammar, and Readability
• Preview and Print Documents
• Use Research Tools

Module 1: Getting Started with Outlook

• Navigate the Outlook Interface
• Work with Messages
• Access Outlook Help
• Outlook on the Web

Module 2: Formatting Messages

• Add Message Recipients
• Check Spelling and Grammar
• Format Message Content

Module 3: Working with Attachments and Illustrations

• Attach Files and Items
• Add Illustrations to Messages
• Manage Automatic Message Content

Module 4: Customizing Message Options

• Customize Reading Options
• Track Messages
• Recall and Resend Messages

Module 5: Organizing Messages

• Mark Messages
• Organize Messages Using Folders

Module 6: Managing Contacts

• Create and Edit Contacts
• View and Print Contacts

Module 7: Working with the Calendar

• View the Calendar
• Create Appointments
• Schedule Meetings
• Print the Calendar

Module 8: Working with Tasks and Notes

• Create Tasks
• Create Notes