Excel Dashboards Course
Learn how to design effective dashboards using Excel
- Arabic
- With Certificate
Tutor Name
EdraakAbout the Course
Excel Dashboards is a free course offered by إدراك and falls under the Excel Mastery specialization. The course aims to clarify several topics, most importantly: how to build an Excel Dashboard and the best practices to follow during its creation. Learners in this course will need to know how to use Excel professionally.
Excel Dashboards can be a great tool when it comes to tracking Key Performance Indicators (KPIs), developing them, reviewing them, ensuring their feasibility, comparing data points, examining the data used, and obtaining data-driven views that can help management make the right decisions to achieve success.
In the Excel Dashboards course, we will learn how to create an Excel dashboard, the features and tools that we can use in this program, the things that should be avoided at all costs, and recommended training materials. In addition to how to use performance cards to create KPIs, design Excel charts, and use rates, time, dates, and link dashboard controls.
The Excel Dashboards course begins by explaining the concept and benefits of dashboards, the importance of using KPIs, and how to set performance indicators for work step by step, providing examples of KPIs, their characteristics, and pillars. It also explains how to design an Excel dashboard and how to make sure that the data suits the work with KPIs.
The Excel Dashboards course also explains data tables, how to link more than one table, how to create and manage relationships between tables, how to start working with Power Pivot Table, add Slicers formulas, create a dashboard through Power Pivot Table, and add it through the same file, how to deal with charts in it, and design Excel charts.
The Excel Dashboards course then moves on to explain conditional formatting in different ways (Color Scale, Data Bar, Icon Sets), default conditional formatting rules, custom rules, managing rules in conditional formatting, charts or what is called charts inside Excel (Sparklines), their types, and how to create them based on reports (Pie Charts) and how to build an Excel Dashboard.
The Excel Dashboards course is the third course in this specialization, along with courses on Excel programming using VBA, Excel Functions and Tricks, Data Analysis Using Excel, Excel Spreadsheets, and Advanced Excel Skills (Microsoft Excel). The course also gives an introduction to JavaScript.
Register for this free course from إدراك to learn about pivot tables, filtering, timelines, managing design and planning in pivot tables, how to design an Excel Dashboard, and how to prepare data for use in dashboards and Excel dashboards.
Who is this course for?
This course is suitable for anyone who has a basic knowledge of Excel and wants to learn how to design effective dashboards using Excel.
Course Requirements
It is essential to have a basic knowledge of Excel before starting this course.
What you will learn?
- You will learn about the concept of dashboards and their benefits.
- You will learn about the importance of using KPIs.
- You will learn how to create an Excel dashboard.
- You will learn about the features and tools that can be used in creating dashboards.
- You will learn how to use performance cards to create KPIs.
- You will learn how to design Excel charts.
- You will learn how to link dashboard controls.
- You will learn about data tables and how to link them.
- You will learn about Power Pivot Table and how to create a dashboard through it.
- You will learn about conditional formatting (Color Scale, Data Bar, Icon Sets).
- You will learn about charts (Sparklines) and how to create them.
After completing this course you will be able to:
- Create effective dashboards using Excel.
- Identify KPIs correctly.
- Design professional Excel charts.
- Link dashboard controls.
- Prepare data for use in dashboards.
Course Costs
This course is free.
What is included?
The course includes a set of videos, exercises, and interactive activities.
Taught by
إدراك هي منصة إلكترونية عربية للمساقات الجماعية مفتوحة المصادر (MOOCs)، حيث تم تأسيسها بمبادرة من مؤسسة الملكة رانيا للتعليم والتنمية والتي تحرص على بذل كافة الجهود للمساهمة في وضع العالم العربي في مجال التربية والتعليم كونهما حجر الأساس لتطور وازدهار الشعوب. تهدف إدراك إلى توفير مساقات تعليمية عالية الجودة يقوم على تطوير محتوياتها نخب من خبراء وأكاديمي العالم العربي والعالم، بالإضافة إلى تقديم بعض المساقات العالمية المترجمة للغة العربية وذلك تماشيًا مع إيمان الملكة رانيا العبدالله بأهمية التعليم وما له من أثر في تحسين نوعية حياة المجتمعات والدول والأفراد على جميع المستويات.
Read more.