Managing Data with Microsoft 365
1h 3mGeneral2022-08-12
Authors

Microsoft
Supporting inclusive economic opportunity

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
0. Introduction
- 01 - Unlocking your data management
1. Getting Started with Forms
- 02 - The value of Forms
- 03 - Navigating Microsoft Forms
- 04 - Creating your first form
- 05 - Customizing your forms
- 06 - Gathering survey data
- 07 - Collaborating on forms
2. Building Processes with Power Automate
- 08 - Benefits of Power Automate
- 09 - Navigating Power Automate
- 10 - Creating your first Power Automate flow
- 11 - Integrating with other products
3. Analyzing Data in Excel
- 12 - Managing data in Excel
- 13 - Using PivotTables
- 14 - Creating your first PivotTable
- 15 - Using XLOOKUP
4. Utilizing Power BI Desktop
- 16 - Visualizing data with Power BI
- 17 - Navigating Power BI
- 18 - Importing data in Power BI
- 19 - Managing your Power BI data
- 20 - Creating Power BI reports
- 21 - Distributing easy to follow data
Conclusion
- 22 - Managing data with Microsoft 365