Skill Level: Beginner
Language: English
Authors: David Rivers, Jess Stratton, Curt Frye

Excel 2019. Duration - 4h 42m. Topics include:
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks

Word 2019. Duration - 2h 39m.Topics include:
- Inserting and editing text
- Formatting text and pages
- Working with columns and tables
- Adding images and shapes
- Removing distractions with Focus mode
- Using proofing tools to check spelling and grammar
- Collaborating on documents with your team
- Sharing documents via OneDrive and email
- Adding password protection to a file

Outlook 2019. Duration - 1h 39m. Topics include:
- Adding email accounts
- Reading messages
- Working with junk mail and blocked senders
- Saving attachments
- Searching mail
- Organizing mail with folders, flags, and color categories
- Creating mail rules
- Adding signatures
- Setting an out-of-office or autoreply email
- Creating new contacts and groups
- Working with delegates
- Creating meetings
- Opening other calendars
- Creating tasks

PowerPoint 2019. Duration - 1h 57m. Topics include:
- Creating presentations from themes and templates
- Creating a presentation from scratch
- Using slide masters
- Changing the slide layout
- Using the new Morph transition feature
- Working with images and shapes
- Inserting and managing icons and 3D models
- Creating and formatting charts
- Using SmartArt to create diagrams
- Using the improved roaming pencil case
- Adding video, audio, and animations to a slide
- Adding speaker notes and comments
- Running a slideshow
- Reusing and sharing PowerPoint presentations