Part V
Working with the Outside World
See a demonstration of OneDrive at www.dummies.com/extras/exceldashboardsreports and find out how you can leverage the Microsoft Office Web platform to share your reports over the web.
In this part …
Gain an understanding of some of the ways to incorporate data that does not originate in Excel.
Discover how to import data from external sources, such as Microsoft Access and SQL Server.
Dive into Power Query to automate the data transformation processes.
Understand the various methods for protecting your dashboards and reports before distributing.
Explore the different ways to distribute and present your work in a safe and effective way.
Get Excel Dashboards and Reports for Dummies, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
