Join Curt Frye for an in-depth discussion in this video Using the exercise files, part of Excel: Creating a Basic Dashboard.
- [Narrator] If you have a premium subscription to the lynda.com online training library, then you have access to the exercise files for this course. I downloaded the files to a folder named Exercise Files on my desktop and when I double-click, I see a folder for each of the two chapters of the course. If I want to use one of the files, I can just double-click the folder that it's contained in and then double-click the file to open it. If you don't have a premium subscription, you are more than welcome to create your own resources or just follow along.
Author
Curt Frye
Released
3/8/2017Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Setting Up the Supporting Workbook
-
Define conditional formats7m 39s
-
Define icon set formats5m 33s
-
Summarize data using charts10m 12s
-
Create sparklines5m 3s
-
2. Creating a Dashboard Worksheet
-
Sketch your dashboard layout6m 20s
-
Create and manage cell links7m 45s
-
Link to a PivotTable cell4m 59s
-
-
Conclusion
-
Next steps1m 30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using the exercise files