Excellence in Excel! Create an advanced Excel Dashboard!
- 1 hour on-demand video
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business- How to activate the Developer Tab.
- Activate the Developer Tab.
- Use the Checkbox option in Excel.
- Create a professional Excel Dashboard.
- Create a target/goal line in any chart.
- Understanding the SUMIF function.
- Know how to use the VLOOKUP.
- Know how to apply the HLOOKUP.
- Nest multiple IF functions in a CONCATENATE function.
- Know how to apply the CONCATENATE function.
- Assign and create a Dropdown list.
- Develop a professional connected chart that displays value what is marked in a Checkbox.
- Have the willingness to take MASSIVE action!
- Have a working Microsoft Excel 2007, 2010 or 2013.
- Have a openmind and willingness to achieve Excellence 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? This course is for you!
======================================================================
LEARN HOW YOU CAN MAKE AN ADVANCED DASHBOARD
======================================================================
Dashboard is the new "hot topic".
Many people are thinking about dashboards and stop using charts for reports! Excel dashboards are really core essential graphs displaying key information.
A dashboard is nothing more than getting the right data displayed for the right person! What important is for you does not have to be important for me! In this course you learn how you can make an Advanced Dashboard in Excel
======================================================================
CREATING A DASHBOARD IS EASY EVERYBODY CAN DO IT!
======================================================================
This course is designed to show you how easy it really is. You will notice that the WAY A CHART presents data determines the value of your dashboard.
Understanding the fundamentals is important, but I truly belief you have to take action! This course is based on full action. Once you do that you will notice quickly how easy it is.
You will learn how to make a triple chart dashboard that has buttons that will
======================================================================
MY GOAL IS THAT YOU PUT EXCEL TO WORK FOR YOU!
======================================================================
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!
You will learn that Excel can save you a ton of time! All you have to do is take the information in this course and practice!
======================================================================
WHY SHOULD I TAKE THIS COURSE? YOU COMPETITORS HAS A BIGGER COURSE!
======================================================================
I understand your point, but do you know the difference between having 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.
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!
- Students who want to improve their Excel and dashboard skills.
- Professionals that need to present their data more professionally to their superiors.
- Excel students that want to create a more dynamic and interactive Dashboard in Excel.
- Businessman that needs Excel to improve the way they present data.
Excel Advanced Dashboard
In this lecture you get an overview of what you will learn in this course. I`m very excited to share you this information because with this you can start tracking your progress. You will learn how you can make a dashboard with 3 interactive charts.
Remember: What gets measured, gets done!
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.
Excel Advanced Dashboard
In this lecture you will start from a blank sheet. You will create the Input Data Tab. First you need to copy the Raw Data file. If you haven`t downloaded the worksheet please download it now. Go back to Lecture 2 for the sheet. In the Input Data Tab you will create the layout and structure.
Excel Advanced Dashboard
In this part you will learn how to use the SUMIF function. This function will automate the calculation instantly and save you a ton of time! In this part we will calculate the three categories: Cost, Sales and Profit with this function.
Excel Advanced Dashboard
In this lecture you will create the first chart. You will learn:
- How to activate the Develop Tab
- How to use the Checkbox
- How to connect the checkbox with the chart
- How to use the HLOOKUP function.
Excel Advanced Dashboard
In this lecture you will create the bar chart. This is the second chart that displays information depending on a dropdown list. You will learn:
- How to assign lists
- How to create a dropdown list.
- How to display the data in a chart based on three categories.
Excel Advanced Dashboard
In this lecture you will learn how to create the Performance Triangle. With this chart you will be able to measure clearly what month is performing good and what month is weak. You will learn:
- How to make a dropdown list
- How to use the HLOOKUP function
- How to use the AVERAGE function
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:
- Go and rate my course!
- Go ahead and tell me what you want to learn more about Excel in the discussion board!
- How can you use this knowledge in your daily life?
Excel Advanced Dashboard
In this bonus lecture you will learn how to create a goal line in Chart 2. A chart will be more useful based on the information it displays. With a goal line in the bar chart you will be able to present the information much better. The Bars in the chart will have more meaning.
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!