Download Excel Dashboards Tutorial PDF

TitleExcel Dashboards Tutorial
TagsSoftware Computer Data Data Management Microsoft Excel Information Technology Management
File Size7.5 MB
Total Pages166
Document Text Contents
Page 2

Excel Dashboards

i






About the 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 handling 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 preliminary 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 library.



Copyright & Disclaimer

 Copyright 2016 by Tutorials Point (I) Pvt. Ltd.

All the content and graphics published in this e-book are the property of Tutorials Point (I)

Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republish

any contents or a part of contents of this e-book in any manner without written consent

of the publisher.

We strive to update the contents of our website and tutorials as timely and as precisely as

possible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt.

Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of our

website or its contents including this tutorial. If you discover any errors on our website or

in this tutorial, please notify us at [email protected]





mailto:[email protected]

Similer Documents