Skill Level: Beginner
Language: English
Author: Adam Wilbert, David Rivers, Jess Stratton.

Word 2019. Duration - 2h 31m. Topics include:
- Opening, closing, and reading documents
- Finding and replacing text
- Changing font formatting and text case
- Formatting text with styles
- Working with paragraph text
- Creating bulleted and numbered lists
- Illustrating your documents with shapes and images
- Setting proofing and autocorrect options
- Sharing and collaborating with others

Excel 2019. Duration - 2h 08m. Topics include:
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros

Outlook 2019. Duration - 2h 12m. Topics include:
- Accessing the keyboard shortcuts
- Using @mentions
- Reading and searching mail
- Organizing mail
- Processing messages with mail rules
- Using the new Focused Inbox feature
- Creating and formatting new messages
- Recalling and resending messages
- Creating new contacts
- Working with the calendar
- Creating tasks and notes
- Working with Outlook data

PowerPoint 2019. Duration - 2h 02m. Topics include:
- Start quickly with a PowerPoint theme or template
- Creating a presentation from scratch
- Adding and rearranging slides
- Updating slide masters
- Adding text boxes, images, and shapes
- Adding diagrams and charts
- Adding video, audio, and animation
- Saving and sharing presentations
- Delivering presentations
- Saving themes and templates
- Exporting your work

Access 2019. Duration - 3h 40m. Topics include:
- Creating a new database
- Creating tables and new data types
- Importing and entering data
- Setting up relationships and primary keys
- Adding validation rules
- Sorting and filtering table data
- Building queries
- Designing forms
- Creating reports
- Maintaining an Access database