Excel Data Visualization Techniques

Learn how to use Excel for Data Visualization and Business Intelligence

What you'll learn
Work with datasets to create an interactive Excel Dashboard with pivot tables, where charts and graphs are updated automatically in an easy to view display.
Understand how to apply your knowledge of Microsoft Excel features for data visualizations
Create your own portfolio piece to showcase your skills with Microsoft Excel
Learn how to explain your visualizations, including reports, dashboards, and KPIs
Requirements
Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365/Online
Access to an Internet Connection
Data Samples (Optional)
Suitable for beginners of Data Visualizations
Basic Excel experience is required
Description
In today's modern world, individuals and corporations are exposed to data and need to know how to use it to their benefit. Data can provide answers to old problems or predictions of new situations. This course will provide the essential skills needed to successfully create data visualizations, simple and complex in nature. In Excel Data Visualization Techniques, we will walk you through common charting techniques to assemble reports, dashboards, and KPIs. Many of the skills necessary to graduate from Excel to enterprise tools including Microsoft Power BI Desktop and Microsoft Power BI Services  as well as Tableau Desktop, Server, and Data Prep are covered in this hands-on, interactive class.By the time you finish this course, you’ll learn to identify trends, navigate large data sets, and streamline data into visual representations in Excel. Topics include:Data Visualization Principles, including Reports, Dashboards, and KPIsTables and HeatmapsBar and Column ChartsGantt ChartsHistogram and Pareto ChartsBox and Whisker Plot ChartsTree maps and SunburstLine Charts (Time Series) & SparklineArea & Waterfall ChartsScatter Plots & RegressionBubble ChartsGeospatial MapsPivot Tables & DashboardsAt the conclusion of each unit, you’ll be able to practice these skills taught using an extended exercise along with various quizzes. When you finish this course, you will be able to build business intelligence deliverables that maximize data visualization.

Overview

Section 1: Course Introduction

Lecture 1 Welcome

Lecture 2 Why Data Visualization?

Lecture 3 Course Principles, Structure, & Outline

Lecture 4 Course Portfolio Project Overview

Lecture 5 Learning about Data Visualization Datasets

Section 2: Visualization Design Principles

Lecture 6 Introduction to Data Visualization Design Principles

Lecture 7 Visualization Anatomy

Lecture 8 Visualization Design Principles

Section 3: Two Way Tables & Heat Maps

Lecture 9 Introduction Two Way Tables & Heat Maps in Microsoft Excel

Lecture 10 Concepts: Two Way Tables & Heat Maps

Lecture 11 Two Way Tables Tutorial

Lecture 12 Heat Maps Tutorial

Lecture 13 Course Assignment for Two Way Tables & Heat Maps

Section 4: Bar & Column Charts

Lecture 14 Introduction to Bar & Column Charts in Microsoft Excel

Lecture 15 Concepts: Bar & Column Charts

Lecture 16 Bar Charts Tutorial

Lecture 17 Column Charts Tutorial

Lecture 18 Course Assignment: Bar & Column Charts

Section 5: Gantt Charts

Lecture 19 Introduction to Gannt Charts

Lecture 20 Concepts: Gantt Charts

Lecture 21 Gantt Charts Tutorial

Lecture 22 Course Assignment: Gantt Charts

Section 6: Histograms & Pareto Charts

Lecture 23 Introduction to Histograms & Pareto Charts

Lecture 24 Concepts: Histograms & Pareto Charts

Lecture 25 Histograms Tutorial

Lecture 26 Pareto Charts Tutorial

Lecture 27 Course Assignment: Histograms & Pareto Charts

Section 7: Box & Whisker Plot Charts

Lecture 28 Introduction to Box & Whisker Plot Charts in Microsoft Excel

Lecture 29 Concepts: Box & Whisker Plot Charts

Lecture 30 Box & Whisker Plots Tutorial

Lecture 31 Course Assignment: Box & Whisker Plot Charts

Section 8: Tree Maps & Sunburst Charts

Lecture 32 Introduction to Tree Maps & Sunburst Charts

Lecture 33 Concepts: Tree Maps & Sunburst Charts

Lecture 34 Tree Maps Tutorial

Lecture 35 Sunburst Charts Tutorial

Lecture 36 Course Assignment: Tree Maps & Sunburst Charts

Section 9: Line Charts (Time Series) & Sparklines

Lecture 37 Introduction to Line Charts (Time Series) & Sparklines

Lecture 38 Concepts: Line Charts (Time Series) & Sparklines

Lecture 39 Line (Time-Series) Charts Tutorial

Lecture 40 Sparklines Tutorial

Lecture 41 Course Assignment: Line Charts (Time Series) & Sparklines

Section 10: Area & Waterfall Charts

Lecture 42 Introduction to Area & Waterfall Charts

Lecture 43 Concepts: Area & Waterfall Charts

Lecture 44 Area Charts Tutorial

Lecture 45 Waterfall Charts Tutorial

Lecture 46 Course Assignment: Area & Waterfall Charts

Section 11: Scatter Plots & Regression

Lecture 47 Introduction to Scatter Plots & Regression

Lecture 48 Concepts: Scatter Plots & Regression

Lecture 49 Scatter Plots & Regressions Linear Tutorial

Lecture 50 Scatter Plots & Regressions Nonlinear Tutorial

Lecture 51 Course Assignment: Scatter Plots & Regression

Section 12: Bubble Charts

Lecture 52 Introduction to Bubble Charts

Lecture 53 Concepts: Bubble Charts

Lecture 54 Bubble Charts Tutorial

Lecture 55 Course Assignment: Bubble Charts

Section 13: Geospatial Maps

Lecture 56 Introduction to Geospatial Maps

Lecture 57 Concepts: Geospatial Maps

Lecture 58 Geospatial Maps Tutorial

Lecture 59 Course Assignment: Geospatial Maps

Section 14: Pivot Tables & Dashboards

Lecture 60 Introduction: Pivot Tables & Dashboards

Lecture 61 Concepts: Pivot Tables & Dashboards

Lecture 62 Course Project Walkthrough: Making & Working with Pivot Tables

Lecture 63 Course Project Walkthrough: Creating Visualizations from Pivot Tables

Lecture 64 Course Project Walkthrough:: Adding Slicers & Timelines to Pivot Tables

Lecture 65 Course Project Walkthrough: Weaving it all together

Section 15: Course Wrap-Up

Lecture 66 Instructor's Final Message

Beginners who want to work with large data sets in Excel.,Professionals users looking to learn how to leverage data as an analysis tool.,Learners who want to expand their portfolio and have a real example of their work to prospective employers.,For learners who are seeking a well organized, structured, straight-to-the-point course.,Learners who are tasked with making visualizations of data by creating visual representations like charts and graphs.,Professionals looking to become more confident in Excel.,Students who want a structured, engaging, fun and useful Excel course.