Course Content
1. Introduction to Excel
0/2
1. Intro
00:00
2.-Excel-Interface
00:00
2. Navigating Excel
0/8
3. WorkBook – sheets
00:00
4. Cells_Ranges
00:00
5. The Ribbon
00:00
6. FUNCTION KEYS
00:00
7. Shortcuts
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
0/6
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
0/5
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)
0/8
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)
0/11
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)
0/9
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)
0/10
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)
0/8
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
0/10
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)
0/10
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
0/10
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
Excel for Engineers “Technical Office & Construction Management”
About Lesson
Previous
Next
0% Complete