The 2022 Premium Microsoft Office Training Certification Bundle

This online PowerPoint course will teach you how to use PowerPoint the right way. Let’s learn every tool and every function inside PowerPoint and make presentations that impress! This PowerPoint course is designed to teach you all the tricks and tips you need to pull up your game in making awesome presentations. Regardless of what your level of experience is or what professional field you are in, this in-depth course is designed to provide you with everything you need to take your Presentation skills to the next level. Whether you prefer being more visual or using more animations, a great presenter knows how to compose a slide, animate it, and edit it. By honing these skills, you can sell your ideas so you can turn your passion into a career. This course shows you how to turn your ideas into visual slides that will gather the attention you need.

• Access 100 lectures & 11 hours of content 24/7
• Learn & Design Amazing PowerPoint Slides that wow your customers or colleagues
• Build PowerPoint Projects to take you to the next level
• Learn shortcuts that will save you time
• Think out of the box with amazing animation possibilities inside PowerPoint
• Turn a boring presentation into a sensational one
• Use of every tool
• Understand When Why & How to use PowerPoint to create amazing designs
• Learn how to become a master or a guru of PowerPoint Software
• Learn the essentials of an awesome design & how to be a Boss at designing your own content
• Create Templates that sell
• Be the best version of yourself at PowerPoint

Note: Software NOT included.

Do you want to learn the skills to professionally analyze data? Do you want to learn all the steps to create impressive reports? Then Microsoft Power BI is the right tool for you! In this course, you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator. This course is right for you if you have never worked with Power BI and want to learn everything hands-on in one course or you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI. This is the course that covers everything in Power BI to become an advanced report developer!

• Access 163 lectures & 15 hours of content 24/7
• Understand everything from scratch – step by step, very structured and practice-oriented
• Learn all the important tools – know when and how to use them properly
• Connect different data sources – from basics to advanced
• Create your data model – and understand it
• Master DAX – to do more advanced analysis on your data
• Get to know all the different visualizations – and how to use them
• Storytelling with data – learn how to visualize your data effectively
• Create interactive visualizations – with drill throughs and drill-downs
• Advanced analysis – learn how to use R Script in Power BI (Data Science)
• Forecasting – Advanced analytics which can be helpful in Data Science
• Row-Level Security – Implement the security concept to control access to the data

Teams are the hub for teamwork in Microsoft 365, providing a centralized workspace for teams to communicate and collaborate. It features persistent and threaded chats, file sharing, and the ability to hold meetings. Students will learn to create teams, add users, manage a team, start a team conversation, reply to a conversation, and add files. Students will also explore channels, create new channels, create and share files, work with meetings, schedule team meetings, integrate with SharePoint, add tabs to keep files, notes, and apps available, and connectors to access content and get updates.

• Access 31 lectures & 2 hours of content 24/7
• Converse & collaborate with Teams
• Add & share files with Teams
• Schedule team meetings, work with conversations & more
• Know how to create & add users and manage a team
• Find out ways on how to create channels & work with favorites
• Gain insights on how to integrate SharePoint, add tabs & connectors

Paperless and productive — the two biggest benefits you will get from doing this course. OneNote lets you take your work with you, wherever you go, on any device. It syncs automatically, so you never have to worry about saving notes when you're on the go. Earn, and Excel brings you a course that will teach you everything you need to know about OneNote, and then some. 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, your notes will be highly organized, stored in one place, and easily accessed from any device.

• Access 58 lectures & 5 hours of content 24/7
• Get started with OneNote: introduction, quick access toolbar & inserting notes
• Copy cut text & split and merge containers
• Delete & insert time stamp
• Format text, apply styles & use format painter
• Add & organize sections
• Create subpages & section groups
• Work with different page versions
• Insert printouts & attachments

If you are working in a small company and you want to be able to manage your data, whether that be some sales data, expenses, marketing information, or project focus data and you need to get up and running quickly with a database to handle it, well Access is definitely the tool for you. This course is created to teach you how to use Access to be a great end-user tool that you can get up and running quickly and give your database more advanced capability if you wish to.

• Access 36 lectures & 5 hours of content 24/7
• Learn the fundamentals of Access: tables, primary key & data types
• Query your database
• Create links between tables
• Create forms with & without the wizard
• Use the wizard to build a report or
• Export data to Excel, Word, or PDF
• Use buttons to carry out advanced functions, conditional outputs, & more

As the corporate world adopts more remote working practices, SharePoint's role as not just a document management tool but as a full collaboration tool is evolving. More than ever, SharePoint is playing a significant role in companies' success in managing their everyday work. Several of us experienced professionals at Earn and Excel collaborated and created an efficient and powerful training for SharePoint that will have you making the most of this brilliant tool for your team's needs. This course introduces you to SharePoint and how it is important to day-to-day organization tasks.

• Access 32 lectures & 3 hours of content 24/7
• Understand why SharePoint is so important for the modern day organization
• Manage subsites & user permissions to add powerful controls
• Explore SharePoint apps, lists & libraries
• Work with SharePoint libraries to maximize document management capabilities
• List views & calendar for a visual interpretation of your team's assets
• Work with site pages to enhance & customize your SharePoint experience
• Sync with OneDrive to connect data sources
• Site columns & content types to further customize the management of your document assets

Earn and Excel worked with the highly experienced corporate professional and trainer Claudia Carrozzo who brought her many years of using Office in some of the biggest, most high profile global companies and created an incredible training course which will have you working to an intermediate level with Word in a few hours.

• Access 83 lectures & 4 hours of content 24/7
• Be familiar with the quick access toolbar, Ribbon, & basic operations
• Get started with formatting, spell checking, & removing spaces
• Work with tables
• Use margins & alignments
• Know the best practices with text boxes
• Create shapes & objects
• Use styles to customize your documents