Course Link
Practice
https://www.eloquens.com/tool/xA7AC5E5/finance/construction-excel-templates/excel-dashboard-for-cost-of-construction-and-software-projects
You will learn at this Course as follow
-
Most popular KPIs at Project Management which are related (Cost Knowledge Area)
•
Cost Performance Indicator CPI
•
Cost variances CV
•
Earned Value EV
•
Planned Value PV
•
Estimated at Completion EAC
•
Estimated To Completion ETC
•
Variance At Completion VAC
•
Budget At Completion BAC
-
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)
•
OPM & GPM
-
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.
•
Complicated Functions Vlookups, Sumifs, etc.
This Course for
-
Project Managers & CFOs
-
Accountants at Construction and software companies
-
Cost Control Engineers
-
Cost Accountant
-
Budgeting and planning Team
Note: This course is not an Excel Dashboard only but it is a cost journey at construction Companies, You will learn the business cycle at construction firms also and going across this journey to create a good presentation through this Dashboard
You can check more through this Introduction which show you the Full output
https://www.youtube.com/watch?v=WSmAvs_m-v8