From the course: Microsoft Data: SharePoint, Power Platform, Access, Excel
Join today to access over 24,900 courses taught by industry experts.
Dynamically embed and update data
From the course: Microsoft Data: SharePoint, Power Platform, Access, Excel
Dynamically embed and update data
- [Instructor] I always believe in doing the job with as little extra work as possible. In this last section of the course, I want to reemphasize a few points I think are important to keep in mind. And following some simple best practices will save you time and trouble. When you need to share data that already exists in Excel, you are always better off using a method that keeps it up to date dynamically. For instance, if you need to show tabular information in a Word document or a PowerPoint that you already have in a worksheet, don't recreate the data. Instead, insert the worksheet as an object into the document to be shared. Don't want to share all the document in the workbook? Fine. You can automatically copy column information from one sheet to another, or even from one book to another, or you can create a custom view. The end audience will only see the active view of the active worksheet. You just need to make sure…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.