Excel for Accountants – PivotTables, Power Query & Excel Formulas Masterclass

عدد الدروس : 1 عدد ساعات الدورة : 02:22:28 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

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

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
Master Excel for accounting with PivotTables, Power Query, VLOOKUP, SUMIFS, IF formulas, charts, and reporting tools.
عن الدورة


This advanced Excel course for accountants teaches the most important Excel tools and functions used in accounting, bookkeeping, and financial reporting. Created by excelisfun, the course is designed for accounting students, finance professionals, and beginners who want to improve their Excel skills for real-world accounting work.

Learners will explore essential Excel features including PivotTables, Power Query, IF statements, SUMIFS, VLOOKUP, Flash Fill, charts, and formatting techniques. The course explains how accountants use Excel to organize data, automate calculations, build reports, and improve financial analysis processes.

Step-by-step practical examples help students understand how to clean and manage accounting data efficiently. The lessons also demonstrate how to create dynamic financial reports and use Excel tools to increase productivity and accuracy in accounting tasks.

By the end of the course, learners will be able to confidently use advanced Excel functions for accounting analysis, reporting, and business decision-making. This course is ideal for accountants, commerce students, analysts, and professionals looki