Excel for Engineers “Technical Office & Construction Management”
5.0
(1)
63 Enrolled
8 hours 10 minutes
What Will You Learn?
- ✍️✍️برنامج الاكسيل يعتبر من اهم البرامج اللي لازم يتقنها اي مهندس علشان كده وفرنا ليكم كورس قوي جدا.
- 💹♻️Excel for Engineers T.O & Const..Manag.💹♻️
- 💹♻️كورس اكسيل خاص بالمهندسين💹♻️ - ( شرح برنامج الاكسيل بصورة تخصصية للمهندسين - شرح اهم المعادلات والمهارات التي يستخدمها المهندسين خاصة مهندسين المكتب الفني وإدارة المشروعات )
- Course Outlines: -
- 1. Introduction to Excel
- 2. Navigating Excel
- 3. Formatting Sheets and cells
- 4. Excel Options
- 5. Most Used Formulas for Engineers (01)
- 6. Most Used Formulas for Engineers (02)
- 7. Most Used Formulas for Engineers (03)
- 8. Most Used Formulas for Engineers (04)
- 9. Most Used Formulas for Engineers (05)
- 10. Dealing with Data
- 11. Tips (01)
- 12. Charts
Requirements
- لا يوجد
Audience
- - مهندسين المكتب الفني
- مهندسين ادارة المشروعات
Course Content
1. Introduction to Excel
-
00:00
-
00:00
2. Navigating Excel
-
3. WorkBook – sheets
00:00 -
00:00
-
5. The Ribbon
00:00 -
6. FUNCTION KEYS
00:00 -
00:00
-
8. Saving Workbook
00:00 -
9. Protect Workbook With Password
00:00 -
10. Protect Formulas Cells
00:00
3. Formatting Sheets and cells
-
11. Dealing with Columns and Rows
00:00 -
12. Fonts – Colors – Fills
00:00 -
13. Alignment
00:00 -
14. Boarders
00:00 -
15. Format Painter
00:00 -
16. Paste Options
00:00
4. Excel Options
-
17. General
00:00 -
18. Formulas
00:00 -
19. Data-Profing-Save-Language-Accessibility
00:00 -
20. Advanced
00:00 -
21. Customize Ribbon-Q Access
00:00
5. Most Used Formulas for Engineers (01)
-
22. SUM
00:00 -
23. AutoSum
00:00 -
24. SUMIF
00:00 -
25. SUMIFS
00:00 -
26. Subtotal
00:00 -
27. Count & CountA & Count Blank
00:00 -
28. CountIF
00:00 -
29. CountIFs
00:00
6. Most Used Formulas for Engineers (02)
-
30. Round
00:00 -
31. RoundUp – RoundDown
00:00 -
32. MRound
00:00 -
33. MAX – MAXA
00:00 -
34. MIN – MINA
00:00 -
35. MAXIFS
00:00 -
36. MINIFS
00:00 -
37. Average
00:00 -
38. AverageA
00:00 -
39. AverageIF
00:00 -
40. AverageIFS
00:00
7. Most Used Formulas for Engineers (03)
-
41. IF
00:00 -
42. IF error
00:00 -
43. AND
00:00 -
44. OR
00:00 -
45. Large
00:00 -
46. Small
00:00 -
47. Substitute
00:00 -
48. EOMonth for Dates
00:00 -
49. EDATE
00:00
8. Most Used Formulas for Engineers (04)
-
50. Concat
00:00 -
51. LEN
00:00 -
52. Upper – Lower
00:00 -
53. Left Right Mid
00:00 -
54. SQRT – SQRTPI
00:00 -
55. POWER
00:00 -
56. Convert
00:00 -
57. DEG – RADIONS
00:00 -
58. PI
00:00 -
59. Adding units
00:00
9. Most Used Formulas for Engineers (05)
-
60. VLookUP
00:00 -
61. HLookUP
00:00 -
62. Match
00:00 -
63. Index
00:00 -
64. Column
00:00 -
65. Row
00:00 -
66. Offset
00:00 -
67. Indirect
00:00
10. Dealing With Data
-
68. Data Validation
00:00 -
69. Drop Down List
00:00 -
70. Text To Coulmns
00:00 -
71. Find and Select
00:00 -
72. Go to Special
00:00 -
73. Table
00:00 -
74. Table Formula
00:00 -
75. Data Bars
00:00 -
76. Sorting
00:00 -
77. Filter
00:00
11. Tips (01)
-
78. Quantity Surveying Template
00:00 -
79. Removing Blanks
00:00 -
80. Table dash slicer
00:00 -
81. Check box
00:00 -
82. Grouping Row & Columns
00:00 -
83. Freeze
00:00 -
84. Cell Fixing
00:00 -
85. Autofill
00:00 -
86. Show Formula
00:00 -
87. Trim
00:00
12. Charts
-
88. Creating Charts
00:00 -
89. Formatting Charts
00:00 -
90. Linking Chart Title
00:00 -
91. BOQ Analysis
00:00 -
92. Meter chart
00:00 -
93. Percent Completed Chart
00:00 -
94. Planned Vs Earned Chart
00:00 -
95. S Curve
00:00 -
96. Glass Chart
00:00 -
97. Glass chart 3d
00:00
Instructors
Mohamed Elsadek
5.0
461 Students
9 Courses
Feedback
5.0
Total 1 Rating
100%
0%
0%
0%
0%
Review (1)
750,00 EGP
1.000,00 EGP
- All Levels
- 63
- 8 hours 10 minutes
- October 10, 2024
- Enrollment validity: Lifetime
Hi, Welcome back!
Related Courses
Sale
Progress Dashboard Report for Construction Projects
4 Lessons
2 hours
Intermediate
Mohamed Elsadek
Sale
5.0
(1)
Dashboards For Construction Projects
6 Lessons
2 hours
Intermediate
Mohamed Elsadek
Mohamed Abdelaal