Microsoft Office 2021/365 Essentials Bundle

Five must-have courses for mastering Microsoft Office

The 5-Course Microsoft Office 2021/365 Essentials Bundle

If mastering Microsoft's most popular software applications has been on your to-do list, then this is the training bundle for you.

Composed of five full-length courses, hundreds of individual video lectures, and exercise files and tests, this training bundle is jam-packed with practical tips, tricks and information essential for your success with Microsoft.

Microsoft Excel 2021/365 - Beginners Course

What you'll learn:

  • What’s new in Excel 2021
  • Navigate the Excel 2021 interface
  • Useful keyboard shortcuts to increase productivity
  • Create your first Excel spreadsheet
  • Basic and intermediate Excel formulas and functions
  • Effectively apply formatting to cells and use conditional formatting
  • Smartly use of Excel lists and sorting and filtering
  • Use the cut, copy, and paste options
  • Link to other worksheets and workbooks
  • Analyze data using charts
  • Insert pictures into a spreadsheet
  • Work with views, zooms, and freezing panes
  • Set page layout and print options
  • Protect and share workbooks
  • Save your workbook in different file formats

Master Microsoft PowerPoint 2021:

What you'll learn:

  • Create visually stunning presentations that meet best practice guidelines
  • Find free, high-quality resources like images, icons, fonts, and videos
  • Improve efficiency with keyboard shortcuts and the Quick Access Toolbar
  • Open, close, and save presentations
  • Work with PowerPoint templates
  • Apply slide layouts to new or existing slides
  • Duplicate, arrange, copy, and paste slides and objects
  • Work with images, icons, video, text, shapes, and audio files
  • Correctly select, align, and group objects on a slide
  • Work with animations, transitions, and motion paths
  • Create summary pages using slide and summary zoom
  • Insert and edit charts, diagrams, and tables
  • Insert hyperlinks to other slides, external websites, and mail addresses
  • Create motion video backgrounds
  • Insert screenshots and record/narrate presentations
  • Work with the Slide Master to make universal changes
  • Incorporate third-party add-ins into PowerPoint
  • Prepare a presentation for delivery by adding speaker notes, header and footer, and comments
  • Set up a custom slide show and rehearse timings
  • Use Presenter View to deliver a presentation
  • Export, share, and print a presentation.

Microsoft Word 2021/365 for Beginners:

What you'll learn:

  • Navigate the Word 2021 interface
  • Customize the quick access toolbar
  • Access and modify Word options
  • Create new documents from scratch and from a template
  • Open and save existing documents
  • Switch between different document views
  • Enter, select, and apply formatting to text
  • Use cut, copy, paste, and paste options
  • Find and replace text in a document
  • Format paragraphs
  • Align paragraphs using indents and tab stops
  • Insert bulleted and numbered lists
  • Apply a theme to control the look and feel of the document
  • Apply and modify Word styles
  • Insert content like shapes, icons, text boxes, 3D images, SmartArt, and charts
  • Annotate a document
  • Organise information using tables
  • Adjust the margins and orientation
  • Insert section and page breaks
  • Apply headers and footers
  • Insert blank pages and cover pages
  • Link to websites, other documents, and other sections using hyperlinks and bookmarks
  • Create re-usable content with Quick Parts
  • Create and format a table of contents
  • Add footnotes and end notes to a document
  • Create citations and insert a bibliography
  • Create an index
  • Add captions to pictures and create a table of figures
  • Create multiple letters, envelopes, and labels using mail merge
  • Check spelling and set-up auto-correct options
  • Track changes from multiple authors
  • Compare and combine documents
  • Adjust document properties
  • Check a document for accessibility and compatibility issues
  • Protect a document to prevent changes
  • Share a document with others
  • Collaborate on a document with others in real time
  • Print a document.
Excel 2021/365 Intermediate

What you'll learn:

  • Design better spreadsheets and control user input
  • Use logical functions to make better business decisions
  • Construct functional and flexible lookup formulas
  • Use Excel tables to structure data and make it easy to update
  • Extract unique values from a list
  • Sort and filter data using advanced features and new Excel formulas
  • Work with date and time functions
  • Extract data using text functions
  • Import data and clean it up for analysis
  • Analyze data using PivotTables
  • Represent data visually with PivotCharts
  • Add interactions to PivotTables and PivotCharts
  • Create an interactive dashboard to present high-level metrics
  • Audit formulas and troubleshoot common Excel errors
  • Control user input with data validation
  • Use WhatIf analysis tools to see how changing inputs affect outcomes.

Master Microsoft Outlook 2021/365

What you'll learn:

  • Work with the new simplified ribbon as part of the wider Outlook interface.
  • Configure a Microsoft and Gmail account.
  • Customize the Quick Access Toolbar.
  • Open and customize Outlook Today.
  • Know where to go to get Help.
  • Open, Read, Send and Receive mail.
  • Insert Attachments and Save Attachments from a Message.
  • Use the Search and Filter buttons to find Mail.
  • Flag Messages as Junk and work with the Blocked Senders List.
  • Ignore conversations that are no longer relevant.
  • Clean-up long conversation threads.
  • Organize mail using Follow-up Flags, Categories and Folders.
  • Make emails stand out using Conditional Formatting.
  • Process messages automatically using Rules.
  • Create Search Folders to re-run common searches.
  • Delete and Archive Mail.
  • Create and Format New Messages.
  • Resend and Recall a Message.
  • Reply and Forward Messages.
  • Create and Attach an Email Signature.
  • Add Voting Buttons to get feedback from recipients.
  • Set Delivery Options on messages.
  • Use mentions to target specific people.
  • Translate messages from one language to another.
  • Use Read Aloud to have messages read to you.
  • Send an Out of Office message.
  • Annotate and Draw using Ink.
  • Insert tables, shapes, icons and other media into messages.
  • Add new contacts.
  • Import multiple contacts from a CSV file into Outlook.
  • Organize contacts using contact groups and folders.
  • Share contacts with others.
  • Customize Calendar Settings.
  • Create Appointments, All Day Events and Meetings.
  • Use the Scheduler to find free time.
  • Respond to meeting invites.
  • Create a Microsoft Teams Meeting from within Outlook.
  • Add Delegates to manage your inbox on your behalf.
  • Share Calendars with others.
  • Create and edit tasks in the to do list.
  • Assign task to others and monitor the completion status.
  • Create and manage notes.
  • Customize Outlook Settings.
  • Clean-up a Mailbox that’s reached its size limit.

Course Format

  • This is a video-led course.
  • This course includes practice exercises.

Course Certificate Included

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

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 140 software training courses, 8,000+ video tutorials, and helped thousands of people across the world learn how to use Microsoft Office.

Courses Included with Purchase

Introduction to Microsoft Word 2021
Learn Microsoft Word 2021
Simon Sez IT
Microsoft Excel 2021 Intermediate Training Course
Learn Excel 2021 beyond the basics with this intermediate course
Simon Sez IT
Microsoft Excel 2021 - Beginner Course
Learn the essentials of Microsoft Excel 2021 with this comprehensive beginners’ course!
Simon Sez IT
Master Microsoft PowerPoint 2021 the Easy Way
Unleash your creativity and create impressive presentations with Microsoft PowerPoint 2021!
Simon Sez IT
Master Microsoft Outlook 2021/365
Learn the ins and outs of Outlook 2021 and take control of your inbox!
Simon Sez IT

Original Price: $495

Your Instructor

Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
Can I try a course I'm interested in before I purchase a course or membership?
Absolutely. The first set of videos for each course is free. Our thinking is that this allows you to hear the teacher's voice and see the visuals. To watch a free video, just click onto the course of interest. Then click the video lesson that has the “Preview" button.
What if I have questions or problems while I'm watching my tutorial?
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
Can I get my money back if I'm not satisfied?
We offer an unconditional 14-day full money back guarantee – with no questions asked. As a result, you can rest assured that you can make your purchase in complete confidence. Our motto is “If you don't learn, you don't pay." Thanks to our 14 days risk-free offer, you can test-drive a course and make sure it's what you had in mind. We are committed to your total satisfaction!
If I register for a monthly or annual membership, will my credit card get charged automatically at the end of each pay period?
If you sign up for a monthly or annual membership, your subscription will renew automatically. Customers are welcome to cancel their recurring subscription at any time.
Will your videos work with Mac computers?
All of our courses are compatible with both Windows (PC) and Mac computers.
Will your videos work with iPhone, iPads, and Android devices?
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
Can I view your online training from any computer?
Any computer or mobile device with an Internet connection can be used for our online training courses.
Do you offer any online quizzes or testing tools?
We offer online testing for over 90% of our courses. Testing is also available with our newly published courses. The course tests can be simply used as testing tools or to earn a Certificate of Completion for a given course. The Certificate of Completion can be earned with a passing grade of 70%.
Do you offer Certificates of Completion?
We offer Certificates of Completion for courses and Test Certificates on courses that offer an online quiz (currently over 80% of our courses). The Certificates of Completion are automatically generated when you complete a course, and the Test Certificates are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Do you offer discounts for non-profits or educational institutions?
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Where is Simon Sez IT located?
Simon Sez IT is located in sunny Florida, USA.
How long have you been in business?
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 140 courses. Our training is used in over 180 countries worldwide.
How do I update my name, password, email address and credit card?
Your account includes an account profile. You can edit your profile which includes the option to update your name, email address and password. You can also manage your subscriptions, in addition to adding or updating your credit card information. To access your profile, click on the photo or icon in the upper right hand corner. Then click the “Edit Profile" link. Once you've made changes to your profile, click on the “Update Profile" button to save these changes. You can watch the how to video and other videos here:
How do I update or add a new credit card to my account?
You can update your credit card information directly from your profile. You can also click on your account in the upper right corner and then click on “Add / Change Credit Card". Once you are finished making any updates, click on the “Update Credit Card" button to save these changes. You can watch the how to video and other videos here:

Get started now!