Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Microsoft Data: SharePoint, Power Platform, Access, Excel

via LinkedIn Learning

Overview

Learn how to work effectively and efficiently with data across the Microsoft Office 365 and Power Platform applications.

Syllabus

Introduction
  • Using the right tool to do the job
1. Meet the Tools
  • Create spreadsheets in Excel
  • Manage relational databases in Access
  • Use multiple data types in SharePoint
  • Managing across the enterprise with the Dataverse
2. How Do You Decide Which Application to Use?
  • Know your purpose
  • Know your audience
  • Know your scope
3. Capturing Data in Microsoft
  • Inputting data in Microsoft
  • Storing information
  • Viewing data in Excel
  • Creating custom SharePoint views
  • Managing permissions and security
4. Tables: Excel, Word, or PowerPoint?
  • Performing calculations
  • Formatting tables
  • Linking sources
  • Assessing strengths and weaknesses
5. Charts and Graphs
  • Creating charts and graphs in Excel
  • SharePoint charting features and limitations
  • Charts and graphs in PowerPoint and Word
6. Add-Ons for Microsoft Applications
  • Expand charting to multiple data sources with PowerPivot
  • Power BI for detailed reporting from multiple data sources
  • SharePoint Syntex for AI document analysis
7. Recommendations and Best Practices
  • Dynamically embed and update data
  • Leverage ability of Office 365 to work between tools
  • The importance of formatting
Conclusion
  • Where to go from here

Taught by

Phil Gold

Reviews

4.6 rating at LinkedIn Learning based on 317 ratings

Start your review of Microsoft Data: SharePoint, Power Platform, Access, Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.