Others

Excel for Engineers “Technical Office & Construction Management”

5.0

(1)

24 Enrolled

8 hours 10 minutes

Mohamed Elsadek

✍️✍️برنامج الاكسيل يعتبر من اهم البرامج اللي لازم يتقنها اي مهندس علشان كده وفرنا ليكم كورس قوي جدا.
💹♻️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

Course Content

1. Introduction to Excel

1. Intro

00:00
2.-Excel-Interface

00:00

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)

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)

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)

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

103 Students

5 Courses

Feedback

5.0

Total 1 Rating

100%

Review (1)

MA

Mohamed Abdelaal

5 months ago

Very good course

Enrollment validity: 90 days

Level All Levels
Total Enrolled 24
Duration 8 hours 10 minutes
Last Updated February 2, 2024

Excel for Engineers “Technical Office & Construction Management”

What Will You Learn?

Requirements

Audience

Course Content

1. Introduction to Excel

1. Intro

2.-Excel-Interface

2. Navigating Excel

3. WorkBook – sheets

4. Cells_Ranges

5. The Ribbon

6. FUNCTION KEYS

7. Shortcuts

8. Saving Workbook

9. Protect Workbook With Password

10. Protect Formulas Cells

3. Formatting Sheets and cells

11. Dealing with Columns and Rows

12. Fonts – Colors – Fills

13. Alignment

14. Boarders

15. Format Painter

16. Paste Options

4. Excel Options

17. General

18. Formulas

19. Data-Profing-Save-Language-Accessibility

20. Advanced

21. Customize Ribbon-Q Access

5. Most Used Formulas for Engineers (01)

22. SUM

23. AutoSum

24. SUMIF

25. SUMIFS

26. Subtotal

27. Count & CountA & Count Blank

28. CountIF

29. CountIFs

6. Most Used Formulas for Engineers (02)

30. Round

31. RoundUp – RoundDown

32. MRound

33. MAX – MAXA

34. MIN – MINA

35. MAXIFS

36. MINIFS

37. Average

38. AverageA

39. AverageIF

40. AverageIFS

7. Most Used Formulas for Engineers (03)

41. IF

42. IF error

43. AND

44. OR

45. Large

46. Small

47. Substitute

48. EOMonth for Dates

49. EDATE

8. Most Used Formulas for Engineers (04)

50. Concat

51. LEN

52. Upper – Lower

53. Left Right Mid

54. SQRT – SQRTPI

55. POWER

56. Convert

57. DEG – RADIONS

58. PI

59. Adding units

9. Most Used Formulas for Engineers (05)

60. VLookUP

61. HLookUP

62. Match

63. Index

64. Column

65. Row

66. Offset