Learn how to work effectively and efficiently with data across the Microsoft Office 365 and Power Platform applications.
Overview
Syllabus
Introduction
- Using the right tool to do the job
- Create spreadsheets in Excel
- Manage relational databases in Access
- Use multiple data types in SharePoint
- Managing across the enterprise with the Dataverse
- Know your purpose
- Know your audience
- Know your scope
- Inputting data in Microsoft
- Storing information
- Viewing data in Excel
- Creating custom SharePoint views
- Managing permissions and security
- Performing calculations
- Formatting tables
- Linking sources
- Assessing strengths and weaknesses
- Creating charts and graphs in Excel
- SharePoint charting features and limitations
- Charts and graphs in PowerPoint and Word
- Expand charting to multiple data sources with PowerPivot
- Power BI for detailed reporting from multiple data sources
- SharePoint Syntex for AI document analysis
- Dynamically embed and update data
- Leverage ability of Office 365 to work between tools
- The importance of formatting
- Where to go from here
Taught by
Phil Gold