Excel, discover its real power!
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!
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.
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.
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.
Excel Tab 1
In this part you will create the formulas. You will use the different functions and understand how to use the
And you will calculate the cost, sales and profit.
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.
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.
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.
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.
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.
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.
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.
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.
You learned alot and now it is time to test your knowledge. Here some questions!
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.
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!
Learn more about Excel
You can never be an overachiever! Get the next course for a great price!
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.