LIN | Access 2019: Building Dashboards For Excel (2019 EN)

Company: Linkedin Learning
Author: Robin Hunt
Full Title: Access 2019: Building Dashboards For Excel
Year: 2019
Language: English
Genre: Educational: Data Analysis
Skill Level: Intermediate
Price: €44.99
-
Files: MP4 (+ Exercise Files, Subtitles .SRT)
Time: 01:47:55
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps
Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz



Take your Excel and Access skills to the next level by learning how to create interactive dashboards users will find attractive and easy to use. Instructor Robin Hunt shows you how to use these two programs in combination to create queries, macros, slicers, and more. Learn how to generate charts, graphs, and other appealing data visualizations that can update in real time as the dashboards collect and display information, giving your users an experience they’ll appreciate.


Topics include:
01. How queries, forms, and reports work with tables
02. Linking data to Access
03. Building and working with queries
04. Working with SQL view
05. Exporting and linking data to Excel
06. Charting and pivots in Excel
07. Building interactive charts
08. Building Excel macros for dashboard
09. Creating macros that navigate
10. Assigning macros to buttons

Our members see more. Join us!
-------------
Our members see more. Join us!