- Examples
- Build a Dashboard
- Key Performance Indicators
- Power View Reports
- Power PivotTables & PivotCharts
- Excel PivotTables
- Advanced Excel Charts
- Interactive Controls
- Excel Charts
- Conditional Formatting
- Excel Features Create Dashboards
- Introduction
- Excel Dashboards - Home
Excel Dashboards Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
![Excel Dashboards Tutorial](/excel_dashboards/images/excel-dashboard.jpg)
Excel Dashboards Tutorial
Dashboards are popular visual displays of data, mostly comprising of charts / graphs with striking attention seeking components. There are various tools available in the market to create dashboards. If you are a Microsoft Office user with reasonably good mastery on Excel, then creating dashboards in Excel is a wise decision. This is because Microsoft has introduced several powerful features in Excel, making your job of handpng large datasets from various data sources simple and less tiresome. In this tutorial, you will learn how to use Excel features effectively in dashboards. They include features that can make a dashboard dynamic and interactive.
Audience
This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.
Once you get an understanding of the several Excel features that come handy in creating Excel dashboards, creating dashboards will become a trivial task for you.
Prerequisites
Before proceeding with this tutorial, the reader should have a prepminary understanding of Excel workbooks, Excel charts, Excel PivotTables, Excel Data Model, Excel Power PivotTables and Power PivotCharts and Excel Power View reports. All these topics are available as full-fledged tutorials in our tutorials pbrary.
Advertisements