Menu

Executive Programs

Workshops

Projects

Blogs

Careers

Student Reviews



More

Academic Training

Informative Articles

Find Jobs

We are Hiring!


All Courses

Choose a category

Loading...

All Courses

All Courses

logo

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!

Book a Class, for FREE

RELATED RECENT PLACEMENTS

Parthiban M

Riverstone

SRM TRP Engineering College

Kotesh Mogudala

Tata Autocomp Systems

Anurag University, Hyderabad

Vipin Jiwane

Orena Solutions

Walchand College of Engineering, Sangli

Chandrakumar ADEPU

Selec Control

Ganapathy Engineering College

Jiji M

Adrasti

Sreepathy Institute of Management And Technology (SIMAT)

Durga Prasad Sunnam

Adrasti

Ucet Technical school in Dokiparru, Andhra Pradesh

Pratik Mankar

Adrasti

B R Harne College Of Engineering

MAHATHIR MOHAMED

TATsunoInida Pvt ltd

K.S.K College of Engineering and Technology

Syllabus

This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects

Course Overview

  • 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.

Course Syllabus

On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.

Week 01 - Course Introduction and Fundamentals

  • 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

Week 02 - Basic Excel Functions and Modification of Worksheet

  • 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

Week 03 - Data Formatting, Creating Your First Chart, and Working with Shapes and Images

  • 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()

Week 04 - Introduction to Tables and Excel Templates, Excel Options and Printing Your Excel Worksheets

  • 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

Week 05 - Conditional Functions and other Functions

  • Conditional Functions
  • Understanding IF()
  • Understanding SUMIF() and SUMIFS()
  • Understanding COUNTIF()
  • Use of AND and OR with IF()
  • Understanding IFERROR()

Week 06 - Pivot Tables, and Lookup Functions

  • 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()

Week 07 - New Functions, Data Tab and Introduction to Power Query

  • 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

Week 08 - Advanced Pivot Table Functions, PowerPivot Tools

  • 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

Week 09 - Large Data Sets, File Protection, Named Ranges, and Data Tab

  • 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

Week 10 - List Functions, Excel Automation Using Macros and Email Automation and Finale

  • 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

Our courses have been designed by industry experts to help students achieve their dream careers

Industry Projects

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 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 productivity and revised planning.

 

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 functions to search and sort data.

Our courses have been designed by industry experts to help students achieve their dream careers

Ratings & Reviews by Learners

Skill-Lync has received honest feedback from our learners around the globe.

Google Rating
4.8

Excel Skills and Data Analysis for Construction Project Management

Flexible Pricing

Talk to our career counsellors to get flexible payment options.

Premium

INR 40,000

Inclusive of all charges


Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals

  • 1 Year Accessto Skill-Lync’s Learning Management System (LMS)

  • Personalized Pageto showcase Projects & Certifications

  • Live Individual & Group Sessionsto resolve queries, Discuss Progress and Study Plans.

  • Personalized & Hands-OnSupport over Mail, Telephone for Query Resolution & Overall Learner Progress.

  • Job-Oriented Industry Relevant Curriculumavailable at your fingertips curated by Global Industry Experts along with Live Sessions.

Instructors profiles

Our courses are designed by leading academicians and experienced industry professionals.

image

1 industry expert

Our instructors are industry experts along with a passion to teach.

image

12 years in the experience range

Instructors with 12 years extensive industry experience.

image

Areas of expertise

  • Full Stack development
  • SQL

Similar Courses

Got more questions?

Talk to our Team Directly

Please fill in your number & an expert from our team will call you shortly.

Please enter a valid number