Learn Microsoft Excel Dashboards in 90 Minutes
In this tutorial, you'll learn Microsoft Excel Dashboards in 90 minutes. Learn to create interactive stunning visuals all from within Excel for Excel Dashboards!
How to Unhide Rows and Columns in Excel
☞ https://morioh.com/p/648998d62f0a
How to Copy a Table from a PDF to Excel
☞ https://morioh.com/p/26ddc3eb8462
15 Basic Excel formulas You Must Know
☞ https://morioh.com/p/132972a1b3df
In this tutorial, you'll learn Microsoft Excel Dashboards in 90 minutes. Learn to create interactive stunning visuals all from within Excel for Excel Dashboards!
If you want those fancy dashboards, you see in Power BI, well guess what you can get them here in Microsoft Excel!
Using enhanced Excel functions such as INDEX, MATCH, IFS and many more, I will guide you use a simple Data List feature and form controls to pull out the important data from your tables using advanced functions and combine it with interactive and modified charts all from within Excel.
In this 2-hour crash course, we will cover:
INDEX & MATCH
IFS Functions
LARGE vs SMALL
CHOOSE
Using Bar Charts as a whole vs Pie Charts
Adding Dynamic Vertical Group Bars to Charts
Making your Line Chart Dynamic to Date Ranges
Creating your very first Info Graphics
Using Option Buttons
Using List Box
Using Scroll Bar
Create your Dashboard masterpiece
This course is intense, it's fast, but it gets the job done. This course is designed for the Advanced Excel user who knows their way around functions and syntax and Excel in general. Although the manual you get with this course is eight chapters long, we only cover four of them in under 2 hours. So, you must know the first three chapters of the manual as well to be able to keep up with the content.
You may have heard of the functions we mentioned enough but you may not of known how their use can lead to stunning visuals and a dashboard all within Excel with no need to jump into Power BI!
What you’ll learn
Students will build their dashboard formula toolbox by adding functions they may not have known existed before.
Students will learn advanced charting skills and turn them inside out to full interactive responsive charts.
Students will experiment with various form controls and learn how they can control the charts they created.
Students will build a fully functional and interactive dashboard all within Excel without the need to learn another analytic tool.
Are there any course requirements or prerequisites?
You MUST have an advanced skill set with Microsoft's Excel. Students should be using the product frequently and understand the full suyntax of all basic Excel fucnctions. This is a crash course taught under 2 hours so you must know your way around they keyboard and product.
Who this course is for:
This course is intended for extreme advanced users of the Microsoft Excel product. Someone who has a job in an analytical role and needs to create stunning visuals and KPIs to their team. They must have serious Excel exposure and know how all basic functions work.
#Microsoft #Excel #Morioh
Note: If you have any copyright issue with the content used in our channel or you find something that belongs to you, before you claim it to Youtube, SEND US A MESSAGE and the respective content will be DELETED right away. Thanks for understanding.
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
👕 Merchandise: https://www.moteefe.com/store/developer?cp...
🌎 Social Network for Developers: https://morioh.com/
📱 Twitter: https://twitter.com/moriohdotcom