HOT
blank

Excel Charts, Infographics & Data Visualization Masterclass

Office Productivity

Rating4.7
Enroll Now

Excel Charts, Infographics & Data Visualization Masterclass, available at $79.99, has an average rating of 4.7, with 85 lectures, 4 quizzes, based on 1089 reviews, and has 5719 subscribers.

You will learn about Create 50+ Powerful Unique Charts, Graphs and Infographics that communicate your information in the best manner Learn Infographics in Excel that you'll not find in ANY other Excel course, guaranteed Learn next-level dynamic interactive charts with the help of form controls and formulas, and a ton of real-life examples. Improve your graphs with conditional formatting, custom number formatting, and shapes. Master Dynamic Charts and understand When, Why and How to use them Learn from a Best-Selling Instructor with over 22 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school Learn the most current version of Microsoft Excel 365 LIFETIME Access to Project Files, Quizzes, Homework Exercises and 1-on-1 Support This course is ideal for individuals who are Excel users who wants to learn how to create Excel Charts or Students with a willingness for learning or Business Professionals + Entrepreneurs It is particularly useful for Excel users who wants to learn how to create Excel Charts or Students with a willingness for learning or Business Professionals + Entrepreneurs.

Enroll now: Excel Charts, Infographics & Data Visualization Masterclass

Summary

Title: Excel Charts, Infographics & Data Visualization Masterclass

Price: $79.99

Average Rating: 4.7

Number of Lectures: 85

Number of Quizzes: 4

Number of Published Lectures: 85

Number of Published Quizzes: 4

Number of Curriculum Items: 89

Number of Published Curriculum Objects: 89

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

  • Create 50+ Powerful Unique Charts, Graphs and Infographics that communicate your information in the best manner
  • Learn Infographics in Excel that you'll not find in ANY other Excel course, guaranteed
  • Learn next-level dynamic interactive charts with the help of form controls and formulas, and a ton of real-life examples.
  • Improve your graphs with conditional formatting, custom number formatting, and shapes.
  • Master Dynamic Charts and understand When, Why and How to use them
  • Learn from a Best-Selling Instructor with over 22 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
  • Learn the most current version of Microsoft Excel 365
  • LIFETIME Access to Project Files, Quizzes, Homework Exercises and 1-on-1 Support

Who Should Attend

  • Excel users who wants to learn how to create Excel Charts
  • Students with a willingness for learning
  • Business Professionals + Entrepreneurs

Target Audiences

  • Excel users who wants to learn how to create Excel Charts
  • Students with a willingness for learning
  • Business Professionals + Entrepreneurs

COMPLETELY REDONE ON 2024 WITH NEW VIDEOS!

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Dynamic Charts? What if you could learn how to make designer-quality Excel Graphs and Infographics in a few hours?

Data visualization is a powerful tool for communicating information. Excel charts are an efficient means to visualize the data to convey the results. In addition to the chart types that are available in Excel, some application charts are popular and widely used. In this course, you will learn about these advanced charts and how you can create them in Excel.

Hello, and welcome to Microsoft Excel Charts, Infographics, and Data Visualization Masterclass Course!

My name is Andreas, and I’ll be your instructor through this trip of knowledge. I’m a full-time teacher and have my computer learning school for over 20 years. I’m a Microsoft Certified Expert and I now teach students in over a hundred and fifty countries.

This course will guide you through Excel’s data visualization features from shapes to conditional formatting to charts. I include several realistic case studies so you can see how a business question can turn into a chart or dashboard.

  • We’ll start by why and how we visualize data.

  • Then I’ll walk you through the charting techniques to create and modify a chart quickly and easily.

  • After that, we will chop up the defaults of Excel charts with some ninja skills to use what Excel does have and create powerhouse visualizations.

  • Once we’ve mastered the basics, I’ll walk you through all the tools to improve your graphs with conditional formatting, custom number formatting, and shapes.

  • The next section is about infographics with excel. Infographics are stunning graphic visual representations of information, which are intended to present data quickly and clearly. You will be shocked at how easy you can add great-looking infographics to an Excel worksheet.

  • Then we’ll dive into the real meat of the course, the section with custom build advanced charts. In this section, I’ll make you a data visualization expert!

  • Finally, I’ll walk you through the next-level dynamic interactive charts with the help of form controls and formulas, and a ton of real-life examples.

Once you complete every section, you’ll have quizzes and exercisesto solve and fully understand the theory.

If you want to study offline, I have over 50 pages of documentation, and a detailed table of contents, so you can easily find anything in the course.

You are going to get access to over 50 examples and files that apply to your work. You can immediately download and use them along with the code-free version, so you can follow along with me.

So, if you are a professional looking to become more efficient at building excel reports and dashboards, sign up today for immediate lifetime access to over 7 hours of high-quality video content, downloadable project files, quizzes and homework exercises, and one on one support.

And by the way, at the end of the course don’t forget to print out the certificate of completion.

If you’re not 100% satisfied there is a 30-day money-back guarantee!

Now, don’t just take my word for it. Check out what my past students had to say about my courses.

Enroll now, and make your reports look amazing!

Thank you, and I’ll see you inside!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview – Setting Expectations

Lecture 2: DOWNLOAD THE PROJECT FILES (& Notes for New Students)

Lecture 3: Why do we Visualize Data?

Lecture 4: How do we Visualize Data?

Chapter 2: Charting Techniques

Lecture 1: Making the Right Chart with the 4-step Process

Lecture 2: Introducing Excel Charts

Lecture 3: Introducing Charting Techniques

Lecture 4: Identify different Chart Elements

Lecture 5: Deal with Empty and Hidden Cells

Lecture 6: Camera Tool

Lecture 7: Charts with Tables

Lecture 8: Sharing Charts

Chapter 3: Mastering Basic Charts

Lecture 1: Introduction

Lecture 2: Line Chart: Multiple Lines

Lecture 3: Column Chart with Upper and Lower Limits

Lecture 4: (NEW 2024) Pies and Doughnuts

Lecture 5: (NEW 2024) Area Charts

Lecture 6: (NEW 2024) Floating Bar Chart

Lecture 7: (NEW 2024) Geospatial Charts (Office 365)

Lecture 8: DEMO: Emphasizing & Mark Significant Events

Lecture 9: TreeMap or Hierarchy Chart (Office 365 / Excel 2016+)

Lecture 10: Sunburst or Hierarchy Chart (Office 365 / Excel 2016+)

Lecture 11: Histogram Chart (Office 365 / Excel 2016+)

Lecture 12: Box and Whisker Chart (Office 365 / Excel 2016+)

Lecture 13: Pareto Chart (Office 365 / Excel 2016+)

Lecture 14: Waterfall Chart (Office 365 / Excel 2016+)

Lecture 15: Funnel Chart (Office 365 / Excel 2016+)

Lecture 16: Map Charts based on Geographic Data (Office 365 / Excel 2016+)

Lecture 17: Sparklines and Win/Loss Charts

Chapter 4: Essential Functions & Advanced Charting Techniques

Lecture 1: Identifying the Difference between a Formula and a Function

Lecture 2: Relative vs Absolute Cell Reference

Lecture 3: Commonly Used Functions – SUM, MAX, MIN and AVERAGE

Lecture 4: IF and NESTED IF Formulas

Lecture 5: Advanced Chart Formatting Options

Lecture 6: Advanced Charting Techniques

Lecture 7: Advanced Custom Number Formatting

Chapter 5: Visualizing with Conditional Formatting, Custom Number Formats and Shapes

Lecture 1: Introduction

Lecture 2: (NEW 2024) Trend-based Conditional Formats

Lecture 3: (NEW 2024) Value-based Conditional Formats

Lecture 4: Small Multiples

Lecture 5: Mini In-Cell Charts (using REPT Function)

Lecture 6: Representing trends with Icon Sets, Data Bars and Symbols

Lecture 7: Pictograph

Lecture 8: Comparisons and Data Bars (with Conditional Formatting)

Lecture 9: Heat Map with Color-Scales

Lecture 10: Chart Up and Down Arrow Symbols

Chapter 6: Infographics & Conditional Formatting Charts

Lecture 1: Introduction

Lecture 2: People Graph

Lecture 3: Progress Doughnut Chart

Lecture 4: Tube Chart

Lecture 5: 3D Donut Chart

Lecture 6: Dynamic Overlay Custom Image Chart

Lecture 7: Waffle Charts for KPIs (Better than Pie Charts)

Lecture 8: PROJECT: Dynamic Heat Map using Scroll Bar & Formulas

Chapter 7: Next Level Custom Advanced Charts

Lecture 1: Introduction

Lecture 2: Dynamic Line Chart with MAX and MIN Dots

Lecture 3: Speedometer-Gauge Chart

Lecture 4: Bullet Graph

Lecture 5: TOP and BOTTOM Ranking Chart

Lecture 6: Dynamic Chart with Drop-Down Lists and Filters

Lecture 7: Side‐by‐Side Time Comparisons (Panel Chart)

Lecture 8: Lollipop, Dot Plot or Dumbbell Chart

Lecture 9: Timeline-Milestone Chart

Lecture 10: Creating Actual vs Target Chart

Lecture 11: Gantt Chart

Lecture 12: BurnDown Chart

Lecture 13: Tornado Chart

Lecture 14: Frequency Distribution Chart (Histogram)

Lecture 15: (NEW 2024) Interactive Visualizations & Maps using Macros

Lecture 16: (ADVANCED) Animated Chart using VBA

Lecture 17: (ADVANCED) Rollover Dynamic On-Demand Chart

Chapter 8: Interactive Charts with Form Controls

Lecture 1: Introduction

Lecture 2: Interactive Chart with Drop_down Lists (Combo Box)

Lecture 3: Dynamic Chart with Option Buttons

Lecture 4: Dynamic Combo Chart with Check Box

Lecture 5: Dynamic Column chart: Change Countries using List Box

Lecture 6: Interactive Line Chart with Scroll Bar

Chapter 9: Traffic Lights Dashboard (RAG Indicator)

Lecture 1: Part 1: Start designing our dashboard

Lecture 2: Part 2: Using Nested IF formulas & AVERAGE for our calculations

Lecture 3: Part 3: Designing the traffic lights (Camera Tool)

Lecture 4: Part 4: Final Touches

Chapter 10: BONUS SECTION

Lecture 1: SPECIAL BONUS: Discover Exciting Offers!

Lecture 2: BONUS TUTORIAL: Useful Keyboard Shortcuts and Tips

Lecture 3: BONUS TUTORIAL: Introduction to Excel 2019

Lecture 4: 3 unknown methods to select an Excel Data Range

Instructors

Rating Distribution

  • 1 stars: 7 votes
  • 2 stars: 14 votes
  • 3 stars: 43 votes
  • 4 stars: 120 votes
  • 5 stars: 905 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

CreateStudio 2D Animation and 2D Animation Marketing Videos