فرصة

The Online Dashboard in Excel free Course by Edraak

Learn how to create effective dashboards in Excel

  • English and Arabic
  • With Certificate

Tutor Name

Edraak

Interested learners

1
The Online Dashboard in Excel free Course by Edraak

About the Course

Excel Dashboards is a free course offered by Idrak that falls under the Excel Mastery specialization. It aims to clarify several topics, most importantly: how to build an Excel dashboard and the best practices to follow while creating it. 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, developing, reviewing, and ensuring the feasibility of Key Performance Indicators (KPIs), comparing data points, examining 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 the recommended training materials. In addition to how to use scorecards to create KPIs, design Excel charts, use rates, time, and dates, and link dashboard controls.


The Excel Dashboards course begins by explaining the concept and benefits of the dashboard (Dashboard), the importance of using KPIs, and how to set performance indicators for work step by step, providing examples of KPIs, their characteristics, and pillars, as well as explaining how to design an Excel dashboard and how to make sure that the data fits 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 control panel 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, conditional formatting rule management, and charts or what is known as charts within 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, alongside courses on Excel Programming using VBA, Excel Functions and Tricks, Data Analysis using Excel, Excel Spreadsheets, and Advanced Excel Skills (Microsoft Excel), and the course provides an introduction to JavaScript.


Register for this free course from Idrak to learn about pivot tables, filtering, timelines, design and planning management in pivot tables, how to design an Excel dashboard, and how to prepare data for use in the dashboard and Excel dashboard.

Who is this course for?

This course is suitable for anyone who wants to learn how to create effective dashboards in Excel.

Course Requirements:

You should have a basic understanding of using Excel.

What will you learn?

  • The concept of dashboards in Excel
  • How to create dashboards in Excel
  • The features and tools that can be used in Excel
  • How to use scorecards to create KPIs
  • Designing Excel charts
  • Linking dashboard controls
  • Conditional formatting
  • Charts (Sparklines)
  • How to build an Excel dashboard

After completing this course you will be able to:

  • Create effective dashboards in Excel
  • Track KPIs
  • Analyze data
  • Make better decisions

Course Costs:

This course is free.

What is included?

  • Access to all course materials
  • Assessment tests
  • Course completion certificate

Taught by

Edraak

إدراك هي منصة إلكترونية عربية للمساقات الجماعية مفتوحة المصادر (MOOCs)، حيث تم تأسيسها بمبادرة من مؤسسة الملكة رانيا للتعليم والتنمية والتي تحرص على بذل كافة الجهود للمساهمة في وضع العالم العربي في مجال التربية والتعليم كونهما حجر الأساس لتطور وازدهار الشعوب. تهدف إدراك إلى توفير مساقات تعليمية عالية الجودة يقوم على تطوير محتوياتها نخب من خبراء وأكاديمي العالم العربي والعالم، بالإضافة إلى تقديم بعض المساقات العالمية المترجمة للغة العربية وذلك تماشيًا مع إيمان الملكة رانيا العبدالله بأهمية التعليم وما له من أثر في تحسين نوعية حياة المجتمعات والدول والأفراد على جميع المستويات.

Read more.