Microsoft Excel For Construction Cost & Civil Engineers
Microsoft Excel Beginner to Professional for all Civil - Construction -Estimation - Quantity & Structural Engineers
What you'll learn
Elevate Your career in New Dimension and Stand Tall among Your Colleagues and Friends
Complete Excel From Start to Finish on Live Projects
Students Will be able to create their own Spread Sheets without Taking anyone's Help in their Projects
All Fundamentals From Civil Engineering & Their Application in Ms- Excel
Students will Create their Own Dashboard and Present the Data like Pro
Requirements
Nil- Patience to Learn and Apply
Description
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 Auto Correct
• 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
Who this course is for
Civil Engineers
Structural Engineers
Construction Engineers
Contractors
Civil Engineering Students
Published 4/2023
Created by Akshay Kamath
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 14 Lectures ( 3h 38m ) | Size: 1.86 GB
Download
http://s19.alxa.net/one/2023/04/Mic....Engineers.rar
Microsoft Excel Beginner to Professional for all Civil - Construction -Estimation - Quantity & Structural Engineers
What you'll learn
Elevate Your career in New Dimension and Stand Tall among Your Colleagues and Friends
Complete Excel From Start to Finish on Live Projects
Students Will be able to create their own Spread Sheets without Taking anyone's Help in their Projects
All Fundamentals From Civil Engineering & Their Application in Ms- Excel
Students will Create their Own Dashboard and Present the Data like Pro
Requirements
Nil- Patience to Learn and Apply
Description
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 Auto Correct
• 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
Who this course is for
Civil Engineers
Structural Engineers
Construction Engineers
Contractors
Civil Engineering Students
Published 4/2023
Created by Akshay Kamath
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 14 Lectures ( 3h 38m ) | Size: 1.86 GB
Download
http://s19.alxa.net/one/2023/04/Mic....Engineers.rar