Excellence in Excel! Create a 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
Wishlisted Wishlist

Please confirm that you want to add Excellence in Excel! Create a Meter Dashboard tool in Excel! to your Wishlist.

Add to Wishlist

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
Created by Nicky Wong
Last updated 3/2015
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.
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!

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 01:03:17
+
Welcome
2 Lectures 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.

Preview 01:21

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.

Download the Excel files with Raw Data
2 pages
+
Create Tab 1, developing the input data tab with raw data, formula and design.
5 Lectures 22:22

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.

Preview 03:05

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.

Preview 10:48

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.

Making Tab 1, the design
03:00

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.

Exercise Test 1
01:52

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.

Exercise Test 1 Answers
03:37
+
Create Tab 2, developing the 3 speed-o-meter dashboards.
5 Lectures 30:04

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.

Explanation of the speed-o-meter and creating the first one.
09:44

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.

Developing the second speed-o-meter and connect it with the second goal.
06:09

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.

Create the last speed-o-meter measuring the stock inventory goal.
09:17

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.

Exercise Test 2
01:09

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.

Exercise Test 2 Answers
03:45

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

Excellence in Excel Quiz by Udemology!
2 questions
+
Thank you
3 Lectures 03:09

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.

Final Points
02:54

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!

Excel Reference Sheet by Udemology
4 pages

Learn more about Excel

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

Bonus: Further Learning
00:15
About the Instructor
Nicky Wong
4.0 Average rating
376 Reviews
30,182 Students
22 Courses
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.