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

Discussion in 'Information Technology' started by Kanka, Mar 28, 2020.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Likes Received:
    Trophy Points:

    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