Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 46 Minute(s)
Language
English
Taught by
The Dronaachaarya
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Become an Excel Dashboard Expert : 11 Basic, 3 Intermediate and 4 Advanced Level Dynamic Dashboards without any VBA code
This course teaches you to create well-designed dynamic Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.
By participating in this Microsoft Excel Dashboard course you'll gain the widely sought after skills necessary to effectively analyze large sets of data.
In this topic, we’ll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic excel dashboards. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In addition, you can quickly refresh your dashboard when you add or update data. This makes it very handy because you only need to create the excel dashboard report once.
You will start with 11 Basic Level Excel Dashboards and gradually move to 3 Intermediate and 4 Advanced Level dashboard. Practicing the dashboard along with the course will make you a Master of Microsoft Excel Dashboards.
Course Content
- 4 section(s)
- 31 lecture(s)
- Section 1 Introduction
- Section 2 Basic Level Dashboards
- Section 3 Intermediate Level Dashboards
- Section 4 Advanced Level Dashboards
What You’ll Learn
- The Art of creating Visually Stunning Excel Dashboards.
- You will start with 11 Basic Level Dashboards and gradually move to 3 Intermediate and 4 Advanced Level Charts.
- Practicing the charts along with the course will make you a Master of MS Excel Dashboards.
Skills covered in this course
Reviews
-
BBernard Sessoms
The content is great but my issues are that the instructor uses a lot of functions,vlookup ect. It needs to be a download for these formulas and the reason why it was used.
-
SShankar Iyer
Thanks for such a useful knowledge. It has helped me immensely. I am confident that i will be looked upon as a Excel expert in office. I have already created a mini dashboard for one of the queues at my work place and it was possible because of this course. Surely will keep on practicing. once again thanks a ton and i take this opportunity to wish you and your family a Happy New Year 2020
-
FFreida P
I learned a great deal of new tricks from this course which were unknown to me even after several years using Excel. I definitely feel more empowered now to use the advanced methods in Excel , Fantastic course from a very knowledgeable instructor.
-
TTina Nicole
Thanks Excelgurus for creating such a meticulous course which covers aspects from Basic to Advanced of Dashboard making. I specifically liked the Advanced sections which teaches some really great tricks of presenting data and creating eye catching dashboards..
