- 460
- 596 442
Engineeringly
Приєднався 30 бер 2022
Next milestone is 10,000 learning enthusiasts in our community!
Successful projects are not about knowing the processes and preparing a series of documents. It is also about getting the expected results, outcomes, and value.
We aim to make Engineeringly an all-in-one destination for improving the skills of practitioners and learners. Our primary goal at Engineeringly is to teach Project Management and Civil Engineering in practice using the latest tools and techniques.
Our experienced team consists of professionals in Civil Engineering, Project Management, Information Technology, and Management Information Systems.
If you enjoy the content and want to enhance your skills, consider subscribing to the channel.
To explore more materials and resources, consider visiting our platforms:
Successful projects are not about knowing the processes and preparing a series of documents. It is also about getting the expected results, outcomes, and value.
We aim to make Engineeringly an all-in-one destination for improving the skills of practitioners and learners. Our primary goal at Engineeringly is to teach Project Management and Civil Engineering in practice using the latest tools and techniques.
Our experienced team consists of professionals in Civil Engineering, Project Management, Information Technology, and Management Information Systems.
If you enjoy the content and want to enhance your skills, consider subscribing to the channel.
To explore more materials and resources, consider visiting our platforms:
How to Create a Project Progress Report in Google Sheets (Using Checkboxes & Conditional Formatting)
Want to track your project progress efficiently? 📊 In this tutorial, I'll show you how to use checkboxes and conditional formatting in Google Sheets to create a dynamic and visually appealing progress report. Whether you're managing construction projects, tracking tasks, or handling project management reports, this step-by-step guide will help you stay organized!
🔹 What you’ll learn in this video:
✔️ How to insert and use checkboxes in Google Sheets
✔️ Applying conditional formatting to track project progress
✔️ Automating status updates with simple formulas
✔️ Enhancing project visibility with a color-coded progress system
💡 Perfect for:
- Civil Engineers
- Project Managers
- Data Analysts
- Anyone who wants to improve project tracking in Google Sheets
✅ Don't forget to LIKE 👍, SHARE, and SUBSCRIBE for more tutorials on civil engineering, project management, and data handling!
Hashtags:
#Engineeringly #GoogleSheets #ProjectManagement #ProgressTracking #ExcelTips #GoogleSheetsTips #CivilEngineering #DataAnalysis #ConditionalFormatting #SpreadsheetTips #TaskManagement #Excel #ExcelTips
🔹 What you’ll learn in this video:
✔️ How to insert and use checkboxes in Google Sheets
✔️ Applying conditional formatting to track project progress
✔️ Automating status updates with simple formulas
✔️ Enhancing project visibility with a color-coded progress system
💡 Perfect for:
- Civil Engineers
- Project Managers
- Data Analysts
- Anyone who wants to improve project tracking in Google Sheets
✅ Don't forget to LIKE 👍, SHARE, and SUBSCRIBE for more tutorials on civil engineering, project management, and data handling!
Hashtags:
#Engineeringly #GoogleSheets #ProjectManagement #ProgressTracking #ExcelTips #GoogleSheetsTips #CivilEngineering #DataAnalysis #ConditionalFormatting #SpreadsheetTips #TaskManagement #Excel #ExcelTips
Переглядів: 95
Відео
How to Create Project Progress Reports in Google Sheets | Step-by-Step Tutorial
Переглядів 101День тому
Learn how to efficiently create project progress reports using Google Sheets in this comprehensive tutorial. We'll guide you through setting up your spreadsheet, defining key columns such as Task Name, Assigned To, Start Date, End Date, Status, and Comments, and utilizing powerful functions to visualize your data. Enhance your project management skills with practical tips and tricks to keep you...
How to Create a Gantt Chart in Google Sheets: Step-by-Step Tutorial
Переглядів 50314 днів тому
Learn how to create a Gantt chart in Google Sheets using conditional formatting. This step-by-step tutorial will guide you through setting up your data, applying conditional formatting, and customizing your Gantt chart. Perfect for project management and tracking progress. Hashtags: #Engineeringly #GanttChart #GoogleSheets #ProjectManagement #DataAnalysis #DataVisualization #Productivity #TimeM...
What is the Difference between Determinate and Indeterminate Structures?
Переглядів 8121 день тому
Ever wondered how engineers determine the stability of structures like bridges and skyscrapers? 🤔 In this video, we break down the key differences between determinate and indeterminate structures. Learn the basics of structural engineering, explore real-world examples, and discover why understanding these concepts is crucial for ensuring safety in design and construction. 🚧 👉 Whether you're a c...
What is Cost Engineering?
Переглядів 134Місяць тому
Welcome to an in-depth exploration of cost engineering-a critical field that ensures the success of projects by managing budgets, resources, and financial risks. Whether you’re a civil engineer, project manager, or a student eager to learn, this video provides a step-by-step breakdown of everything you need to know about cost engineering. We’ll cover the fundamentals of cost estimation, cost co...
Cost of Conformance vs Cost of Non-Conformance | Quality Management Made Simple
Переглядів 182Місяць тому
What’s more expensive: preventing problems or fixing them after they occur? In this video, I’ll explain the critical concepts of Cost of Conformance and Cost of Non-Conformance in Quality Management. Whether you're a project manager, quality control specialist, or just curious about how businesses maintain quality standards, this video is for you! Here’s what we’ll cover: 1️⃣ What is the Cost o...
Top 5 Google Sheets Data Cleaning Functions You Must Know!
Переглядів 1282 місяці тому
Working with messy data in Google Sheets? Cleaning and organizing your data doesn’t have to be overwhelming. With the right tools, you can streamline your workflow and make your data analysis more efficient. In this video, I’ll walk you through the top 5 data cleaning functions in Google Sheets-simple yet powerful techniques that can transform the way you handle spreadsheets. Whether you’re a b...
What Does a Construction Project Manager Do? Roles, Duties, and Key Principles Explained
Переглядів 1752 місяці тому
What Does a Construction Project Manager Do? Roles, Duties, and Key Principles Explained
PMP Exam Questions Solved | Clear Your PMP Certification with Confidence!
Переглядів 842 місяці тому
PMP Exam Questions Solved | Clear Your PMP Certification with Confidence!
Concrete Column Construction Explained: Step-by-Step with Real Project Footage
Переглядів 7673 місяці тому
Concrete Column Construction Explained: Step-by-Step with Real Project Footage
Agile in Construction: Revolutionizing Project Management
Переглядів 1933 місяці тому
Agile in Construction: Revolutionizing Project Management
Mastering Column Design with Interaction Diagrams | Reinforced Concrete Basics
Переглядів 6663 місяці тому
Mastering Column Design with Interaction Diagrams | Reinforced Concrete Basics
Stakeholder Influence and Interest Matrix Explained | Power-Interest Grid in Project Management
Переглядів 4543 місяці тому
Stakeholder Influence and Interest Matrix Explained | Power-Interest Grid in Project Management
Create a To-Do List with Checkboxes in Google Sheets
Переглядів 4633 місяці тому
Create a To-Do List with Checkboxes in Google Sheets
How to Create Pareto Charts in Excel | Simple Step-by-Step Tutorial
Переглядів 4684 місяці тому
How to Create Pareto Charts in Excel | Simple Step-by-Step Tutorial
The Critical Role & Importance of a Site Engineer in Construction Projects
Переглядів 3024 місяці тому
The Critical Role & Importance of a Site Engineer in Construction Projects
Cantilever Beam Design Calculator Using ACI 318 | Step-by-Step Tutorial
Переглядів 3284 місяці тому
Cantilever Beam Design Calculator Using ACI 318 | Step-by-Step Tutorial
Excel Milestone Chart Tutorial: Step-by-Step Guide for Project Managers
Переглядів 6524 місяці тому
Excel Milestone Chart Tutorial: Step-by-Step Guide for Project Managers
How to Connect Multiple Files in Power Query for Power BI | Step-by-Step Guide
Переглядів 4745 місяців тому
How to Connect Multiple Files in Power Query for Power BI | Step-by-Step Guide
Master Project Management: Essential Charts You Need to Know for Success
Переглядів 2025 місяців тому
Master Project Management: Essential Charts You Need to Know for Success
Why Project Dashboards Are Essential for Effective Project Management?
Переглядів 1185 місяців тому
Why Project Dashboards Are Essential for Effective Project Management?
Essential Documents and Reports for Construction Projects
Переглядів 2295 місяців тому
Essential Documents and Reports for Construction Projects
10 Essential Terms Every Structural Engineer Must Know
Переглядів 3786 місяців тому
10 Essential Terms Every Structural Engineer Must Know
Ultimate Project Management Tips for Efficient Civil Engineering Projects
Переглядів 1046 місяців тому
Ultimate Project Management Tips for Efficient Civil Engineering Projects
How to Create a Histogram in Google Sheets | Step-by-Step Tutorial
Переглядів 2106 місяців тому
How to Create a Histogram in Google Sheets | Step-by-Step Tutorial
3 Hidden Excel Features You Need to Know
Переглядів 1486 місяців тому
3 Hidden Excel Features You Need to Know
Excel Flash Fill: Boost Your Productivity with These Quick Tips
Переглядів 1467 місяців тому
Excel Flash Fill: Boost Your Productivity with These Quick Tips
Master Google Sheets Pivot Tables: Step-by-Step Tutorial
Переглядів 1897 місяців тому
Master Google Sheets Pivot Tables: Step-by-Step Tutorial
Top 12 Essential Excel Functions Every Project Manager Must Know
Переглядів 8127 місяців тому
Top 12 Essential Excel Functions Every Project Manager Must Know
Data Visualization with Power BI: A Beginner's Guide
Переглядів 2,2 тис.7 місяців тому
Data Visualization with Power BI: A Beginner's Guide
Nice and clear explanation
Glad you found it helpful. Thanks for the positive feedback!
Hi Sir.can this bar chart histogram transform into S curve with Exactly in "S Shaped".can you advise?
Hey, thank you for engaging with our content. This is actually a really good content idea for us. We will make sure to have this video in our plan as soon as we can. Stay turned!
beautiful example
Hey, glad you found it helpful and thank you for the positive feedback
This is the only tutorial I found that actually treats the timeline as a date series and not just a set of equal points. Excellent work!
@@JimLeonard Hey, glad it was of some use to you. Thank you for the positive feedback.
Hello, and thank you for sharing this presentation. This gave me the ideal solution for my requirement, which was to provide a visualization tool for a budget plan. I generated my chart from scratch, using your excellent and easy-to-follow walkthrough as my guide. I included various formulas in my worksheet, as well as an overview/summary section, or "baseball card", that could serve as an alternative way to provide a status report, rather than only using the chart itself. What I basically mean is that I had fun with this while completing my task. :) Thank you, and best wishes!
Hey, it is really nice to see it has worked for you. Thank you for the positive feedback!
You are saying that shear in columns is high in the support or on its ends. What about the bending moments? is it also high at the ends of the column? Is it because of the dynamic loads i.e. wind and earthquake?
@@gnidnoeled786 Hey, thank you for asking this question. Yes, shear is generally maximum at both ends and decreases towards the center. While bending moment varies case by case. Although it’s usually highest at the ends, while some deflections in the column might result in having higher moments in its center compared to the ends. Hope that helps!
how do i set the weightage ?
Hey, thank you for the question. The weightage for each activity is allocated either by the amount of effort it requires, the duration, or the cost of the activity. It’s subjective, and varies from project to project.
very useful but a few key points missing such as how you created heading but anyway thanks
Thank you for sharing your feedback. Will definitely cover it in our upcoming videos.
Thank you.! Please make one that shows how you arrived at the percentages.
Hey, that’s in the example. But in real life problems, brainstorming is done with subject matter experts to obtain those percentages.
Thanks a lot very clear and helpful
Glad it has helped!
How can I get the data used in this video?
Hey, thank you for engaging with our content. Can you comment down your email address.
Hi, Could you kindly provide the references used in this video?
Hey, will definitely post it under this comment.
Very nice. I like the simple way of the approach!
Thanks for the positive feedback. Glad you found it helpful!
Can you please send me this template?
Hey, can you comment your email address down here.
Few hours left for my exam🤓
I’m sure you’ve nailed it!
Exactly what I needed. Thank you very much
And so glad you found it at Engineeringly. Stay turned for more and thank you for the positive feedback.
Very knowledgeable video
Hi Shareq, glad you found our content helpful. Stay tuned for more!
thank you for this. would be helpful if the file was attached
Hey Ahmed, thank you for the positive feedback. Comment down your email so I can send the document to you or reach out to me directly on LinkedIn at www.linkedin.com/in/aqhotak
Please share template
Hey, thank you for engaging with our content. Comment your email address or reach out to me on LinkedIn at www.linkedin.com/in/aqhotak
2985 Brigitte Expressway
Maggio Wells
Thank you. Your videos are all comprehensible....
Hey there. Thank you very much for the positive feedback. It helps us immensely to align our content with our audience’s interests and expectations.
can you just create one for me and i pay you?
@@s2000pill hey, let’s discuss this through email at qaderhotak_3@hotmail.com or LinkedIn www.linkedin.com/in/aqhotak
It will be better if you start with how, you created your headings and those task heading, then one can follow better.
Hey, thank you for the constructive feedback. We will definitely take this into account going forward.
Thank you verymuch for the video. this is really helpful. want to ask 2 queries. 1. the scattered lines for the y axis is not exactly below the gantt chart, the first one is exactly below the progress gantt but the second and third are in middle of the progress bar. fourth one is top of the progress bar. how should i make it bottom for all planned lines. 2. i need a pause of the work . for ex. if first work is 60% completed but a priority work 2 has interrupted it for 1 day again i continued work 1 from 60% second day, it means a day pause in work 1. how can i represent it in the gantt chart and the interrupt ? Please let me know the solution for the above 2 issue. Thanks in advance
750/100=7.5+1=8.5 BUT U TOLD 8 HOW?
Hey, thank you very much for bringing this up. And you’re absolutely right, it should be 8.5 rounded up to 9.
Very Concise
Thank you very much for the positive feedback!
www.youtube.com/@Mallickvision
www.youtube.com/@Mallickvision
Thanks for 250 subs @visionengineering
👏👏👏
Thanks a lot. It was exactly what I wanted!!
Glad that we were able to have what you needed. Thank you for engaging with our content.
Nice, with right time and contents, not extra fittings
@@abuthanha Thank you very much!
Provide the sample data file for practice...
Hi Prasad, thank you for engaging with our content. Comment your email address or reach out to me on LinkedIn at www.linkedin.com/in/aqhotak
Can you share the template pls
Hey Vijay, sure thing. Comment down your email address.
hello sir , I have completed diploma in automobile engineering. I am intrested in product manager and egineering management what further course should i study ? after diploma im thinking to for btech(bachelors degree) but in what stream should i do im confussed plzz help, My goal/intrest is engineering management or product manager.
Hi, Thanks for reaching out! If you’re interested in Engineering Management, consider a B.Tech in Mechanical or Industrial Engineering to strengthen your technical and management skills. For Product Management, a B.Tech in fields like Computer Science or Electrical Engineering, paired with courses in business or project management, could be ideal. Choose the path that aligns best with your long-term career goals. Good luck, and feel free to ask more questions!
How do reduce size of column to look like a line (name location bar) ?? @enginnerigly
Thank you so much for the nice explanation. I just wonder what kind of probability distribution was used?
Thanks for sharing this. @Engineeringly When I enable category name 3:38, it is displaying dates and not the milestone name. Could you please let me know what needs to be corrected here?
great video!
Thank you very much!
Hi!! I think you might have forgotten to leave the link of the data :(
Great work! Has helped me a lot
Thank you very much for the positive feedback. We’re glad that our work is having a positive impact!
Please suggest me between project management or engineering management. I want to pursue for masters. I am a civil engineer.
@@theinfinityzeal-vq5zu Thank you for your question! As a civil engineer, choosing between engineering management and project management depends on your interests and career goals. If you're passionate about core civil engineering subjects like structural analysis and design, engineering management might be the right path for you. This field allows you to stay close to the technical aspects while also gaining management skills. On the other hand, if you're more interested in overseeing projects from start to finish-managing scope, costs, and stakeholders-then project management could be a better fit. This path will equip you with the skills to lead projects in various industries. Consider what excites you more and aligns with your career aspirations. Good luck!
Superb
Thank you!
Hello ... can we write a function for the same ??
Hey, what kind of function do you mean?
Simple and in-depth explanation. Thank you,🤝
Thank you for the positive feedback!
@@Engineeringly The credit goes to the esteemed brain who developed this excel sheet for beginners.. highly respected sir
Can u please share this file ?
Hey, thank you for the positive feedback. Comment your email address or reach out to me at www.linkedin.com/in/aqhotak
great
Thank you for the positive feedback!
Nice
Thank you for the positive feedback!
Superb explanation
Thank you very much!
thank you fo uploading this video can you please attach this file in a link so i can practice using these functions
Hi Youssef, thank you for the positive feedback. Please comment down your email or reach out to me on LinkedIn at www.linkedin.com/in/aqhotak to get the file.