How to Create Interactive Dashboards in Excel | Simon Sez IT

عدد الدروس : 9 عدد ساعات الدورة : 07:36:53 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
Learn to build dynamic and interactive Excel dashboards using PivotTables, PivotCharts, slicers, checkboxes, map charts, and advanced formulas. Perfect for sales, finance, and analytics reporting.
عن الدورة


This course guides you step by step to create professional, interactive dashboards in Microsoft Excel. Starting from the basics, you’ll learn essential techniques like converting text to numbers, extracting unique values, and using the CHOOSE function effectively. The course introduces visual enhancements such as checkboxes, map charts, and dynamic formatting to make your dashboards more intuitive and actionable.

You’ll explore how to design dashboards for sales, finance, and analytics, combining PivotTables, PivotCharts, and slicers to enable interactive filtering and dynamic insights. The lessons emphasize practical application, showing you how to create dashboards that respond to user input and provide clear, impactful data visualizations.

The course also covers building advanced dashboards from scratch, optimizing data layout, and ensuring your reports are visually appealing and easy to understand. By the end, you’ll be equipped to create interactive Excel dashboards that enhance decision-making, improve reporting efficiency, and impress stakehold