This comprehensive training is to learn about creating a professional dashboard right from scratch using advanced excel functions.
6h 1m | 55 Videos | 15343 Views | Intermediate
Comprehensive Excel Dashboard Training:
These dashboards help to maintain huge chunks of data and also to convert dashboard data into user friendly visuals. These online tutorials are indeed self-paced and one can easily make way and learn to create out dashboards and business intelligence and understand the importance of data trending and create valuable data visualizations.
The training includes the following information:
INTRODUCTION– This section is about introduction to excel dashboards and designing of dashboards.
MANAGING DATA– here we are going to learn about database management, types of errors and data consolidation.
CHARTS– This section on charts will help you learn overview of charts, creation, linkage and formatting of charts and preparation of customized charts.
FILTERS – Under filters you will see using filters and working with advanced filters.
PIVOT TABLES – in this section you will learn preparation of Pivot tables, Pivot Layout, Design and Formatting, Advanced Pivots and MIS using Pivots
CUSTOMIZATION – Here you will learn Grouping and Ungrouping, Consolidations, Dashboard Alerts, KPI and KRA Management, Hyperlinks and Tab Designing.
DASHBOARD MACROS – Under Macros you will learn Macro Filters, Presentation view Macros, Data Updating Macros and Linking Microsoft Access.
SUMMARY – Finally you will look at the Dashboard Hints and Tricks, Excel Shortcuts and Final Dashboard Presentation.
Students from the business administration
Working professionals who go through the hectic working schedule of same repetitive work every day