Microsoft Office 2019/365 – Level 1 (MB5924)

Module 1: Getting Started with Excel 2019

• 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 7: 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 8: Developing a PowerPoint Presentation

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

Module 9: Formatting Text

• Format Characters
• Format Paragraphs

Module 10: Adding and Arranging Graphical Elements

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

Module 11: Modifying Graphical Elements

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

Module 12: Preparing to Deliver Your Presentation

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

Module 13: Getting Started with Word

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

Module 14: 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 15: Working More Efficiently

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

Module 16: Managing Lists

• Sort a List
• Format a List

Module 17: Adding Tables

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

Module 18: Inserting Graphic Objects

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

Module 19: Controlling Page Appearance

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

Module 20: Preparing to Publish a Document

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

Module 21: Getting Started with Outlook

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

Module 22: Formatting Messages

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

Module 23: Working with Attachments and Illustrations

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

Module 24: Customizing Message Options

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

Module 25: Organizing Messages

• Mark Messages
• Organize Messages Using Folders

Module 26: Managing Contacts

• Create and Edit Contacts
• View and Print Contacts

Module 27: Working with the Calendar

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

Module 28: Working with Tasks and Notes

• Create Tasks
• Create Notes