Master Microsoft Office 365 and Power Platform

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Word. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you. This course will introduce you to Microsoft 365. You will become familiar with the apps and services included in an Office 365 subscription. If you are familiar with Word’s basic features you can take your skills to the next level. If you are not familiar with Microsoft products or are a beginner you will get the opportunity to develop basic word processing skills. This course covers the different features of the Word interface, shows you how to create a basic document, and introduces you to Word’s most important tools. By the end of this course, you should be able to apply the necessary techniques to produce high-quality, professional documents. You will also understand how to create complex documents using tables, charts, references, and various types of illustrations. This course will help you prepare for Exam MO-100: Microsoft Word (Word and Word 2019). This exam covers the ability to create and maintain professional-looking reports, multi-column newsletters, résumés, and business correspondence. Certification exam candidates are expected to demonstrate the correct application of the principal features of Word and complete tasks independently. You will get an opportunity to hone all these skills in this course.

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft PowerPoint. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you. This course is intended to help you get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features. You will learn how to create, save, and present a basic presentation; apply the basics of formatting; and add multimedia to a presentation. If you are familiar with PowerPoint’s basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop your presentation skills using PowerPoint. By the end of this course, you should be comfortable with customizing the PowerPoint user interface, customizing design templates, implementing media and custom animations in a presentation, using collaboration tools, customizing slide shows in a number of different ways, as well as securing and distributing a presentation. This course will help you prepare for Exam MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019). You will be able to demonstrate the ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations, and manage multiple presentations. You will be able to apply the principal features of PowerPoint and complete tasks independently.

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you. This course will introduce you to Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data. If you are familiar with Excel’s basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop basic Excel skills. In this course, you will become comfortable with creating a new spreadsheet, working with basic formulas and functions, making your spreadsheets look professional and presentable, and saving and printing a spreadsheet. By the end of this course, you will be comfortable creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks. This course will help you prepare for Exam MO-200: Microsoft Excel (Excel and Excel 2019). You will get opportunities to demonstrate the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. You will also show that you can apply the correct application of the principal features of Excel and complete tasks independently.

What if you could boost your efficiency by 40%, enhance your creativity by 70%, and significantly save time in your daily tasks? 'Introduction to O365 Copilot,' a beginner-level course expertly guided by Rob Rubin, Ph.D., can make this a reality for you. In 1.5 hours, unlock the potential of Microsoft 365 Copilot to revolutionize your work efficiency across the Microsoft 365 Suite. This course is your ticket to boosting productivity, transforming data management, and optimizing business processes through AI's power. By the end of the course, you will be able to: - Describe the fundamentals of 365 Copilot. - Access and navigate the 365 Copilot platform effectively. - Integrate 365 Copilot seamlessly with Microsoft 365 Suite. - Demonstrate prompt engineering for utilizing essential features of 365 Copilot. You will not just learn about Copilot's capabilities but will be ready to apply these insights practically, ensuring an immediate improvement in workflow and collaboration within the Microsoft ecosystem. To be successful in this course, you should use the Office 365 application moderately and have made occasional usage of ChatGPT or Bing. Join us to transform how you work with Microsoft 365 Copilot, leveraging AI to make your work life not only more productive but also more creative and fulfilling.

Welcome to course 1 on Microsoft Power Platform Fundamentals! This course provides an overview of modules within the Power Platform ecosystem. You will gain a solid understanding of its capabilities & potential for building powerful business solutions, get insights into data connectors & their role in integrating, interacting with different data sources. You will delve into Microsoft Dataverse, a secure scalable data platform at the core of Power Platform, understand how it allows you to define relationships between tables & entities, enabling efficient management & organization of your data, learn about its environments, which play a crucial role in separating & managing data & apps within Power Platform. You will also discover how Power Apps empowers you to create applications tailored to your business needs, enhancing productivity & efficiency. Real-world examples, such as the Heathrow Airport customer case study, provide practical insights into successful Power Platform implementations. Finally, you will also be introduced to the Exam PL-900. By the end of the course, you will be able to: 1. Describe the components of Microsoft Power Platform, the business value for customers, & security of the technology. 2. Define the basic concepts of the Dataverse and ways you can connect and customize data connections to Microsoft Power Platform applications. 3. Recognize the value and capabilities of Power Apps & ways other organizations have leveraged this technology to build simple applications for their business.

This cover will cover the capabilities of Power BI, a business intelligence tool that transforms raw data into data visualizations and interactive dashboards. The course will guide you through connecting various data sources, shaping your data for analysis, and designing compelling visualizations to uncover hidden trends and patterns all within the Power BI platform. You'll also learn about the security features of Power BI, ensuring your data remains protected and accessible only to authorized users. Moving forward, you'll discover the ease of creating chatbots with Power Virtual Agents. This no-code platform will allow you to build intelligent bots that can talk to your customers and employees and enhance their overall user experience. You'll learn how to define conversation topics, design interactive dialogues, and publish your chatbot across various platforms like Microsoft Teams, Facebook, and etc. The course concludes by demonstrating how to analyze your chatbot's performance, allowing you to continuously refine and improve its effectiveness.

This course will validate your knowledge of the Microsoft Power Platform and prepare you to take the Exam: PL-900: Microsoft Power Platform Fundamentals. Additionally, this course will recap the main features and functionalities of the Microsoft Power Platform: covering its core components such as Power BI, Power Apps, Power Automate, and Power Virtual Agents, their individual capabilities, and how they seamlessly integrate to form a powerful ecosystem.