Excel Dashboard Masterclass -From Zero to Hero

Excel Dashboard Masterclass -From Zero to Hero, available at $64.99, has an average rating of 4.4, with 30 lectures, based on 49 reviews, and has 4348 subscribers.

You will learn about Learn the Basics of Creating a Professional Dashboard and Reports from Scratch The Essentials of Creating a Good Dashboard. All the Nuts and Bolts and finally their Integration to create final Reports and Dashboards. Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data in a more meaningful way. Learn the art of data visualization to represent cumbersome data in graphical format for decision making. This course is ideal for individuals who are This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis. or Anyone who would like to take his Excel Skills to the next level. or Anyone who is into MIS, Data Analytics and Database Management System or Anyone with lots of Enthusiasm to learn new skill It is particularly useful for This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis. or Anyone who would like to take his Excel Skills to the next level. or Anyone who is into MIS, Data Analytics and Database Management System or Anyone with lots of Enthusiasm to learn new skill.

Enroll now: Excel Dashboard Masterclass -From Zero to Hero

Summary

Title: Excel Dashboard Masterclass -From Zero to Hero

Price: $64.99

Average Rating: 4.4

Number of Lectures: 30

Number of Published Lectures: 30

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the Basics of Creating a Professional Dashboard and Reports from Scratch
The Essentials of Creating a Good Dashboard.
All the Nuts and Bolts and finally their Integration to create final Reports and Dashboards.
Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data in a more meaningful way.
Learn the art of data visualization to represent cumbersome data in graphical format for decision making.

Who Should Attend

This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis.
Anyone who would like to take his Excel Skills to the next level.
Anyone who is into MIS, Data Analytics and Database Management System
Anyone with lots of Enthusiasm to learn new skill

Target Audiences

This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis.
Anyone who would like to take his Excel Skills to the next level.
Anyone who is into MIS, Data Analytics and Database Management System
Anyone with lots of Enthusiasm to learn new skill

This course is for all Excel users who wish to learn how to create powerful interactive dashboards right from the Basics to putting everything together. This course will teach you to turn your Excel data into powerful tables, graphs, visuals and dashboards.

Highlights:

• Learn from Practical Video tutorials and ample of downloadable resources.

• Understand the goals of data visualization and dashboard building.

• Learn the basics of conditional formatting and the key aspects of it for dashboard building.

• Review the Excel logic functions like IF, AND, OR and using them in your dashboards,

• Start by building bar charts, column charts, pie charts and line charts to display your data.

• Learn more complex charts like scatter plots, combination charts for data visualization and decision making.

• Make your dashboards more interactive with the MATCH () and INDEX () functions.

• Leverage pivot tables within your dashboard to add even more interactivity.

• All in all learn the art of dashboard creation right from scratch to show off your large cumbersome data in a more meaningful form.

So What are you waiting for ? Jump right into the course and Take your Excel Skills to a whole new level.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: FAQs

Chapter 2: The Art of Formatting Data

Lecture 1: Conditional Formatting – Highlighting Cells

Lecture 2: Conditional Formatting – Data Bars

Lecture 3: Conditional Formatting – Icon Sets

Lecture 4: Conditional Formatting – Colour Scales

Lecture 5: Using Logical Functions

Lecture 6: Conditional Formatting Using Logical Functions

Chapter 3: Basic Charting for Dashboards

Lecture 1: Bar and Column Chart

Lecture 2: Line and Markers

Lecture 3: Pie Charts

Lecture 4: Area Chart

Lecture 5: Sunburst and Tree Map Charts (MS Excel 2016)

Lecture 6: Combo Charts

Lecture 7: Scatterplots

Lecture 8: Sparklines

Lecture 9: Bullet Charts

Lecture 10: Waterfall Charts (MS Excel 2016)

Chapter 4: The Art of Using Pivot Tables

Lecture 1: Introduction to Pivot Tables

Lecture 2: Formatting using Conditional Formatting

Lecture 3: Filters and Using Slicers

Lecture 4: GETPIVOTDATA()

Lecture 5: Pivot Charts

Chapter 5: Making Dashboards Dynamic

Lecture 1: VLOOKUP () and HLOOKUP()

Lecture 2: Using MATCH and INDEX Function

Lecture 3: Using Data Validation

Chapter 6: Project

Lecture 1: Things to Know Before we Begin

Lecture 2: Project 1: Dropdown Chart

Lecture 3: Project – Putting Everything Together Part 1

Lecture 4: Project- Putting Everything Together Part 2

Instructors

The Dronaachaarya
Excel for Excellence

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 5 votes
4 stars: 11 votes
5 stars: 31 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu