|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-for-construction-management-civil-engineers/
课程评论：没有评论
Coursera 课程《MS-Excel For Civil Engineers for Project Planning From Zero》是一门从零开始的进阶课程，旨在帮助学员成为优秀的工程专业人士。 **课程概述：** 本课程强调 MS Excel 在建筑行业的强大功能，涵盖从估算、规划、钢筋排布表到结构设计等各个环节。课程内容循序渐进，从基础命令到高级应用，并结合实际项目，帮助学员深入理解并热爱 Excel 工具。 **课程重点内容：** * **Excel 基础介绍：** * 屏幕概览、导航和基本电子表格概念 * 各种选择技巧 * 快捷键 * **Excel 自定义：** * 自定义功能区 * 使用和自定义自动更正 * 更改 Excel 的默认选项 * **基础函数应用：** * Sum, Average, Max, Min, Count, Counta 等函数 * 绝对引用、混合引用和相对引用 * **格式化与校对：** * 货币格式、格式刷 * 日期格式、自定义和特殊格式 * 单元格格式（数字、字体、对齐、边框等） * 基本条件格式 * **数学函数：** * SumIf, SumIfs, CountIf, CountIfs, AverageIf, AverageIfs * Nested IF, IFERROR Statement, AND, OR, NOT * **文本函数：** * Upper, Lower, Proper * Left, Mid, Right * Trim, Len, Exact * Concatenate * Find, Substitute * **Excel 保护：** * 文件级保护 * 工作簿和工作表保护 **课程特色：** 本课程还将涵盖更多实用技巧，并应用于具体的建筑工程项目，如创建用于工程估算、项目规划和结构设计的 Excel 表格。 **目标学员：** 希望在建筑行业中提升工程规划和数据处理能力的在校学生和年轻工程师。
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
