Excel Dashboard For Project Management and Control Course

person icon Tohamy Adel

4 ★★★★ ★

Buy Now

Excel Dashboard For Project Management and Control Course

Name: Excel Dashboard For Project Management and Control Course
Rating: 4 (146 reviews)
Author: Tohamy Adel

Learn expert-level data visualization and actionable Excel Tips for Construction Projects محاسبة التكاليف للمقاولات

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Tohamy Adel

English [CC]

category icon Excel Dashboard,Office Productivity,Microsoft

Lectures -51

Resources -9

Duration -7.5 hours

4 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

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

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

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

Excel Dashboard For Project Management and Control Course

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

About me

My name is Tohamy Adel

I am a Cost Accounting Section Head at construction company in Egypt

I have more than 8 Years experiences at construction industry at Finance department and Recently as a head of Cost Accounting Department

I worked at the biggest construction companies in Egypt and KSA with total turnover more than 4 Billion Egyptian Pound

* EDECS for Engineering and Construction

(Infrastructure-Bridges-Seaports etc)

* Kabbani Construction Group KCG is one of the biggest specialized construction Firms in KSA

Specialized works for Subsidiaries

A-Build Egypt Waterproofing Works

CRES Fireproofing and Epoxy Paints

Structural Systems Structure

* Asass construction, and GRC Cladding Factory

- Founder of Ze-Accountant which has more than 140K Visitors

I have more than 40 articles at Accounting and costing at this platform

- Co-Founder of Masarat for training and consulting

- YouTube presenter : Introduce short videos at Tarqeem Studio

To get a deep experience at cost for construction industry

- Besides studying Accounting and finance certificates like CMA, Cost Accounting Diploma, FMVA, and FP&A

I studied Project Management and New Trends like lean construction Management and Agile which are good techniques to eliminate the waste and maximize the value

Thanks

Course Certificate

Use your certificate to make a career change or to advance in your current career.