->
Lynda - Access 2016: Building Dashboards for Excel - 636105
Lynda - Access 2016: Building Dashboards for Excel
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.


Table of Contents

  • Introduction
  • 1. Benefits of Moving to Access
  • 2. Understanding the Access Structure
  • 3. Analyzing a Table
  • 4. Building and Working with Queries
  • 5. Exporting and Linking Data to Excel
  • 6. Charting and Pivots in Excel
  • 7. Building Excel Macros for Dashboard
  • Conclusion
  • Lynda - Access 2016: Building Dashboards for Excel


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss