Course details

This course will help you create wonderful dynamic, interactive dashboards using various excel tools. These dashboards also helps in managing huge data. It helps to convert such a huge and unmanageable data into a simple and user friendly view. If you want to create beautiful reports in Excel, then you need to know how to create impressive, interactive, and easy to read Dashboards. In this self paced video course you'll learn how to build Excel Dashboard reports from the ground up using just Excel. No other software is required. Find out how to use this powerful tool for business intelligence and explore the details of data trending and relationships, creating data visualizations, and more. This course is ideal for any person wanting to learn Excel, students, people on job or doing business. What needed is a basic knowledge of excel. In this course on excel dashboard, we will be covering the following modules:

  • Introduction to Excel Dashboard
  • Excel Functions
  • Creating Basic Charts
  • Learning Pivot Table, Pivot Chart and Slicer
  • Using Form Controls
  • Basic Macros
  • Assigning Macros to Buttons to Navigate and Dashboard
Updated on 30 December, 2017
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or