Tutorialspoint

Project - Microsoft Excel Dashboard Training

Project - Microsoft Excel Dashboard Training

Course Description

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 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 the introduction to excel dashboards and the 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.

Target Customers:

  • Commerce students
  • Students from the business administration
  • Working professionals who go through the hectic working schedule of same repetitive work every day

Prerequisites

  • Basic knowledge of excel tools and functions
  • Passion to learn and apply
Show More

Curriculum

  • Introduction to Excel Dashboard Training
    01:17
    Preview
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Project - Microsoft Excel Dashboard Training
This Course Includes
  • 5.5 hours
  • 55 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515