Excel
Creating a Basic Dashboard
Heads up! This course may be archived and/or unavailable.
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.
Contents:
- Introduction
- 1. Setting Up the Supporting Workbook
- 2. Creating a Dashboard Worksheet
- Conclusion
Get a Reminder
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Dashboard Coordinator/Administrative Specialist $43k
Data 2 $50k
BI Universe/Reports/Dashboard Developer $64k
Excel Reporting Developer $68k
Techniques (General) Engineer $70k
Adjunct Professor of Digital Media Techniques and Computer Graphic Design $70k
Excel/Access DTS Developers $78k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Data Analyst, Data Warehousing $93k
Data Administrator / Data Modeler $108k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
