The Microsoft Office 2019 Essentials Bundle

Five Courses, One Amazing Bundle:

The Microsoft Office 2019 Essentials Bundle

We've combined five of our best Microsoft Office 2019 courses into this comprehensive "Microsoft Office 2019 Essentials Bundle." With this incredible combo, you'll have access to:

• Excel 2019 Beginners
• Excel 2019 Advanced
• Outlook 2019
• PowerPoint 2019
• Word 2019

Included in this bundle are downloadable, follow-along exercises and testing to help you retain what you've learned. Upon completion, you'll receive a certificate of completion for each course. Master these Office essentials and watch your productivity soar.

The Courses

Microsoft Excel 2019 - Beginners Course

What you'll learn:

• What's new in Excel 2019
• Creating workbooks
• Entering text, numbers and working with dates
• Navigating workbooks
• Page setup and print options
• Working with rows, columns and cells
• Cut, copy and paste
• Introduction to functions and formulas
• Formatting in Excel, including formatting cells and numbers
• Creating charts and graphs
• Sorting and filtering
• Introduction to PivotTables
• Logical and lookup formulas - the basics

Microsoft Excel 2019 - Advanced Course

What you'll learn:

• What's new/different in Excel 2019
• Advanced charting and graphing in Excel
• How to use detailed formatting tools
• Lookup and advanced lookup functions
• Financial functions including calculating interest and depreciation
• Statistical functions
• Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
• How to create awesome visualizations using sparklines and data bars
• Mastery of PivotTables and Pivot Charts
• Scenario manager, goal seek and solver
• Advanced charts such as surface, radar, bubble and stock charts

Master Microsoft Outlook 2019:

What you'll learn:

• Getting set up in Outlook
• Useful Outlook keyboard shortcuts
• All about sending and receiving emails
• Customize your mailbox and view
• Search in Outlook
• Organize and manage your mail, including ignoring, flagging and conditional formatting
• Effectively deal with junk mail
• Attach files, photos, and graphics
• Recall a message
• Use signatures and voting buttons
• Use, add to, and manage contacts
• Work with the calendar, including creating meetings and appointments
• Share calendars with colleagues
• Use tasks
• Create notes and link Outlook to OneNote

Master Microsoft PowerPoint 2019:

What you'll learn:

• Navigate around PowerPoint
• Presentation dos and don'ts
• Text and bullet edition options
• Use graphics, images, objects and shapes
• Use SmartArt
• Work with charts and graphs
• Utilize master slides for maximum time savings
• Add audio and video to a presentation
• All about transitions between slides
• Animation, the animation pane and motion paths
• Set your slideshow options
• Presentation preparation and delivery
• Backstage area of PowerPoint, including printing a presentation

Word 2019 for Beginners:

What you'll learn:

• Get started with Word 2019
• Word 2019 basics, including navigation, editing and saving
• Character formatting in Word, including format painter and auto correct
• Proper use of bullets and numbering
• All about formatting paragraphs and managing lists
• Work with tables, including formatting, converting data and formulas
• Page appearance, including page-breaks, watermarks and styles
• All about sectioning a document
• Insert graphics, pictures, shapes, icons and 3D models (new for 2019)
• Work with envelopes and labels
• All about mail-merge and operating Word at scale
• Create an index or contents page
• Reviewing, printing and page setup
• Protect a document and use basic macros

Course Info

Format

• These are video-led courses. You can preview some videos by clicking on the courses below.
• These courses include practice exercises so you can practice as you learn.
• These courses are designed for Windows users.
• Suitable for Microsoft 2013, 2016, 2019 and 365 editions.

Course Certificate Included

Each course includes an optional online quiz that will generate a course certificate upon completion.

14-Day Guarantee

We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.

Why Trust Us?

Part of the Simon Sez IT family, Stream Skill has taught over 1 million students since its start in 2008. We’ve created over 130 software training courses, 8,000+ video tutorials, and helped thousands of people across the world learn how to use Microsoft Office.