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!
Excellence in Excel Create a dynamic block chart in Excel
File Size :
1.21 GB
Total length :
1h 25m


Nicky Wong


Last update




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.

Excellence in Excel Create a dynamic block chart in Excel


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!


Excel, create by Doing! Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool? Do you want to create those cool looking infographic block charts? Do you want to know a more impressive way to display data professionally?Do you want to see instantly the most value information by using a graph? Do you struggle with too much facts and tool less visuals?If any of these are a yes, than this course is for you!This course will teach you how to use Excel functions and create a useful block chart. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.This course is active, and you have to do the exercises and follow along.Yes you have to do something! I truly want to do it! Learning is 50% of the success! The other 50% is taking the necessary action to master what you learn. I will show you what I do and how you need to do it step by step. And I give you a challenge ACTION EXERCISE to challenge you to take action!Why should I take this course? Your competitor has a bigger course!I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.I never succeeded in Excel, is this course suitable for me?Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!Just check it and test it out for a month!To make it even better, I offer this course as 30 day money back. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.Alright winner, it is time to take action! Click on “Take this course” and start making great pieces of Excel Furniture!


Section 1: Welcome

Lecture 1 What will you learn in this course!

Lecture 2 Download the Excel file with Raw Data!

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

New Courses

Scroll to Top