Included Exercise Files
Skill Level : Beginner
Duration : 1h 31m
Language : English
Released : 3/8/2017
Size : 176,23 Mb
Learn easy-to-implement techniques that can help you quickly create a visual representation of your data to inform your decision making. In this brief course, Curt Frye walks through the basics of creating a dashboard in Excel. Curt begins with a primer on using PivotTables—one of the most powerful data analysis tools in Excel. He also shares how to define conditional formats and summarize your data with sparklines and charts. Plus, he shows how to set up your dashboard worksheet, link data to cells and shapes, maximize your screen space by hiding rows, and modify the Excel program window to meet your needs.
Topics include:
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
