Excel for FP&A | Financial Modeling, Forecasting & Automation (Complete Course)

عدد الدروس : 9 عدد ساعات الدورة : 01:23:24 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

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

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
A complete Excel for FP&A course covering financial modeling, forecasting, automation, and advanced Excel functions for finance professionals.
عن الدورة


This course is designed to teach how to use Excel professionally for Financial Planning & Analysis (FP&A), focusing on real-world financial modeling, forecasting, and automation skills using Microsoft Excel. It is ideal for students and professionals who want to work in finance, analytics, or corporate planning.

The course begins with the essential Excel functions used in financial analysis, including SUM, COUNT, IF, and logical formulas like AND and OR. These functions form the foundation of financial data processing and reporting.

Next, it covers lookup and reference functions such as VLOOKUP and XLOOKUP, which are critical for linking and analyzing large financial datasets. You will also learn advanced lookup techniques and text functions used for cleaning and structuring data.

The course then moves into automation and dynamic tools, including Power Query and dynamic array functions like FILTER, UNIQUE, and SORT. These tools help automate repetitive tasks and improve efficiency in financial workflows.

You will also learn how to build financial dashboards, performance reports, and forecasting models. Scenario analysis and planning techniques are introduced to help simulate different business outcomes.

By the end of this course, you will be able to use Excel confidently for financial modeling, reporting, and automation in real FP&A environments.