Excel 365 & Power BI Course – Intermediate to Advanced Data Analysis

عدد الدروس : 25 عدد ساعات الدورة : 26:19:21 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

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

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
Master Excel formulas, Power Query, DAX, and Power BI for advanced data analysis and dashboards.

قائمة الدروس

عن الدورة


This comprehensive course is designed for learners who want to advance their data analysis skills using Microsoft Excel and Microsoft Power BI. It covers intermediate to advanced concepts used by data analysts and business professionals.

You will begin by strengthening your Excel foundation with advanced formulas and functions, including logical functions, lookup formulas like XLOOKUP, and conditional calculations such as SUMIFS and COUNTIFS. The course also explores PivotTables, charts, and data modeling techniques to analyze large datasets efficiently.

Next, you will dive into Power Query, learning how to clean, transform, and import data from multiple sources. This includes working with M code to automate data preparation processes.

The course also introduces DAX (Data Analysis Expressions), enabling you to create powerful calculations and measures for deeper insights. You will learn how to build data models and connect Excel with Power BI for enhanced analytics.

Additionally, you will explore advanced topics such as dynamic array formulas, LET and LAMBDA functions, and building professional dashboards.

By the end of this course, you will have the skills to perform complex data analysis, automate workflows, and create dynamic reports and dashboards