Excel for Accounting – Formulas, VLOOKUP, PivotTables & Macros Course

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

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

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


This complete Excel accounting course teaches essential Excel tools and techniques used in accounting, bookkeeping, and financial analysis. Created by excelisfun, the course is designed for accountants, students, finance professionals, and beginners who want to improve their Excel skills for real-world accounting tasks.

Learners will explore powerful Excel features including formulas, VLOOKUP, INDEX functions, PivotTables, recorded macros, charts, and keyboard shortcuts. The course explains how accountants use these tools to automate calculations, manage large datasets, create reports, and improve productivity in financial reporting.

Step-by-step practical examples help students understand how to organize accounting data, perform lookups efficiently, build dynamic reports, and automate repetitive tasks using macros. The lessons also focus on spreadsheet accuracy, formatting, and professional reporting techniques used in accounting and finance environments.

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