Microsoft Excel Dashboard Infographics Masterclass Volume 1

Name: Microsoft Excel Dashboard Infographics Masterclass Volume 1
Rating: 4.4 (311 reviews)

Learn the Art of converting your Dashboards and Charts into Creative,Innovative and Professional Looking Infographics.

Created bySuhas Dakhole

Last updated 11/2018

English

What you'll learn

Taking this course will be the best decision you will make as you will not only take your MS Excel Skills to a different level but also you will be an expert in creating attention-grabbing MS Excel infographics that you can use in your next presentation, your website or your social media campaign or anywhere you want.

Course content

1 section • 29 lectures • 6h 8m total length

Introduction to the Course4:08
KPI Chart16:52
Learn to design a KPI chart in a Microsoft Excel dashboard, using color coding, numbers, and range-based formatting to visualize positive and negative values.
Project Gantt Chart14:05
Create a project gantt chart in Excel by mapping each activity's status with an IF formula, calculating days, and applying conditional formatting to show complete and incomplete tasks.
Capsule Chart / Pharma Chart9:29
Tornado Chart14:03
Target Vs Achieved Chart14:52
Design a target vs achieved chart in Excel by preparing data, creating a stacked column chart with a secondary axis, and applying formatting, data labels, and a scrollable employee selector.
Dynamic Progress Chart13:39
Pyramid Chart7:16
Traffic Signal Chart23:09
Lollypop Chart8:02
Moving Trophy Chart14:27
Learn to design a moving trophy chart in an Excel dashboard by selecting data, moving images, and building a clear, global infographic.
Spiders Web Chart8:55
Validation Chart6:30
Star Performer Chart16:09
Design a star rating dashboard in Excel to visualize seven employees' performance as a 1–5 star scale, with formatting tips and steps to convert the chart into a picture.
Dynamic Cylinder Chart15:15
KPI Cylinders Chart21:07
Design a KPI cylinder chart in Excel to visualize service level, sales conversion, operational efficiency, net promotions, and first call resolution. Prepare supporting data and convert to cylinders.
Circle Chart11:57
Human Chart20:37
Using Timeline for Data Presentation8:26
Target Chart21:38
learn to build a target chart in Excel for dashboards, including preparing data, inserting a chart, and formatting visuals to create compelling infographics.
Balloon Chart10:00
Discover how to create balloon charts in Excel dashboards, adjust colors, labels, and arrangement, and visualize data with balloon-sized markers.
Population Chart17:02
Bike Race Chart13:27
Project Milestone Chart12:01
Battery Cell Chart14:22
Design and build a battery cell chart in Excel, exploring multiple methods to visualize battery life, customize with labels, and set min and max values.
Heatmap Chart4:35
Create a heatmap chart in Excel using green, amber, and yellow color scales to visualize performance against a target and reveal distribution across data.
Speedometer Chart15:46
Flight Chart10:12
Learn to build a flight chart in Excel by creating a line with markers chart, adding an orange target line, transforming markers to airplane icons, and styling with sky fill.
Congratulations0:49

Requirements

Basic Knowledge of Ms Excel
A PC with MS Excel 2010 or Higher Version Installed
A lots of Enthusiasm

Description

Did you know you could create amazing Professional Looking Infographics using Microsoft Excel? Are you Excited to explore the power of Microsoft Excel to create beautiful Visual and dynamic Infographics to make your Dashboards look smarter and be appreciated for your data Visualization Skills? If yes, then you’re in the right place - and I am happy to have you here!

If you are in, then we're excited to announce a FAST-PACED, HIGH-VALUE COURSE that'll help you accomplish these goals!

--------------------------------------------------------------------------------------------------------------------

What are Infographics?

Infographics are graphic visual representations of Information, data or Knowledge to present information quickly and clearly.

Why should you create them?

To Grab Your Target Audience's Attention

People are naturally drawn towards graphical elements which includes facts, stats, data and figures. Now, combine graphical elements with motion elements and you have a product which is compelling enough to grab eyeballs from the right audience.

Trend and Pattern Analysis

Improve cognition by utilizing graphics to enhance the human visual system’s ability to see patterns and trends.

To Position Yourself As An Expert

Animated infographics make use of charts, graphs, and other relevant information. This signifies the amount of research and efforts the creator poured in to produce content that is useful and visually appealing. This will not only get the eyeballs rolling with your Presentation Style but will get you the appreciation of your audience establishing you as an Expert.

Who this course is for:

This course is meant for students who wish to create beautiful animated infographics using MS Excel for Data Visualization and Analysis.
This course is also meant for Windows PC users who wish to do more with MS Excel, than just creating dashboards and data tables.
Anyone Who Wants To Create MS Excel Infographics To Share Their Ideas