Microsoft Office (Microsoft 365 Apps)

Course Details

• 1. Explore Office
• Work in the Office user interface
• Discover New Features
• Change Office and app options
• Display and customize the Quick Access Toolbar
• Customize the ribbon
• 2. Create and Manage Files
• Create Files
• Open and Move around in files
• Display Different views of files
• Display and edit file properties
• Save and Close files
• Microsoft Word - Modify the Structure and Appearance of Text
• Apply paragraph formatting
• Apply character formatting
• Structure content manually
• Create and modify lists
• Apply built-in styles to text
• Change the document theme
• 4. Microsoft Word - Collaborate on Documents
• Mark up documents
• Display and review document markup
• Compare and combine documents
• Control content changes
• Coauthor documents
• 5. Microsoft Word - Merge Data with Documents and Labels
• Understand the mail merge process
• Start the mail merge process
• Choose and refine the data source
• Insert merge fields
• Create individual envelopes and labels
• Microsoft Excel - Performing Calculations on Data
• Name Data Ranges
• Create Formulas Values
• Summarize Data that Meets Specific Conditions
• Copy and move formulas
• Find and correct errors in calculations
• Configure automatic and iterative calculation options
• Microsoft Excel - Manage Worksheet Data
• Filter data ranges and tables
• Summarize filtered data
• Enforce data entry criteria
• Microsoft Excel - Reorder and Summarize Data
• Sort worksheet data
• Sort data by using custom lists
• Outline and subtotal data
• Microsoft Excel - Analyze Alternative Data Sets
• Define and display alternative data sets
• Forecast data by using data tables
• Identify the input necessary to achieve a speciific result
• Microsoft PowerPoint - Create and Manage Slides
• Add and remove slides
• Apply themes
• Change slide backgrounds
• Divide presentations into sections
• Rearrange slides and sections
• Microsoft PowerPoint - Insert and Manage Simple Graphics
• Insert, move, and resize pictures
• Edit and format pictures
• Provide additional information about pictures
• Create a photo album
• Insert and format icons
• Draw and modify shapes
• Microsoft PowerPoint - Add Sound and Movement to Slides
• Animate text and pictures on slides
• Customize animation effects
• Add audio content to slides
• Add video content to slides
• Compress media to decrease file size
• Microsoft Outlook - Send and Receive Email Messages
• Create and send messages
• Attach files and Outlook items to messages
• Display messages and message attachments
• Display message participant information
• Respond to messages
• Microsoft Outlook- Organize your Inbox
• Display and manage messages
• Arrange messages by specific attributes
• Categorize items
• Organize messages in folders
• Print messages
• Microsoft Outlook - Manage Scheduling
• Display different views of a calendar
• Schedule appointments and events
• Convert calendar items
• Configure calendar intem options
• Schedule and change meetings
• Respond to meeting requests