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 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,367 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 13
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Do you want to create those cool looking infographic block charts?
  3. Do you want to know a more impressive way to display data professionally?
  4. Do you want to see instantly the most value information by using a graph?
  5. 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!

What are the 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!

What am I going to get from this course?

  • 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.

What is the target audience?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome
02:15

Excel Course


Welcome to this course! Im excited to have you here! Excel is a wonderful tool to create powerful programs. Sadly, many people cannot grasp the true power of Excel. In this course you will learn the formula`s and functions to create practical Excel sheets and tools.


The real power of Excel is Create by Doing! I do not want to you learn a basic Excel function and let you go. I want you to understand the practical use of Excel by using just a few tools to create something that has a value of a lifetime.

2 pages

Excel Course Raw Data

In this part you can download the raw data. You will not receive the full data. Why? Because I truly want you to learn it by doing. This course is titled: Create by Doing! It is a challenge and the big question is, can you do it?

Download the Excel sheet so you have the Raw Data at hand that you need for the upcoming lectures.

Section 2: Create single block chart!
06:00

Excel Single Block Graph


In this lecture you will learn how to create a single dynamic block graph. This block graph is one of my favourites! You will learn how you can display values into blocks or visuals! If you love infographics you will understand immediately how you can use this.


The first part will be creating the values and formula`s. You will learn:

  • How to make a dropdown list
  • How to use the SUM formula
  • How to calculate percentages
  • How to give your template a proper layout with Excel color coding.
13:02

Excel Single Block Graph

In this lecture you will create the visual of the block chart. The fun part of this is that the graph is not a real chart in Excel. So we create a wonderful solution to make it display and function as a chart. In this part you will learn:

  • How to create conditional statements
  • How to use the IF function
  • How to make values react as a chart.
01:21

Excel Exercise 1


In this part have a mini exercise. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 1? This is your challenge, create an equal box as on shown in this video.

Please take action on this exercise.

You are here to maximize your learning. Research has shown that if you repeat something within the first 20 minutes of learning, it will stick longer in your mind. Besides, this is a challenge as well. Are you ready for the challenge.

09:25

Excel Exercise 1 Answers


In this part you will get the answers of mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 1 in Excel.


How did the challenge went? Was it hard or easy? Now you can double check the answer and you will see how to do this correctly.

Section 3: Create the multiple block chart
06:09

Excel Dynamic Multiple Block Chart


The Multiple block chart is a more complicated chart. You will need to become more creative and understand how to combine information with each other. The first part what you will learn is how to step up the layout properly. This is essential. Once you have this you can connect the formula`s.


In this part we will create the layout. We need to make out tab "Block chart ready" before we can continue.

08:24

Excel Dynamic Multiple Block Chart


The next part of this chart is create the Engine Room tab. If you are familair with my other course I use the term "Engine Room" or "Machine Room" to seperate the tab that is essential and should not be touched once it is in place. These tabs are always colored red as a sign not to touch it!


In the engine room tab you will create all the essential formula`s and connections. This tab should never be touched if you want to display a chart. Everything in there is connected and should be left alone.

12:02

Excel Dynamic Multiple Block Chart

In this lecture you will create the final key connection of the Multiple Block Chart. You will understand how to use the combination VLOOKUP formula. A trick that is very useful in the future and how you can make all the block respond based on the selected dropdown list. You will learn how to use:


  1. The VLOOKUP function
  2. The combination function
  3. Use the Conditional Formatting
02:07

Excel Exercise 2

In this Excel exercise you will get a challenge to create your own multiple block chart. Special points to remember:

  1. The Course and Date dropdown lists are changed in order.
  2. The Block charts are now in large blocks!

Are you ready for this challenge! If you do this exercise you will learn how to expand the possibilities on Excel!

15:45

Excel Exercise 2 Aswers

How did the challenge went? Was it hard or easy? The main reason you receive this challenge it to expand your capabilities of Excel Block charts. In this part I will show you step by step how you can do it!

This challenge was probably one of the hardest but the most useful method to expand your vision. Follow along and double check if you completed the exercise as it should.

Section 4: Thank You!
02:40
Excel Conclusions

Congratulations of completing this course. Remember that you always should continue learning and improve it. That is why I would like to hear from you! Do you want to create something new? Did you like this learning method? Just let me know!

You have learned alot of quality information and understand how to use some functions to create a practical tool. You might wonder what can I do next? This is what you can do from now on:

  1. Go and rate my course!
  2. Go ahead and tell me what you want to learn more about Excel in the discussion board!
  3. How can you use this knowledge in your daily life?
4 pages

Excel Reference sheet

You learned a lot and I truly believe you want to make sure you remember all the information as well. So here you have a reference sheet. I placed the best functions on this sheet with a very brief explainaton. Are you on a mobile phone? Do not worry! I have also a mobile format ready for you!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nicky Wong, Data Analyst, Market Researcher, Data Visualizer!

Nicky Wong is an expert in translating data into market opportunities. Data is his passion, Excel, Databases and Big Data are truly wonderful topics. As an absolute data lover and he is always looking for ways to analyze it. It started with stock market facts and now quickly turned to everything that is unique and different.

However, all the information have one primairy goal and that is "How to use this information to gain a competitive advantage". As a Market Researcher with it roots in Marketing Nicky understands that knowledge is power. Whatever you do make sure you use data at your advantage.

=====================================================================

My vision of Data and the future

=====================================================================

Why Data visualization matters!

I truly belief that Big Data is giving us all a new obstacle to overcome! Information overload is a serious challenge and with Big Data it only multiplies the issue. If you are a data miner you will know that much data has no meaning if you cannot connect any meaningful dots.

Large chunks of data, reports and tables are not effective. It is impressive to get a huge database but it is demotivating for others to read data. The biggest data trend is increasing this issue! Big Data = Information Overload x 10.

From (Digital) Information Age to the (Digital) Understanding Age

A data analyst can analyze data but the most important skill is Data Visualization! These so called "data visualizers" will develop a new skill gathering meaningful information and present it in a very understandable and effective way.

The issue is not anymore the data but the way to give meaning and communicating meaning to others. The person who can do that will have a huge advantage in the so ever growing Big Data world.

Big Data is here! Data Visualizer is on it`s way! In all of my courses I use techniques to create understandable data and present it in an impactful manner.

Ready to start learning?
Take This Course