Dashboarding in Excel
How to build amazing dashboards in Excel and the Jet Dashboard Builder
Want to learn how to build dashboards? How can you build effective dashboards like this?
This introductory course will teach you the basics, and some advanced techniques, to build informative dashboards for your company.
Start with some basic concepts and terminology, then move into building your first chart. Our instructor will provide an easy to follow example. Follow along as he develops a dashboard, then gives you a similar project to work on.
In addition, learn about the Jet Dashboard Builder in the second half of the course, all at a pace that is comfortable for you.
It is recommended that you first start with the PivotTable training if you haven't previously completed it.
Your Instructor
Bryan brings to the table over 3,000 hours of training users how to use Jet and Excel. A native of Southern California, he found a new home in the Pacific Northwest where he, his wife and two children moved when he joined the Jet team in 2014.
He has a background in accounting and computer programming which has made working with Jet a perfect match.
Bryan is recommended by 4 out of 5 people that recommend things.
Course Curriculum
-
StartExample and Exercise Files
-
StartCreating our First PivotChart
-
StartContinuing our First PivotChart (3:03)
-
StartTwo More Charts (3:03)
-
StartResizing Charts
-
StartFormatting Chart Axes
-
StartAdding Data Labels (3:29)
-
StartChart Layouts, Styles and Colors (4:21)
-
StartCompiling Charts to the Dashboard (1:59)
-
StartSlicers (4:53)
-
StartTimeline Slicer (3:41)
-
StartFinishing Touches Part 1
-
StartFinishing Touches Part 2
-
StartExcel Dashboard Tips
-
StartStudent Exercise