Engineeringly
Engineeringly
  • 460
  • 596 442
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
Переглядів: 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

КОМЕНТАРІ

  • @EngSultan98
    @EngSultan98 11 днів тому

    Nice and clear explanation

    • @Engineeringly
      @Engineeringly 11 днів тому

      Glad you found it helpful. Thanks for the positive feedback!

  • @fadzlifz2431
    @fadzlifz2431 12 днів тому

    Hi Sir.can this bar chart histogram transform into S curve with Exactly in "S Shaped".can you advise?

    • @Engineeringly
      @Engineeringly 9 днів тому

      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!

  • @poonamrani1309
    @poonamrani1309 12 днів тому

    beautiful example

    • @Engineeringly
      @Engineeringly 12 днів тому

      Hey, glad you found it helpful and thank you for the positive feedback

  • @JimLeonard
    @JimLeonard 18 днів тому

    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!

    • @Engineeringly
      @Engineeringly 18 днів тому

      @@JimLeonard Hey, glad it was of some use to you. Thank you for the positive feedback.

  • @Larry-lt2jr
    @Larry-lt2jr 25 днів тому

    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!

    • @Engineeringly
      @Engineeringly 24 дні тому

      Hey, it is really nice to see it has worked for you. Thank you for the positive feedback!

  • @gnidnoeled786
    @gnidnoeled786 29 днів тому

    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?

    • @Engineeringly
      @Engineeringly 29 днів тому

      @@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!

  • @KoperasiMelayuKampungKundangBe
    @KoperasiMelayuKampungKundangBe Місяць тому

    how do i set the weightage ?

    • @Engineeringly
      @Engineeringly Місяць тому

      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.

  • @gokhanpazarcik4531
    @gokhanpazarcik4531 Місяць тому

    very useful but a few key points missing such as how you created heading but anyway thanks

    • @Engineeringly
      @Engineeringly Місяць тому

      Thank you for sharing your feedback. Will definitely cover it in our upcoming videos.

  • @YoshevElazarMikael
    @YoshevElazarMikael Місяць тому

    Thank you.! Please make one that shows how you arrived at the percentages.

    • @Engineeringly
      @Engineeringly Місяць тому

      Hey, that’s in the example. But in real life problems, brainstorming is done with subject matter experts to obtain those percentages.

  • @ferdielopez1
    @ferdielopez1 Місяць тому

    Thanks a lot very clear and helpful

  • @jaroensriphosakkul9560
    @jaroensriphosakkul9560 Місяць тому

    How can I get the data used in this video?

    • @Engineeringly
      @Engineeringly Місяць тому

      Hey, thank you for engaging with our content. Can you comment down your email address.

  • @iBlueZx
    @iBlueZx Місяць тому

    Hi, Could you kindly provide the references used in this video?

    • @Engineeringly
      @Engineeringly Місяць тому

      Hey, will definitely post it under this comment.

  • @M4user
    @M4user 2 місяці тому

    Very nice. I like the simple way of the approach!

    • @Engineeringly
      @Engineeringly 2 місяці тому

      Thanks for the positive feedback. Glad you found it helpful!

  • @masterdebater147
    @masterdebater147 2 місяці тому

    Can you please send me this template?

    • @Engineeringly
      @Engineeringly 2 місяці тому

      Hey, can you comment your email address down here.

  • @utsavjangra07
    @utsavjangra07 2 місяці тому

    Few hours left for my exam🤓

  • @nikhilpatil4877
    @nikhilpatil4877 2 місяці тому

    Exactly what I needed. Thank you very much

    • @Engineeringly
      @Engineeringly 2 місяці тому

      And so glad you found it at Engineeringly. Stay turned for more and thank you for the positive feedback.

  • @shareqinamdar8903
    @shareqinamdar8903 3 місяці тому

    Very knowledgeable video

    • @Engineeringly
      @Engineeringly 3 місяці тому

      Hi Shareq, glad you found our content helpful. Stay tuned for more!

  • @ahmed007Jaber
    @ahmed007Jaber 3 місяці тому

    thank you for this. would be helpful if the file was attached

    • @Engineeringly
      @Engineeringly 3 місяці тому

      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

  • @frvideos3788
    @frvideos3788 3 місяці тому

    Please share template

    • @Engineeringly
      @Engineeringly 3 місяці тому

      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

  • @KennethThomas-c1w
    @KennethThomas-c1w 3 місяці тому

    2985 Brigitte Expressway

  • @GretchenTurbyfill-f5w
    @GretchenTurbyfill-f5w 4 місяці тому

    Maggio Wells

  • @TheKulinos
    @TheKulinos 4 місяці тому

    Thank you. Your videos are all comprehensible....

    • @Engineeringly
      @Engineeringly 4 місяці тому

      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.

  • @s2000pill
    @s2000pill 4 місяці тому

    can you just create one for me and i pay you?

    • @Engineeringly
      @Engineeringly 4 місяці тому

      @@s2000pill hey, let’s discuss this through email at qaderhotak_3@hotmail.com or LinkedIn www.linkedin.com/in/aqhotak

  • @studyingwhileinyourprime4691
    @studyingwhileinyourprime4691 4 місяці тому

    It will be better if you start with how, you created your headings and those task heading, then one can follow better.

    • @Engineeringly
      @Engineeringly 4 місяці тому

      Hey, thank you for the constructive feedback. We will definitely take this into account going forward.

  • @krishnamaruthipeddinti2024
    @krishnamaruthipeddinti2024 4 місяці тому

    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

  • @goodhomes1041
    @goodhomes1041 4 місяці тому

    750/100=7.5+1=8.5 BUT U TOLD 8 HOW?

    • @Engineeringly
      @Engineeringly 4 місяці тому

      Hey, thank you very much for bringing this up. And you’re absolutely right, it should be 8.5 rounded up to 9.

  • @amehjosephonyeke9115
    @amehjosephonyeke9115 4 місяці тому

    Very Concise

    • @Engineeringly
      @Engineeringly 4 місяці тому

      Thank you very much for the positive feedback!

  • @Mallickvision
    @Mallickvision 4 місяці тому

    www.youtube.com/@Mallickvision

  • @Mallickvision
    @Mallickvision 4 місяці тому

    www.youtube.com/@Mallickvision

  • @Mallickvision
    @Mallickvision 4 місяці тому

    Thanks for 250 subs @visionengineering

  • @azadehamiri5723
    @azadehamiri5723 4 місяці тому

    Thanks a lot. It was exactly what I wanted!!

    • @Engineeringly
      @Engineeringly 4 місяці тому

      Glad that we were able to have what you needed. Thank you for engaging with our content.

  • @abuthanha
    @abuthanha 5 місяців тому

    Nice, with right time and contents, not extra fittings

    • @Engineeringly
      @Engineeringly 5 місяців тому

      @@abuthanha Thank you very much!

  • @VaraprasadPammi-t8i
    @VaraprasadPammi-t8i 5 місяців тому

    Provide the sample data file for practice...

    • @Engineeringly
      @Engineeringly 5 місяців тому

      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

  • @vijayanandsingh9918
    @vijayanandsingh9918 5 місяців тому

    Can you share the template pls

    • @Engineeringly
      @Engineeringly 5 місяців тому

      Hey Vijay, sure thing. Comment down your email address.

  • @Vishu2711
    @Vishu2711 5 місяців тому

    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.

    • @Engineeringly
      @Engineeringly 5 місяців тому

      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!

  • @harshrt26
    @harshrt26 5 місяців тому

    How do reduce size of column to look like a line (name location bar) ?? @enginnerigly

  • @HumbertoDaSilvaSantos-pz2nu
    @HumbertoDaSilvaSantos-pz2nu 5 місяців тому

    Thank you so much for the nice explanation. I just wonder what kind of probability distribution was used?

  • @neha210888
    @neha210888 6 місяців тому

    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?

  • @Suwalah_Almadinah
    @Suwalah_Almadinah 6 місяців тому

    great video!

  • @paulaandreacondequinones1438
    @paulaandreacondequinones1438 6 місяців тому

    Hi!! I think you might have forgotten to leave the link of the data :(

  • @max_olive
    @max_olive 6 місяців тому

    Great work! Has helped me a lot

    • @Engineeringly
      @Engineeringly 6 місяців тому

      Thank you very much for the positive feedback. We’re glad that our work is having a positive impact!

  • @theinfinityzeal-vq5zu
    @theinfinityzeal-vq5zu 6 місяців тому

    Please suggest me between project management or engineering management. I want to pursue for masters. I am a civil engineer.

    • @Engineeringly
      @Engineeringly 6 місяців тому

      @@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!

  • @swathirockk7
    @swathirockk7 6 місяців тому

    Superb

  • @IamHariOm90
    @IamHariOm90 6 місяців тому

    Hello ... can we write a function for the same ??

    • @Engineeringly
      @Engineeringly 6 місяців тому

      Hey, what kind of function do you mean?

  • @janakiram.1968
    @janakiram.1968 6 місяців тому

    Simple and in-depth explanation. Thank you,🤝

    • @Engineeringly
      @Engineeringly 6 місяців тому

      Thank you for the positive feedback!

    • @janakiram.1968
      @janakiram.1968 6 місяців тому

      @@Engineeringly The credit goes to the esteemed brain who developed this excel sheet for beginners.. highly respected sir

  • @victorantony9248
    @victorantony9248 7 місяців тому

    Can u please share this file ?

    • @Engineeringly
      @Engineeringly 7 місяців тому

      Hey, thank you for the positive feedback. Comment your email address or reach out to me at www.linkedin.com/in/aqhotak

  • @MarcosDias-xf1lt
    @MarcosDias-xf1lt 7 місяців тому

    great

    • @Engineeringly
      @Engineeringly 7 місяців тому

      Thank you for the positive feedback!

  • @swathirockk7
    @swathirockk7 7 місяців тому

    Nice

    • @Engineeringly
      @Engineeringly 7 місяців тому

      Thank you for the positive feedback!

  • @swathirockk7
    @swathirockk7 7 місяців тому

    Superb explanation

  • @youssefsherif32
    @youssefsherif32 7 місяців тому

    thank you fo uploading this video can you please attach this file in a link so i can practice using these functions

    • @Engineeringly
      @Engineeringly 7 місяців тому

      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.