HOT
blank

Mastering Excel Dashboard Creation and Data Visualizations

Office Productivity

Rating4.6
Enroll Now

Mastering Excel Dashboard Creation and Data Visualizations, available at $59.99, has an average rating of 4.55, with 77 lectures, based on 209 reviews, and has 5330 subscribers.

You will learn about Learn the When, Why and how to use Excel Standard Charts Learn to create eye catching dynamic non standard Excel Charts Learn to create interactive dashboards with no coding or VBA Learn to create dashboard that track KPI's Learn to create dashboards that aid business decision and help revile insights Learn tips and tricks for approaching an Excel Dashboard project Get ideas on good and bad charting and dashboard designs This course is ideal for individuals who are Those new to creating charts in Excel or Those that want to explore the use of Visualizations in Excel or Those that want to learn to create stunning charts or Those that want to learn how to create basic interactive Dashboards or Those that want to learn to create advanced Excel Dashboards or Students looking for an engaging, hands-on, and interactive course or Those looking to skill up in Excel in an area where the skills are in high demand It is particularly useful for Those new to creating charts in Excel or Those that want to explore the use of Visualizations in Excel or Those that want to learn to create stunning charts or Those that want to learn how to create basic interactive Dashboards or Those that want to learn to create advanced Excel Dashboards or Students looking for an engaging, hands-on, and interactive course or Those looking to skill up in Excel in an area where the skills are in high demand.

Enroll now: Mastering Excel Dashboard Creation and Data Visualizations

Summary

Title: Mastering Excel Dashboard Creation and Data Visualizations

Price: $59.99

Average Rating: 4.55

Number of Lectures: 77

Number of Published Lectures: 77

Number of Curriculum Items: 77

Number of Published Curriculum Objects: 77

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

  • Learn the When, Why and how to use Excel Standard Charts
  • Learn to create eye catching dynamic non standard Excel Charts
  • Learn to create interactive dashboards with no coding or VBA
  • Learn to create dashboard that track KPI's
  • Learn to create dashboards that aid business decision and help revile insights
  • Learn tips and tricks for approaching an Excel Dashboard project
  • Get ideas on good and bad charting and dashboard designs

Who Should Attend

  • Those new to creating charts in Excel
  • Those that want to explore the use of Visualizations in Excel
  • Those that want to learn to create stunning charts
  • Those that want to learn how to create basic interactive Dashboards
  • Those that want to learn to create advanced Excel Dashboards
  • Students looking for an engaging, hands-on, and interactive course
  • Those looking to skill up in Excel in an area where the skills are in high demand

Target Audiences

  • Those new to creating charts in Excel
  • Those that want to explore the use of Visualizations in Excel
  • Those that want to learn to create stunning charts
  • Those that want to learn how to create basic interactive Dashboards
  • Those that want to learn to create advanced Excel Dashboards
  • Students looking for an engaging, hands-on, and interactive course
  • Those looking to skill up in Excel in an area where the skills are in high demand

Do you want to improve your charting and visualization skills in Excel?  Do you want to master the common and lesser well-known charts available in your spreadsheets? Would you like to be able to create non-standard visually effective Excel charts and interactive dashboards that will all KPI’s to be tracked, help aid business decisions, and reveal insights from your data?  If so then this course is the course for you.  Excel is not only an awesome tool for storing data and carrying out calculations, but it is also an amazing visualization tool from which you can design and create interactive dynamic dashboards and we are here to show you how it all works.

We will start this course by looking at the basics of charting in Excel.  You will explore ways to insert charts and formatting options.   After this, we will take a deep dive into creating the most commonly used charts such as line charts, pies charts, and columns charts.  And we will then finish the basics by looking at less common charts.

Once we have mastered the basics, you will then learn how to create dynamic non-standard visually effective charts and visualization.  You will learn advanced use functions and formulas to drive interaction and by the end of this course, you will be comfortable taking on a dashboard project from scratch.

This is a hands-on course, with workbooks to download and a lot to practice and master, giving you Excel dashboard skills that are in high demand in this growing world of data.

Course Curriculum

Chapter 1: The Basics of Charting In Excel

Lecture 1: Introduction

Lecture 2: Module 1 Introduction

Lecture 3: Inserting Charts

Lecture 4: Using Ideas

Lecture 5: Chart Ribbons

Lecture 6: Pivot Charts

Lecture 7: Charting Elements

Lecture 8: Chart Templates

Chapter 2: Principles of Data visualization

Lecture 1: Principles of Data visualization Introduction

Lecture 2: Principles of visualizations

Lecture 3: Good and Bad charts

Chapter 3: Mastering Common Charts

Lecture 1: Mastering common Charts Intro

Lecture 2: Module 3 workbook

Lecture 3: Working with Line charts and Trendlines

Lecture 4: Bar and Column Charts

Lecture 5: Working with Bar and Column Charts in Excel

Lecture 6: An introduction to Histograms

Lecture 7: Working with Histogram and Pareto Charts in Excel

Lecture 8: Area Charts

Lecture 9: Working with Area Charts in Excel

Lecture 10: Pie and Donut Charts

Lecture 11: Scatter Charts

Lecture 12: Working with Scatter Charts in Excel

Lecture 13: Working with Funnel Charts

Lecture 14: Filled Maps in Excel

Chapter 4: Mastering Less Common Charts

Lecture 1: Mastering Less Common Charts

Lecture 2: An introduction to bubble charts

Lecture 3: Bubble charts

Lecture 4: Radar charts

Lecture 5: Introducing Waterfall charts

Lecture 6: Working with Excels Waterfall charts

Lecture 7: Getting started with Waterfall charts

Lecture 8: Heat Maps and surface area charts

Lecture 9: Stock charts

Lecture 10: working with Combination charts in Excel

Lecture 11: Sparklines

Lecture 12: Tree Maps and sunbursts

Lecture 13: Box and Whisker plots

Lecture 14: Stock Image Dashboard in Excel

Chapter 5: Lets talk about Dashboards

Lecture 1: Lets talk about Dashboards Introduction

Lecture 2: What is a Dashboard

Lecture 3: Where to start when designing a dashboard

Lecture 4: Dashboard Don'ts

Lecture 5: Why use Excel

Lecture 6: Good and bad dashboard examples

Chapter 6: Creating dynamic charts

Lecture 1: Creating dynamic charts Introduction

Lecture 2: Creating a custom visual overlay

Lecture 3: Waterfall charts

Lecture 4: More waterfalls

Lecture 5: Gauge Charts

Lecture 6: More on Gauge Charts

Lecture 7: Dynamic Sales V's Budget

Lecture 8: Sales V's Budget part 2

Lecture 9: Creating Dynamic Legends

Lecture 10: Formatting based on values

Lecture 11: Dynamic formatting based on criteria

Lecture 12: How and why to fix an axis on dynamic and multiple charts

Lecture 13: Top N tables

Chapter 7: Automating interactive Charts

Lecture 1: Automating interactive Charts Introduction

Lecture 2: Automating Charts with names ranges

Lecture 3: Automating Charts with names ranges 2

Lecture 4: Dynamic ranges for subsets of data

Lecture 5: Change charting period with dropdown

Lecture 6: Cumulative totals challenge solution

Lecture 7: Charting with Vlookups and named ranges

Lecture 8: Changing charts with named ranges and vlookup

Lecture 9: Changing charts with form controls

Lecture 10: Zoom with form controls

Lecture 11: Creating Cards

Chapter 8: Building the final dashboards

Lecture 1: workbooks for this section

Lecture 2: Building the final dashboards Introduction

Lecture 3: High level dashboard

Lecture 4: Dashboard protection and finishing touches

Lecture 5: Our second dashboard

Lecture 6: The Third Dashboard

Lecture 7: Linking and other dashboard tips

Lecture 8: Course Conclusion

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 5 votes
  • 3 stars: 33 votes
  • 4 stars: 77 votes
  • 5 stars: 94 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!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Author School Visits 101: Children's Book Marketing