Access 2016 Building Dashboards for Excel

Access 2016 Building Dashboards for Excel

Robin Hunt Robin Hunt

Robin Hunt

Data junkie. Star Wars fan. Entrepreneur. [in]structor. Author CompTIA Data+. I teach Excel, Power Query, PowerBI, Database Design and SQL Querying and Data+. On a mission to build a workforce of data professionals.

发布日期: 2018年2月9日
+ 关注

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.

https://www.dhirubhai.net/learning/access-2016-building-dashboards-for-excel

Topics Include:

  • Understanding the software limitations
  • Working with Access tables
  • Analyzing table relationships
  • Building queries
  • Exporting data to Excel
  • Linking to Access data from Excel
  • Building charts and PivotCharts in Excel Creating macros


要查看或添加评论，请登录

更多精彩文章

社区洞察

其他会员也浏览了