Excellence in Excel! Create a Meter Dashboard tool in Excel!

Excel Mastery, Learn how to use Excel by creating a Speed o Meter Dashboard tool in Excel.
3.8 (4 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.
12 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 15
  • Length 1 hour
  • 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, discover its real power!

  1. Have you ever understood the real power and purpose of Excel?
  2. Do you understand how to create real time saving Excel tools?
  3. Do you truly find it difficult because there is too many formula`s to understand Excel?
  4. Do you wonder how people can deal with so many boring facts in so less time and you struggle to get ahead in Excel?
  5. Do you want to make real use of Excel and save time and money?

Excel does not have to be boring! We can create highly creative Speed o Meter dashboard that has a real function!

In this course you will start to understand how you can create useful tools that are all interconnected! Excel is not a spreadsheet. It is a time-saving tool if you really understand how it works.

In this course you will see what you can do and how you can do it! In this course you will not get the entire tool box. If you do not know how to use the basic tools you do not need to know all the tools. You only need to know the right tools for you!

In this course you learn, do and create. I truly belief this course is the best course for you because you will learn and practice by creating your tool. You will see instantly how Excel really works.

Excel is not a Spreadsheet! Excel is an answering machine. It should give you answers and validate information that you put in!

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

This course is an absolute time saver!

Now you can try this as well! This course is 30 days backed up by Udemy. You can try and discover it yourself and if you discover that this course is not the right course for you! You can get the money back in a blink of an eye!

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

Time is the most valuable thing in life!

My goal in every Excel course I create is that time is the most valuable thing in life. Every tool will earn you back time. In this course you receive all tricks to win and own your time! So, this is your time to take action. Get your time back and click on the button "Take this course"!

Life does not wait for the waiters. Go and take this course now!

What are the requirements?

  • Have an openmind and a willingness to take action.
  • Have the drive to follow along and take action.
  • Want to achieve Excellence in Excel.
  • Have Excel installed on their computer.
  • Have a working Microsoft Excel 2007, 2010 or 2013.

What am I going to get from this course?

  • Understand how to utilize the true power of Excel
  • Create great Speed O Meter dashboards that truly are functional.
  • Assemble instantly understandable dashboards to quickly communicates key metrics.

What is the target audience?

  • Professionals who need to use Excel to their work.
  • Businessmen who need to get a practical foundation of Excel
  • Business owners who need to learn how to use Excel to create time saving tools.
  • Young Professionals who are need to improve or polish their Excel skills.
  • Students that want to analyze data by creating dashboards.

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
01:21

Excel Introduction

Welcome students, Im excited to have you here. In this course you will get a brief overview of what you will learn in this course. Many people have seen speed-o-meters in Excel or would like to make one, but are they really functional? Well, if you understand what they can do and how you should use them they are very useful.

The main goal is learning how to connect data with a dashboard to create useful information.

2 pages

Excel Introduction

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. 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 Tab 1, developing the input data tab with raw data, formula and design.
03:05

Excel Tab 1

In this part you will start to use the Raw Data and implement that in the input tab. You will give the tab some shape and give it a better look and feel.

10:48

Excel Tab 1

In this part you will create the formulas. You will use the different functions and understand how to use the

  1. SUM statement
  2. SUMIF statement

And you will calculate the cost, sales and profit.

03:00

Excel Tab 1

In this part you will give your sheet the proper design. Design is very important always use a consistent design so it gets a professional look and feel. Use consistent colors with color coding. This method will be useful once you want to change raw data in the Excel sheet.

01:52

Excel Exercise 1

In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. 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.

03:37

Excel Exercise 1

In this part you will get the answers of the 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. Follow along and double check.

Section 3: Create Tab 2, developing the 3 speed-o-meter dashboards.
09:44

Excel Tab 2

In this part you will make the first speed o meter that is connected with the 1st goal. You task will be to make the chart and also understand how the values are connected with the chart. This is important because the values of the speed o meter will determine the look of the chart.

Understand how the chart is created and remember that it consist out of a donut and pie chart.

06:09

Excel Tab 2

In this part you will make the second speed o meter that is connected with the 2nd goal. You task will be to make the chart and also understand how the values are connected with the chart. This is important because the values of the speed o meter will determine the look of the chart.

09:17

Excel Tab 2

In this part you will create the third Speed-o-meter. This will be easy because you have seen already many examples. The challenge is if you can do this without any problem. In this part we will use the third goal that connects with the stock inventory. It will measure if the shop surpassed the goal of selling 50% or more of it`s stock.

01:09

Excel Exercise 2

In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. Can you create you own speed o meter? Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 2? This is your challenge, create an equal box as on shown in this video.

03:45

Excel Exercise 2

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

2 questions

You learned alot and now it is time to test your knowledge. Here some questions!

Section 4: Thank you
02:54

Excel summary

In this course you have learned how to create your own Excel Speed o meter chart. Understand that the speed o meter only has value if you connect values with it that has meaning. This chart can show you instantly if you achieved a goal or not. Make use of it the right way.

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!

Article

Learn more about Excel

You can never be an overachiever! Get the next course for a great price!

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