Data Cleaning and Transformation Using Charts and S-Curves in Excel
A private company's water supply projects are analysed using labour data. The Planning engineer has to prepare the basic charts and S-curves for the deputed labor to check the prod…
Civil · Course
Excel Skills and Data Analysis for Construction Project Management
Strengthen your understanding of Excel Skills and Data Analysis for Construction Project Management in order to thrive in the industry!
- Duration
- 12 weeks
- Content
- 19 hours
- Projects
- 2
- Mode
- Online
OverviewWhat you'll
What you'll
be able to do.
- Data analysis and visualization are at the core of business operations in organizations across many industries.
- As a result of this, there’s an ever-growing demand for engineers skilled in data analysis using tools such as Microsoft Excel.
- By taking this course, you will learn about basic Excel functions, data formatting, inserting tables and graphs, conditional functions, and Pivot tables.
- This course will also elaborate on advanced Excel features such as analysis of large data sets, list functions, Visual Basics for Applications (VBA), and setting up email automation.
- Throughout this course, you will complete projects that require extensive use of Microsoft Excel to analyze large datasets as seen in the industry.
Tools you'll use
MS Excel
Curriculum10 modules,
10 modules,
built with industry.
01Excel Skills and Data Analysis for Construction Project Management
- Course Introduction and FundamentalsW01
- Introduction to the Course
- Launching Excel and Version Check
- Level 1
- Introduction to the Interface
- Saving an Excel Document
- Common Shortcuts
- Entering and Editing Data
- Relative and Absolute Cell References
- Formatting
- Customizing the Quick Access Toolbar
- Excel Self-help
- Basic Excel Functions and Modification of WorksheetW02
- Basic Functions
- Design of Excel Functions
- Understanding SUM(), MIN() and MAX()
- Understanding AVERAGE()
- Understanding COUNT()
- AutoSum and Autofill/Flash fill
- Modification
- Inserting New Sheets, Rows, and Columns
- Deleting Sheets, Rows, and Columns
- Moving or Copying Sheets
- Sheet Formatting
- Excel Options
- Customize Ribbon
- Basic Functions
- Data Formatting, Creating Your First Chart, and Working with Shapes and ImagesW03
- Data Formatting
- Cell Formatting – Merge, Alignment, etc.
- Borders
- Currencies and Percentages
- Format Painter
- Conditional Formatting
- Find and Search
- Shapes and Images
- Inserting Shapes and Images
- Formatting Excel Shapes
- SmartArt
- Creating your First Chart
- Creating Chart
- Chart Options
- Types of Charts
- Chart Formatting
- Date functions
- DATE() and DATEVALUE()
- NETWORKDAYS()
- EOMONTH() and EDATE()
- Data Formatting
- Introduction to Tables and Excel Templates, Excel Options and Printing Your Excel WorksheetsW04
- Excel Templates
- Introduction and Import Excel Template
- Custom Template
- Printing Worksheets
- Print Preview
- Margins and Scaling
- Page Layout
- Headers and Footers
- Specific Range
- Tables
- Introduction
- Table Options
- Table Formatting
- Table References
- Working with Formulae
- Benefits of Tables
- Excel Templates
- Conditional Functions and other FunctionsW05
- Conditional Functions
- Understanding IF()
- Understanding SUMIF() and SUMIFS()
- Understanding COUNTIF()
- Use of AND and OR with IF()
- Understanding IFERROR()
- Pivot Tables, and Lookup FunctionsW06
- Pivot Tables
- Data Source
- Pivot Table Structuring
- Pivot Table Options
- Pivot Table Formatting
- Lookup Functions
- Understanding VLOOKUP()
- Understanding HLOOKUP()
- Understanding INDEX and MATCH
- Understanding XLOOKUP()
- Understanding OFFSET()
- Pivot Tables
- New Functions, Data Tab and Introduction to Power QueryW07
- New Functions
- Understanding UNIQUE()
- Understanding FILTER()
- Understanding IFS()
- Understanding SORT(), SORTBY()
- Understanding SWITCH()
- Data Tab
- Data Import
- Data Cleaning and Transform
- Intro to Power Query
- Use of Power Query
- New Functions
- Advanced Pivot Table Functions, PowerPivot ToolsW08
- Advanced Pivot Table Functions
- Fields, Items, and Sets
- Pivot Charts
- Slicers and Timeline
- Group and Ungroup
- GETPIVOTDATA()
- PowerPivot Tools
- Introduction to Excel Power Pivot
- More Tables and Relationships
- Creating Data Models
- KPIs
- Advanced Pivot Table Functions
- Large Data Sets, File Protection, Named Ranges, and Data TabW09
- Working with Large Data sets
- Freeze Panes
- Grouping Data
- Consolidating Data from Multiple Worksheets
- File Protection
- Protecting Specific Cells in a Worksheet
- Protecting the Structure of a Workbook
- Adding a Workbook Password
- Data Tab
- Custom Sorting
- What-If Analysis
- Text to Columns
- Data Validation
- Understanding Data Validation
- Custom Data Validation Error
- Dynamic Formulas in Validation
- Working with Large Data sets
- List Functions, Excel Automation Using Macros and Email Automation and FinaleW10
- List Functions
- Understanding DSUM()
- Understanding DSUM() with AND/OR()
- Understanding DAVERAGE()
- Understanding DCOUNT()
- Understanding SUBTOTAL()
- Excel Automation using Macros
- Understanding Macros
- Creating Macro with Macro Recorder
- Email Automation
- Introduction to the Emailing Section
- Understanding Email Routine
- Email Loop
- List Functions
- Course Introduction and FundamentalsW01
Industry projects2 projects
2 projects
you'll ship.
Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 2 Projects that are available in this program.
Data Analysis Using Pivot Tables and Report Creation
In this project, students will be able to mold the big data into meaningful report by data analysis with the help of Pivot table. Also, students will get an exposure of Look up fun…
Go further
Part of a PG program.
FeeOne fee.
One fee.
Everything included.
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
Premium
₹40,000
Inclusive of all charges- 1 Year Access
- Personalized Page
- Live Individual & Group Sessions
- Personalized & Hands-On
- Job-Oriented Industry Relevant Curriculum
Related
You might also like.
PG program · 24 weeksConstruction Project Management→PG program · 48 weeksHigh-Rise Building Design & Analysis→PG program · 48 weeksSteel Structures→PG program · 48 weeksBridge Design and Analysis→PG program · 32 weeksInfrastructure - Engineering Design and Project Management→PG program · 48 weeksBuildings - Engineering Design and Project management→
Next stepNot sure it's
Not sure it's
the right fit?
A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.
₹40,000Course
Enquire