Have a question?
Message sent Close
4.73
117 reviews
Hot course

MS-Excel For Civil Engineers for Project Planning From Zero

"A Basic to Advanced Course which will make you a Great Construction Professional in Your Career MS - Excel is ... Show more
Instructor
Udemy APAC
7,631 Students enrolled
  • Description
  • Curriculum
  • FAQ
  • Reviews

“A Basic to Advanced Course which will make you a Great Construction Professional in Your Career MS – Excel is the Most Powerful Software which Students and young Engineers are aware of. whatever you want to do in the construction industry from Estimation – Planning – Bar Bending Schedule – Structural Design the only tool which will save you is MS- Excel In this Complete Course, I will Cover the Basics & Advanced tools and their Application in the Construction Industry to make you Fall in Love with these tools.We will be Covering all the Basic Commands and Advanced Commands and then move towards Live projects of creating Excel sheet for Estimation, Planning & Structural Designing Topic we will be Covering inside the Course Excel Introduction • An overview of the screen, navigation and basic spreadsheet concepts • Various selection techniques • Shortcut Keys Customizing Excel • Customizing the Ribbon • Using and Customizing AutoCorrect • Changing Excel’s Default Options Using Basic Functions • Using Functions – Sum, Average, Max,Min, Count, Counta • Absolute, Mixed and Relative Referencing””Formatting and Proofing • Currency Format • Format Painter • Formatting Dates • Custom and Special Formats • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formattingMathematical Functions • SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT Protecting Excel • File Level Protection • Workbook, Worksheet Protection Text Functions • Upper, Lower, Proper • Left, Mid, Right • Trim, Len, Exact • Concatenate • Find, SubstituteMany More thing will be Covered “

How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.73
117 reviews
Stars 5
87
Stars 4
15
Stars 3
11
Stars 2
0
Stars 1
4
50347
Share
Coupon Code:- 955A62CDE389E43DD27A
Course details
Video 15 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW