Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Dashboard Reporting in MS Excel

( Duration: 1 Day )

The Dashboard Reporting in MS Excel training course is designed with a practical, easy-to-learn approach towards unleashing the power of Microsoft Excel to build interactive management dashboard reports. It allows managers to step back from the details and see the key trends and relationships that drive the organisation.

By attending Dashboard Reporting in MS Excel workshop, delegates will learn to:

  • Design a dashboard for high level overview of the business
  • Use Excel’s data visualization features for KPI reporting
  • Create a functionally interactive dashboard

Advanced users of Microsoft Excel and have experience with Pivot Table, Charts and some formulas.

This Dashboard Reporting in MS Excel class is most suited for those who:

  • Need to perform data analysis and business intelligence reporting.
  • Are business analysts, reporting analysts, business intelligence executives, sales & marketing executives and project managers.

COURSE AGENDA

1

Introduction to Dashboards

  • Defining a Dashboard
  • Understanding Dashboard Design Principles
  • Designing a Dashboard
2

Preparing Dashboard Data

  • Organizing Data
  • Performing Calculations
  • Creating Range Names
3

Analyzing Dashboard Data

  • Using Conditional Formatting
  • Creating Sparklines
  • Creating Pivot Tables
  • Inserting Slicers
  • Creating Pivot Charts
  • Using Advanced Charting Techniques
4

Building Interactive Dashboard

  • Working with Worksheet Form Controls
  • Creating Dynamic Dashboards
5

Extending Functionality of Dashboards

  • Creating Automatic Commentaries
  • Protecting a Dashboard
  • Exporting a Dashboard

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X