The 2022 Microsoft Office Essentials Training Bundle

In this practical hands-on course, our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, VBA, data analysis, and how to land your first job as an Excel expert! This course will fully prepare you for virtually any Excel-related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

• Access 155 lectures & 13 hours of content 24/7
• Master Excel from A-Z
• Become a professional Data Analyst
• Be a better, faster, stronger Excel user
• Land your first job as an Excel Expert
• Save hours of time & boost your productivity in Excel
• Find a value with VLOOKUP, HLOOKUP, INDEX, MATCH

If you want to get better at Microsoft Office so you get a better paying job or just learn how to breeze through your tasks with Word, PowerPoint, and Outlook then you are in the right place. No matter if you are a Microsoft Office Beginner or never used Microsoft Office before, you are sure to benefit from this quick course which goes through the must-know Microsoft Word, PowerPoint, and Outlook features.

• Access 31 lectures & 1 hour of content 24/7
• Become more productive at using Microsoft Office
• Increase your Microsoft Office skills & knowledge
• Create your own Word document, Outlook account, PowerPoint animated presentation from scratch
• Know how the Microsoft Office suite is used with real examples

Are you ready to gain full control of Microsoft OneNote today? If so, take this course right now. This course is designed for anyone who wants to learn how to use Microsoft OneNote. You don't need any prior knowledge of the software—we'll cover everything from scratch. By the end of this course, you will have learned how to use Microsoft OneNote and be able to use it on your own projects with ease.

• Access 14 lectures & 1 hour of content 24/7
• Get started with OneNote
• Organize notebooks
• Explore the Settings & View tab
• Work with multiple accounts
• Tell Me in OneNote
• Add text & videos
• Insert more items
• Explore Drawing & Search tools
• Learn how to use OneNote web clipper
• Share notebooks & pages
• Print pages
• Explore OneNote Online & OneNote 2016

You've got the job, now what? Maybe you've been asked to manage your department's or team's SharePoint site. Maybe you're just trying to figure out how to change something on your team's site. Either way, we've got you covered! This course will show you how to change and manage a SharePoint site. It will start with the basics—setting up a new site, adding a document library, and creating a custom page—and then move on to more advanced topics like changing permissions and working with metadata. By the end of this course, you'll be an expert at managing your site!

• Access 10 lectures & 1 hour of content 24/7
• Change a page
• Add new pages
• Link pages together
• Make it so documents have to be checkout from a document library
• Add Announcements to your site
• Add Tasks to your site
• Add a Calendar to your site
• Make your page show an Excel, Word, or Power BI document
• Add users to your site

This course will help you to pass the MS-300 exam. In this course, you will learn how to plan, deploy and manage Microsoft Teams. Specifically, this course discusses the relationship of Teams with SharePoint, OneDrive, and Office 365 Groups. It provides best practices for the adoption and deployment of Teams within your organization. It also covers how to establish guest policies and data governance for your Teams data. The Microsoft 365 Teamwork Administrator learning track helps prepare for the MS-300 Microsoft 365 exam.

• Access 23 lectures & 4.5 hours of content 24/7
• Plan for a Microsoft 365 Teams deployment
• Configure Office 365 for Teams
• Create Teams & Channel
• Use Policies to setup Teams
• Manage & create meetings
• Learn security & compliance

Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious!

Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses. This course will cover 6 key topics that will help you produce more impactful business presentations. By the end of this course, you will have learned how to effectively use PowerPoint for your business presentations.

• Access 8 lectures & 1 hour of content 24/7
• Identify the most useful slide transitions & animations for business presentations
• Use the morph transition to draw the audience’s attention
• Create a “zoom” summary slide to jump to user-selected sections of slides
• Animate charts to highlight key points
• Embed a Microsoft Excel table in a PowerPoint slide
• Create a video with commentary of their PowerPoint presentation

OneDrive is the cloud storage service developed by Microsoft that allows you to store all your important files securely in one place and then access them virtually anywhere. Also, OneDrive makes it easy to share content with other people and collaborate in real-time using the Microsoft 365 integration.

Whether you intend to use OneDrive for personal or business, use this crash course brought to you by Earn and Excel. It will teach you everything you need to know to understand the difference between them. You will be taught by the highly experienced corporate professional and trainer Claudia who shares her many years of using Office in some of the biggest, most high-profile Global companies. By the end of this course, you will fully understand how to use OneDrive and get the best out of it.

• Access 8 lectures & 1 hour of content 24/7
• Check the look & feel of OneDrive
• Navigate files & viewing information
• Move files within OneDrive & from file explorer
• Organize & search for file types
• Access OneDrive from the PC
• Share documents
• Use version history

Power BI is a business intelligence tool that allows you to create interactive dashboards with ease. In this course, we'll learn how to install Power BI and compare its dashboard with Excel charts and other BI tools. You'll also learn how to use Power Query and Power Pivot inside the Power BI environment. By the end of this course, you will have learned to build interactive dashboards with Power BI.

• Access 25 lectures & 1 hour of content 24/7
• Discover Power BI as leader in Business Intelligence platforms
• Explore how to add automated commentaries to Power BI dashboard
• Discover essential visuals to make your dashboard interactive
• Recognize powerful function in Power BI to cross filter dashboard visuals
• Identify the best practices in Power BI dashboards