課程資料
報名日期
全年招生
課程級別
學習模式
修業期
6 小時 46 分鐘
教學語言
英語
授課導師
The Dronaachaarya
證書
- 可獲發
- *證書的發放與分配，依課程提供者的政策及安排而定。
評分
4次瀏覽
課程簡介
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.
課程章節
- 4 個章節
- 31 堂課
- 第 1 章 Introduction
- 第 2 章 Basic Level Dashboards
- 第 3 章 Intermediate Level Dashboards
- 第 4 章 Advanced Level Dashboards
課程內容
- 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.
此課程所涵蓋的技能
評價
-
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..
