30-days Money-Back Guarantee
Learn expert-level data visualization and actionable Excel Tips for Construction Projects محاسبة التكاليف للمقاولات
Updated on Sep, 2026
Office Productivity, Apple, Excel Dashboard
Duration - 7.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
داشبورد احترافية بالاكسل لشرح محاسبة التكاليف لشركات المقاولات للمحاسبين و مديري المشروعات و مهندسي الرقابة علي التكاليف
موشرات الاداء الخاصة بادارة المشروعات و انحرافات التكاليف الخاصة بمشروعات المقاولات
المفاهيم الخاصة بمحاسبة التكاليف لدى شركات المقاولات و الدورة المحاسبية
عرض قائمة دخل لكل مشروع علي حدا
شرح نسب اتمام المشروعات و كيفية معالجتها وفقا لمعايير المحاسبة و فقا لمديري المشروعات
كيفية حساب الفجوة الخاصة برأس المال العامل لدى كل مشروع
ما هى تكلفة التمويل و كيفية حسابها
حساب مجمل الربح و صافى الربح
بعض المفاهيم الخاصة بالتحليل المالي
التعرف علي معادلات الاكسل المعقدة و الرسم البيانية
في نهاية الكورس ستكون قادر علي انشاء داشبورد مميكنة لشرح تفاصيل كل مشروع من مشروعات المقاولات علي حدا بمجرد تغيير رقم المشروع بالاعلى تتغير الداشبورد لتعرض تفاصيل كل مشروع و ايضا عرض لتجميع تكاليف المشروعات في داشبورد واحدة
- Cost Accounting Cycle and Definitions
- Cash Conversion Cycle or Working Capital Funding Gap (WCFG)
- Coding & Supported Sheets
- Create Profit Or Loss Statement (P/L)
Who this course is for:
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.
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
Check out the detailed breakdown of what’s inside the course
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
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.