Microsoft Excel 365 Basics Series – Formulas, Functions, PivotTables & Data Analysis (Complete Course)

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

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

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
A complete Excel 365 basics series covering formulas, functions, PivotTables, and essential data analysis tools for beginners and intermediate users.

قائمة الدروس

عن الدورة


This Microsoft Excel 365 Basics series is a comprehensive learning path designed to take learners from fundamental Excel concepts to practical data analysis skills using modern Excel 365 tools. The course is structured into multiple lessons, each focusing on a key area of Excel to ensure gradual and complete understanding.

You begin with the essentials of Excel, including what Excel is, how formulas and functions work, and how to properly format and structure spreadsheets. You also learn about cell references and page setup to build clean and professional worksheets.

The course then dives into powerful Excel functions such as SUMIFS, COUNTIFS, IF, and logical functions like AND, OR, and NOT. These tools help you perform advanced calculations and data conditions with ease. You also explore date and time functions, number formatting, and the importance of rounding values correctly.

A major part of the series focuses on modern lookup and dynamic functions such as XLOOKUP, FILTER, and XMATCH, which simplify complex data tasks. In later lessons, you learn PivotTables, slicers, charts, and conditional formatting for effective data analysis and visualization.

By the end of this series, you will be confident in using Excel 365 for real-world data tasks, reporting, and decision-making.