Managing Data with Microsoft 365

Managing Data with Microsoft 365

1h 3mGeneral2022-08-12

Authors

Microsoft

Microsoft

Supporting inclusive economic opportunity

Christine Matheney

Christine Matheney

Senior Program Manager

Course details

Managing data is a key skill in today’s data-driven business world. And Microsoft 365 offers a wide range of tools to gather, manage, and visualize your data in powerful, compelling ways. In this course, senior program manager Christine Matheney teaches you how to use the Microsoft 365 suite to manage your data more effectively. Get started with Microsoft Forms for collecting data from raw sources, before exploring how to build processes and manage large amounts of data using the different components of Power Automate. Learn why Excel is such a popular platform and how to use its built-in tools to analyze data to gain insights. Along the way, get tips from Christine on visualizing data with PowerBI to communicate your findings with the rest of the team. Upon completing this course, you'll be able to wield your new skills to manage data more effectively for better insights that everyone can understand.

Skills covered

Microsoft FormsPower AutomateData Resource ManagementPower BIPersonal Productivity SoftwareMicrosoft 365Microsoft ExcelDatabase ManagementCloud ServicesCloud ComputingBusiness Software and ToolsMicrosoftOne-Off

Concepts

Introduction

  • Unlocking your data management

Getting Started with Forms

  • The value of Forms
  • Navigating Microsoft Forms
  • Creating your first form
  • Customizing your forms
  • Gathering survey data
  • Collaborating on forms

Building Processes with Power Automate

  • Benefits of Power Automate
  • Navigating Power Automate
  • Creating your first Power Automate flow
  • Integrating with other products

Analyzing Data in Excel

  • Managing data in Excel
  • Using PivotTables
  • Creating your first PivotTable
  • Using XLOOKUP

Utilizing Power BI Desktop

  • Visualizing data with Power BI
  • Navigating Power BI
  • Importing data in Power BI
  • Managing your Power BI data
  • Creating Power BI reports
  • Distributing easy to follow data

Conclusion

  • Managing data with Microsoft 365
40,000 Toman