Microsoft Essentials Bundle

The 6-Course Microsoft 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 six 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 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

Master Microsoft Teams

What you'll learn:

• Access, download and set up Teams
• Create your first team and manage members and channels
• All about posting and receiving public and private messages
• Use announcements, tags, and message extensions
• Schedule an audio or video call
• Use the audio and video calling options, including recording calls
• Use the meeting notes function
• Create a wiki
• All about using apps, bots, and connectors
• Adjust admin and user settings
• Use Teams on your mobile device

Learn Microsoft Windows 11

What you'll learn:

• What’s new in Windows 11
• Upgrading from Windows 10 to Windows 11
• Check system compatibility
• Set up Windows 11 for the first time
• Explore the Windows 11 interface
• Connect and install devices
• Customize the start menu and taskbar
• Customize the file explorer views
• Use OneDrive in file explorer
• Organize and personalize the desktop and lock screen
• Organize multiple workspaces
• Use widgets and sticky notes
• Use Windows and Office applications
• Install and uninstall applications
• Use mail, address book, and calendar
• Manage notifications and use focus assist
• Use Windows search and voice commands with Cortana
• Use Microsoft Edge and Teams
• Manage multiple accounts
• Back up data

PivotTables for Beginners

What you'll learn:

• Clean and prepare your data
• Create a basic pivot table
• Use the pivot table fields pane
• Add fields and pivot the fields
• Format numbers
• Different ways to summarize data
• Group data
• Use multiple fields and dimensions
• Methods of aggregation
• Choose and lock the report layout
• Apply styles
• Sort data and use filters
• Create pivot charts based on data
• Select the right chart for your data
• Apply conditional formatting
• Add slicers and timelines to your dashboards
• Add new data to the original source dataset
• Update pivot tables and charts

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