HOT
blank

Excel 2019 – Data Visualization With Charts and Dashboards

Office Productivity

Rating3.9
Enroll Now

Excel 2019 – Data Visualization With Charts and Dashboards, available at $44.99, has an average rating of 3.92, with 50 lectures, 2 quizzes, based on 6 reviews, and has 133 subscribers.

You will learn about Understand WHEN, WHY, and HOW to use Different chart types in Excel 2022 Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and etc. How to Design KPI Dashboards in Excel 2019 Master unique tips, tools and case studies that you won't find in ANY other Excel course Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support Build 10+ Excel projects designed to take your data visualization skills to the next level This course is ideal for individuals who are Anyone looking to create beautiful and effective Data Visualizations in Excel or Excel users who have basic skills but want to master advanced charts, graphs & dashboards or Students looking for an engaging, hands-on, and highly interactive approach to training or Anyone looking to pursue a career in Data Analysis or Business Intelligence It is particularly useful for Anyone looking to create beautiful and effective Data Visualizations in Excel or Excel users who have basic skills but want to master advanced charts, graphs & dashboards or Students looking for an engaging, hands-on, and highly interactive approach to training or Anyone looking to pursue a career in Data Analysis or Business Intelligence.

Enroll now: Excel 2019 – Data Visualization With Charts and Dashboards

Summary

Title: Excel 2019 – Data Visualization With Charts and Dashboards

Price: $44.99

Average Rating: 3.92

Number of Lectures: 50

Number of Quizzes: 2

Number of Published Lectures: 50

Number of Published Quizzes: 2

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: ₹3,299

Quality Status: approved

Status: Live

What You Will Learn

  • Understand WHEN, WHY, and HOW to use Different chart types in Excel 2022
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and etc.
  • How to Design KPI Dashboards in Excel 2019
  • Master unique tips, tools and case studies that you won't find in ANY other Excel course
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Build 10+ Excel projects designed to take your data visualization skills to the next level

Who Should Attend

  • Anyone looking to create beautiful and effective Data Visualizations in Excel
  • Excel users who have basic skills but want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training
  • Anyone looking to pursue a career in Data Analysis or Business Intelligence

Target Audiences

  • Anyone looking to create beautiful and effective Data Visualizations in Excel
  • Excel users who have basic skills but want to master advanced charts, graphs & dashboards
  • Students looking for an engaging, hands-on, and highly interactive approach to training
  • Anyone looking to pursue a career in Data Analysis or Business Intelligence

Description

FULL COURSE DESCRIPTION:

Ask people what comes to mind when they think of Excel, and odds are they’ll say “spreadsheets“. The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts — and I’m here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel’s latest data visualization tools and techniques. I’ll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We’ll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2019, including:

  • Bar & Column charts

  • Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

  • Line charts & trend lines

  • Area charts

  • Pies & Donuts

  • Scatter plots & Bubble charts

  • Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

  • Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

  • Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

  • Radar & Stock charts

  • Heat maps, 3-D Surface & contour charts

  • Chloropleths & Geospatial maps

  • Custom combo charts & graphs

  • Sparklines

  • And more…

__________

We’ll cover advanced Excel data viz topics that you won’t find anywhere else, including:

  • Custom image overlay charts

  • Automation with named ranges and OFFSET/COUNTA functions

  • Scroll & Zoom functionality with Excel form controls

  • Animated charts to visualize changes over time

  • Dynamic, custom Excel dashboards

  • Value-based chart formatting

  • Custom gauge charts & pacing charts

  • Grid visuals using Excel array formulas

Whether you’re looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.

See you there!

-Srinivas Reddy (Founder,Excel Map)

__________

*NOTE: Full course includes downloadable resourcesand Excel project files,homework andcourse quizzes,lifetime access and a30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Introduction

Lecture 2: READ ME: Important Notes for New Students

Chapter 2: Data Visualization Best Practices

Lecture 1: Key Visualization Principles and The 10 – Second Rule

Lecture 2: Good, Bad and Ugly Charts for Data Visualization

Lecture 3: Key Questions for Effective Data Visualization

Chapter 3: Excel Chart Formatting and Customization

Lecture 1: Customizing Chart Elements, Layouts & Styles

Lecture 2: Configuring Chart Formats

Lecture 3: Changing Chart Types & Adding a Secondary Axis

Lecture 4: Creating & Applying Custom Chart Templates

Chapter 4: Mastering Basic Excel Charts & Graphs

Lecture 1: Excel Bar & Column Charts

Lecture 2: HOMEWORK: Bar & Column Charts

Lecture 3: Excel Histograms & Pareto Charts

Lecture 4: HOMEWORK: Histogram & Pareto Charts

Lecture 5: Excel Line Charts & Trend Lines

Lecture 6: HOMEWORK: Line Charts and Trend Lines

Lecture 7: Excel Area Charts

Lecture 8: HOMEWORK: Area Charts

Lecture 9: Excel Pie Charts and Doughnut Charts

Lecture 10: Creating Race Tracks in Excel

Lecture 11: HOMEWORK: Pies and Doughnuts Charts and Race Tracks

Lecture 12: Excel Scatter Plots

Lecture 13: Excel Bubble Charts

Lecture 14: HOMEWORK: Scatter Plots & Bubble Charts

Lecture 15: Excel Box and Whisker Charts

Lecture 16: HOMEWORK: Box & Whisker Charts

Lecture 17: Excel Tree Maps & Sunburst Charts

Lecture 18: HOMEWORK: Tree Maps & Sunburst Charts

Lecture 19: Excel Waterfall Charts

Lecture 20: Excel Funnel Charts

Lecture 21: HOMEWORK: Waterfall & Funnel Charts

Lecture 22: Excel Radar Charts

Lecture 23: HOMEWORK: Excel Radar Charts

Chapter 5: Creating Dashboards With Advanced Charts

Lecture 1: Setting Expectations

Lecture 2: Creating Custom Image Overlay Charts

Lecture 3: Using Binary Values to Highlight Time Periods

Lecture 4: Automating Charts with Name Ranges (OFFSET & COUNTA)

Lecture 5: Creating Dynamic Drop Down Charts using OFFSET & MATCH Functions

Lecture 6: Adding Scroll & Zoom Functionality Using Form Controls

Chapter 6: Visualizing & Analyzing Data with Excel Pivot Charts

Lecture 1: Introduction to Excel Pivot Charts

Lecture 2: Designing Column Charts in Pivot Table

Lecture 3: Clustered Bar Charts in Pivot Table

Lecture 4: Pie & Doughnut Charts in Pivot Table

Lecture 5: Preventing Charts from Resizing with Cells

Lecture 6: Changing Pivot Chart Types & Swapping

Lecture 7: Stacked Area Chart in Pivot Table

Lecture 8: Customizing Pivot Chart Layouts & Styles

Lecture 9: Move Pivot Charts to New Excel worksheets

Lecture 10: Applying Slicers and Timelines to Multiple Pivot Charts

Lecture 11: Building Dynamic Dashboards With Pivot Tables & Charts

Chapter 7: Wrapping Up

Lecture 1: More About the Author

Instructors

Rating Distribution

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

Amazon Seller center Creation