# Excellence in Excel Create a dynamic block chart in Excel

Excel by creating your own dynamic block chart in Excel. Discover advance dynamic chart displaying tactics in Excel!

4.4/5

## Excellence in Excel Create a dynamic block chart in Excel

### What you’ll learn

Create a dynamic single block chart.
Create a dynamic multiple block chart
Understand how to use combined VLOOKUP criteria
Translate values into graphical charts.
Create a graph that is in reality not a graph.
Make cells correspond to specific values.
Create infographic style charts.

### Requirements

An openmind and the willingness to take action (massive action)!
Have a working Excel 2007, 2010 or 2013.
Have the willingness to become great in Excel!

### Overview

Section 1: Welcome

Lecture 1 What will you learn in this course!

Section 2: Create single block chart!

Lecture 3 Creating the formula`s for the Single Block Chart

Lecture 4 Creating the graph for the Single Block Chart

Lecture 5 Exercise Single block chart

Lecture 6 Answers Exercise Single Block Chart

Section 3: Create the multiple block chart

Lecture 7 Creating a dynamic Multiple Block Chart

Lecture 8 Creating a dynamic Multiple Block Chart, create the engine room tab

Lecture 9 Creating the combined VLOOKUP and conditional formatting of the Block Chart!

Lecture 10 Exercise Multiple block chart

Lecture 11 Answers Exercise Multiple block chart

Section 4: Thank You!

Lecture 12 Final Points

Lecture 13 Excel Reference Sheet by Udemology

Students who need to create infographic style charts.,Professionals that need to translate data into strong visual graphs.,Professionals that need Excel to improve their presentation style by using visuals.,Businessman that needs to improve their Excel skills.,Business owners that need to use Excel for better data tracking.

#### Course Information:

Udemy | English | 1h 25m | 1.21 GB
Created by: Nicky Wong

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

Scroll to Top