Home»2022»January»01»Lynda Access 2016 Building Dashboards for Excel
18:10:23
Lynda Access 2016 Building Dashboards for Excel
Included Exercise Files
Skill Level : Intermediate
Duration : 1h 52m
Language : English
Released : 2/9/2018
Size : 306,26 Mb
Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations.
Topics include:
Understanding the software limitations
Working with Access tables
Analyzing table relationships
Building queries
Exporting data for Excel
Linking to Access data from Excel
Building charts and PivotCharts in Excel
Creating macros
