From the course: Access 2019: Building Dashboards for Excel
Make Excel data entry more visual
From the course: Access 2019: Building Dashboards for Excel
Make Excel data entry more visual
- [Robin] This course is meant to show you how to expand the reporting capabilities and the routine steps you do in Excel today using Access to build what we commonly know as dashboards in Excel. I'll show you how to build queries that include your functions so that every time you have new data, you're not rebuilding functions. I'll show you how to include total and aggregate queries. I'll show you how to link that data directly to Excel so it stays in real time, and I'll show you how to refresh options so that your users don't have to know the intricacies of refresh, but can work with your file as you intended. I'll show you how to build interactive slicers that filer your data, I'll show you how to build common macros that make your file even easier to work with. Hi, I'm Robin Hunt. Let's get started building dashboards using your Access data in Excel.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.