Course Description

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 training, you will 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.

Prerequisites

Before attending this course, students should have experience:

• A basic working knowledge of Microsoft Office Excel

Who should Attend?

This course is intended for report designers and excel users.

Course Content

• Advanced PivotTable Features
• Power View
• Excel Chart Types
• Working with Chart Series
• Charting Techniques
• Visualizing Data with Conditional Formatting
• Visualizing Data with Sparkline
• Excel Form Controls
• Assignment