Excel 2013 - Excel Dashboard

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