Excel Dashboard For Project Management and Control Course
Learn expert-level data visualization and actionable Excel Tips for Construction Projects محاسبة التكاليف للمقاولات
Updated on May, 2024
Language - English
Excel Dashboard,Office Productivity,Microsoft
Lectures -51
Resources -9
Duration -7.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
داشبورد احترافية بالاكسل لشرح محاسبة التكاليف لشركات المقاولات للمحاسبين و مديري المشروعات و مهندسي الرقابة علي التكاليف
سوف نتناول
موشرات الاداء الخاصة بادارة المشروعات و انحرافات التكاليف الخاصة بمشروعات المقاولات
القيمة المكتسبة
المفاهيم الخاصة بمحاسبة التكاليف لدى شركات المقاولات و الدورة المحاسبية
عرض قائمة دخل لكل مشروع علي حدا
شرح نسب اتمام المشروعات و كيفية معالجتها وفقا لمعايير المحاسبة و فقا لمديري المشروعات
كيفية حساب الفجوة الخاصة برأس المال العامل لدى كل مشروع
ما هى تكلفة التمويل و كيفية حسابها
حساب التشوينات
حساب مجمل الربح و صافى الربح
بعض المفاهيم الخاصة بالتحليل المالي
التعرف علي معادلات الاكسل المعقدة و الرسم البيانية
في نهاية الكورس ستكون قادر علي انشاء داشبورد مميكنة لشرح تفاصيل كل مشروع من مشروعات المقاولات علي حدا بمجرد تغيير رقم المشروع بالاعلى تتغير الداشبورد لتعرض تفاصيل كل مشروع و ايضا عرض لتجميع تكاليف المشروعات في داشبورد واحدة
- Cost Accounting Cycle and Definitions
- Direct & Indirect Cost
- Percentage of Completion POC Implementation for Project Management & Cost Accounting
- Material On Site Treatment with ERP System and without
- Backlog
- Payment Certificates (Client Invoices)
- Budgeting & Estimation
- Operational Profit Margin OPM & Gross Profit Margin GPM
- Finance Cost Definition
- Cash Conversion Cycle or Working Capital Funding Gap (WCFG)
- Accounts Receivable Turnover - AR Days
- Accounts Payable Turnover - AP Days
- Coding & Supported Sheets
- Cost Centers & Internal Codes
- Cost Breakdown
- Contract Details & Change Orders Tracking
- Accumulated Payment Certificates and Details for each Invoice
- Additions and Deductions
- Validation
- Create Profit Or Loss Statement (P/L)
- P/L for Each Project
- Consolidated Profit or Loss Statement for All Projects
- Dynamic Dashboard
- Quick views into key Performance Indicators (KPIs).
- Visual Representation of Projects
- Relevant Data only to the Dashboard Objective.
- Predefined Conclusions for the stakeholders .
- Graphs, Pie Charts etc.
- Excel Complicated Functions
This Course for
- Project Managers & CFOs
- Accountants at Construction and software companies
- Cost Control Engineers
- Cost Accountant
- Budgeting and planning Team
Who this course is for:
- Cost Accountants
- Project Managers
- Financial Managers
- Cost Control Engineers
- Budgeting and Planning Team
- Accountants
- محاسبين في شركات المقاولات
Goals
What will you learn in this course:
Most popular KPIs at Project Management which are related (Cost Knowledge Area)
Cost Accounting Cycle and Definitions
Cash Conversion Cycle or Working Capital Funding Gap (WCFG)
Create Profit Or Loss Statement (P/L)
Visually Effective Excel Dashboard for Construction Projects
Maintain large sets of Excel data in a list or table
Build a solid understanding on the most common Excel functions used in Microsoft Excel Vlookups, Sumif , Sumifs etc
Impress management with Financial & Project Management reports that make the decision-making process faster
Learn Financial Definitions like Finance Cost, Percentage of Completion, OPM,GPM, AR Turnover, AP Turnover etc
Learn Project Management Indicators CV, CPI, EV,AC, EAC, ETC, VAC etc.
Prerequisites
What are the prerequisites for this course?
Only basic prior experience in Excel is required to get the most out of this Excel course
More Than One Year at Accounting and Engineering
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
29 Lectures
-
Data Setup
13:53
13:53
-
Setup Internal Code
05:57
05:57
-
1.Uploading Actual Cost
10:52
10:52
-
2.Uploading Actual Cost
11:04
11:04
-
3.Uploading Actual Cost
08:57
08:57
-
1.Breakdown
06:45
06:45
-
1.2 Breakdown2
01:54
01:54
-
1.2.3 Cost Breakdown
06:20
06:20
-
1.2.3.4 Cost Breakdown
08:32
08:32
-
2. Cost Breakdown
15:48
15:48
-
2.2 Cost Breakdown
03:57
03:57
-
2.3 Cost Breakdown
05:19
05:19
-
2:4 Cost Breakdown
19:37
19:37
-
Construction Contracts
09:30
09:30
-
2. Contracts Setup
08:37
08:37
-
3. Contracts Setup
03:46
03:46
-
Payment Certificate
07:29
07:29
-
2 : Payment Certificate
34:03
34:03
-
1.1 Percentage of Completion
05:05
05:05
-
1.2 Percentage of completion
05:30
05:30
-
Input Contracts
03:45
03:45
-
2.Input Direct Cost
12:59
12:59
-
Input Profitability
13:22
13:22
-
Project Management KPIs
18:29
18:29
-
5. Estimations & Budgeting
17:27
17:27
-
Balance Sheet and Financial Analysis
12:57
12:57
-
2.Balance Sheet And Financial analysis
22:56
22:56
-
Input Design
05:43
05:43
-
Input Dashboard Line Setting
09:34
09:34
Dynamic Dashboard For Construction Projects
21 Lectures
Resources
1 Lectures
Instructor Details
Tohamy Adel
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now