Excel Skills and Data Analysis for Construction Project Management
RELATED RECENT PLACEMENTS
Rohit Mali
William O'Neil India
NMIMS MUMBAI
Dhiraj Satghare
RD Civil Solution
Acharya Shrimannarayan Polytechnic
Namrata Rao
Piaggio & C. S.p.A.
Rajeev Gandhi College of Engg and Research Institute
Siddhi Parab
C.C Engineers
lokmanya tilak college of engineering
Anil Katarkar
3D engineering
NATIONAL INSTITUTE OF TECHNOLOGY
Bhavesh Kumbhare
Dar Al-Handasah Engineering company
Rashtrasant Tukadoji Maharaj Nagpur University
Akash Bhadkumbe
XS CAD
Dr. D Y Patil College of Engineering & Innovation, Varale
Madhura Joshi
NEILSOFT LIMITED
Government Polytechnic Ratnagiri
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.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
1 industry expert
Our instructors are industry experts along with a passion to teach.
12 years in the experience range
Instructors with 12 years extensive industry experience.
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.