- Видео 431
- Просмотров 452 104
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:
Why Project Dashboards Are Essential for Effective Project Management?
In this video, we explore why project dashboards are indispensable for successful project management. Dashboards provide real-time insights, improve decision-making, and enhance team collaboration. I also discuss my experience in creating dashboards using Excel, Power BI, Microsoft Project, and Google Sheets, and how you can leverage these tools to boost your project’s success.
Timestamps:
0:00 - Introduction
0:21 - What is a Dashboard?
0:36 - Why Dashboards are Essential
2:20 - My Experience with Dashboards
2:55 - Conclusion
Check Out My Other Dashboard Tutorials:
Creating Dashboards in Excel: ruclips.net/video/5mZ5jwQU3Fk/видео.html&pp=gAQBiAQB
Power BI: ruclips.net/video/C3E4dnGawOo/видео.html&...
Timestamps:
0:00 - Introduction
0:21 - What is a Dashboard?
0:36 - Why Dashboards are Essential
2:20 - My Experience with Dashboards
2:55 - Conclusion
Check Out My Other Dashboard Tutorials:
Creating Dashboards in Excel: ruclips.net/video/5mZ5jwQU3Fk/видео.html&pp=gAQBiAQB
Power BI: ruclips.net/video/C3E4dnGawOo/видео.html&...
Просмотров: 40
Видео
Essential Documents and Reports for Construction Projects
Просмотров 82День назад
Effective documentation is the backbone of any successful construction project. In this video, we dive into the key documents and reports every construction project manager needs to manage for smooth project execution. From project charters and contracts to progress reports and punch lists, we cover everything you need to know to keep your construction project on track, within budget, and on ti...
10 Essential Terms Every Structural Engineer Must Know
Просмотров 18314 дней назад
In this video, we break down the 10 essential terms every structural engineer must know. Whether you're an engineering student, a practicing professional, or simply interested in structural engineering, these key terms are fundamental to understanding and excelling in the field. We cover crucial concepts such as load, stress, strain, moment, shear force, deflection, yield strength, factor of sa...
Ultimate Project Management Tips for Efficient Civil Engineering Projects
Просмотров 7521 день назад
Unlock the secrets to efficient project management in civil engineering with our ultimate guide! In just 3 minutes, we’ll cover essential tips on effective communication, time management, risk management, and the best software tools to streamline your projects and boost productivity. Perfect for both seasoned professionals and newcomers alike. Key Topics Covered: 1. Effective Communication Stra...
How to Create a Histogram in Google Sheets | Step-by-Step Tutorial
Просмотров 49Месяц назад
In this tutorial, learn how to create and customize a histogram in Google Sheets to effectively visualize your data distribution. Histograms are powerful tools for analyzing numerical data by showing the frequency of values within specified ranges. This video covers everything from preparing your data and inserting a histogram to customizing and interpreting the results. Whether you're analyzin...
3 Hidden Excel Features You Need to Know
Просмотров 89Месяц назад
Unlock the power of Excel with these three hidden features that will revolutionize the way you work with data! In this quick, 3-minute tutorial, we'll reveal the Quick Analysis Tool, Sparklines, and Text to Columns-three powerful tools that can save you time and boost your productivity. Whether you're a beginner or an experienced user, these tips will help you get more out of Excel. 🔍 Quick Ana...
Excel Flash Fill: Boost Your Productivity with These Quick Tips
Просмотров 112Месяц назад
Unlock the power of Excel Flash Fill in this quick and easy tutorial! Learn how to automatically format and split data with just a few keystrokes. Whether you're a beginner or an advanced user, these tips will help you work smarter, not harder. Chapters: 0:00 Introduction 0:15 What is Flash Fill? 0:41 Example 1: Splitting Full Names 1:35 Example 2: Formatting Phone Numbers 2:05 Custom Number Fo...
Master Google Sheets Pivot Tables: Step-by-Step Tutorial
Просмотров 69Месяц назад
Unlock the full potential of your data with pivot tables in Google Sheets! In this comprehensive tutorial, we’ll guide you through the basics and advanced techniques of using pivot tables to summarize, analyze, and present your data effectively. Whether you're a beginner or looking to enhance your data skills, this video has everything you need to become a pivot table pro. Chapters: 0:00 Introd...
Top 12 Essential Excel Functions Every Project Manager Must Know
Просмотров 390Месяц назад
Are you a project manager looking to enhance your Excel skills? In this video, we cover the top 12 essential Excel functions that every project manager should know. These functions will help you manage your projects more efficiently and effectively. In this video, you'll learn about: - IF - COUNTA - COUNTIF - SUMIF - AVERAGEIF - VLOOKUP - INDEX - MATCH - NETWORKDAYS - TRIM - PROPER - CONCATENAT...
Data Visualization with Power BI: A Beginner's Guide
Просмотров 5742 месяца назад
Welcome to our comprehensive guide on data visualization with Power BI for beginners! In this tutorial, we will walk you through everything you need to know to get started with Power BI, from connecting to data sources, transforming data, creating stunning visualizations, to designing interactive dashboards and sharing your reports. In this video, you will learn: - How to download and install P...
Earned Value Analysis (S-Curve): Step-by-Step Excel Tutorial
Просмотров 5272 месяца назад
Unlock the full potential of Earned Value Analysis (EVA) and learn how to create S-curves in Microsoft Excel with this step-by-step tutorial. Perfect for project managers, analysts, and anyone keen on improving project tracking and performance measurement, this video covers everything you need to know from the basics to advanced implementation. Why Earned Value Analysis? Earned Value Analysis (...
Mastering Data Visualization: 6 Key Tips You Should Know
Просмотров 1592 месяца назад
Learn the essential best practices for data visualization using Excel, Power BI, and Google Sheets. In this video, we’ll guide you through the key principles and techniques to create clear, impactful, and insightful visualizations. Whether you’re a civil engineer, project manager, or data analyst, these tips will help you make the most out of your data. Don’t forget to like, comment, and subscr...
How to Use the Percentile Function in Excel to Categorize Large Datasets
Просмотров 1042 месяца назад
Learn how to use the powerful Percentile function in Excel to efficiently categorize and analyze large datasets. This tutorial covers step-by-step instructions, practical examples, and tips to enhance your data analysis skills. Perfect for beginners and advanced users alike, discover how you can leverage the Percentile function to gain deeper insights from your data. In this video, you will lea...
Tuckman's Ladder: Things Every Project Manager Should Know
Просмотров 893 месяца назад
Tuckman's Ladder: Things Every Project Manager Should Know
Radar Charts in Excel: A Step-by-Step Guide
Просмотров 1303 месяца назад
Radar Charts in Excel: A Step-by-Step Guide
Waterfall Charts: Excel Tutorial for Beginners
Просмотров 1713 месяца назад
Waterfall Charts: Excel Tutorial for Beginners
Debunking 3 Common Myths About Civil Engineering
Просмотров 1113 месяца назад
Debunking 3 Common Myths About Civil Engineering
Master Schedules in Microsoft Project: A Comprehensive Guide
Просмотров 5644 месяца назад
Master Schedules in Microsoft Project: A Comprehensive Guide
Punching Shear: Things Every Engineer Should Know
Просмотров 6264 месяца назад
Punching Shear: Things Every Engineer Should Know
Ultimate Scheduling Software Showdown: A Comprehensive Comparison
Просмотров 1394 месяца назад
Ultimate Scheduling Software Showdown: A Comprehensive Comparison
Project Budgeting and Cost Control: Essential Tips for Effective Project Management
Просмотров 1274 месяца назад
Project Budgeting and Cost Control: Essential Tips for Effective Project Management
Demystifying Structural Engineering: Easy and Simple Explanation
Просмотров 944 месяца назад
Demystifying Structural Engineering: Easy and Simple Explanation
Mastering Productivity: The Eisenhower Matrix Explained
Просмотров 6425 месяцев назад
Mastering Productivity: The Eisenhower Matrix Explained
Project Closure: Essential Steps for Success
Просмотров 1025 месяцев назад
Project Closure: Essential Steps for Success
Tailoring in Project Management: Customizing Strategies for Success
Просмотров 1095 месяцев назад
Tailoring in Project Management: Customizing Strategies for Success
Bar Bending Schedule using Excel | Step-by-Step Tutorial
Просмотров 9495 месяцев назад
Bar Bending Schedule using Excel | Step-by-Step Tutorial
Mastering Google Sheets: Creating Dynamic Dashboards Tutorial
Просмотров 1,1 тыс.6 месяцев назад
Mastering Google Sheets: Creating Dynamic Dashboards Tutorial
Ultimate Guide to Reinforced Concrete Column Design | ACI 318 Standards Explained
Просмотров 8986 месяцев назад
Ultimate Guide to Reinforced Concrete Column Design | ACI 318 Standards Explained
Mastering Map Visualizations in Microsoft Power BI
Просмотров 4856 месяцев назад
Mastering Map Visualizations in Microsoft Power BI
Mastering Power Query: Connecting Multiple Excel Spreadsheets Tutorial
Просмотров 6196 месяцев назад
Mastering Power Query: Connecting Multiple Excel Spreadsheets Tutorial
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.
Well Explained :-)
Thank you very much for the positive feedback!
Great video, can you please share the excel file?
Hey, thank you for reaching out. Do you mind commenting your email address down below or maybe reach out to me directly on LinkedIn at www.linkedin.com/in/aqhotak
Hi, how to exclude weekends from the time line and graph.
Hey, left you a reply on other comment of you on this video.
Hi, how to exclude weekends from the time line (start/end date)
Hey, have you watched this video of us. It might help ⬇️ ruclips.net/video/T69sSKgFQ8A/видео.html
Hi, how to exclude weekends from the time line and graph.
Perfect, thank you
Hi Hatem, thank you for the positive feedback. It will help us improve our content.
Question: I'm trying to add a "Today" marker within that timeline, that moves automatically since I use =Today(), but I leave it at the end of my milestones but it shows randomly at the end on the timeline, any fix?
Hey, can you share your spreadsheet with me through LinkedIn (www.linkedin.com/in/aqhotak) so we can give it a look together.
Thank you 👍
Hi, thank you for the positive feedback. It will help us improve our content.
Where we can fnd rho table? which code
Can you please share a editable file version? for my personal use
Wonderful presentation and insighful video lesson. Thank you Professor
Nice work. There is a bug that if the data was not in the time sequence, for example, the second date is earlier than the first date. Then the label is wrongly assigned.
Hey Duncan, thank you for engaging with our content. Other people have encountered the same issue. Make sure that the dates are in date format. If still not fixed, reach out to me on LinkedIn and let’s solve it there: www.linkedin.com/in/aqhotak
Why does my data read, 'Average of latitude' when I put latitude in the latitude provision?
hi i am facing the same problem too. and the videos i watched so far never mentioned or worked on this. did you find any solution?
Nice video, but if you have more than 9 activitites, the planned time errorbar gets dislocated, and you will have to adjust this by correcting the maximum (and min) values for the secondary y axis. Could you look into this, and explain why this happens? And please, let's see a Power BI version of this chart. Thanks :)
Hi Per, yes that’s absolutely correct that the error bars get dislocated. I’ll have to recheck to see if there is a solution to that. The Power BI version was requested before this too, and we’ll definitely make a video on that. Lastly, your comment helps us make better content. Thank you for engaging with our content.
excellent work!
Very much appreciated. Glad it has helped!
Thank you!
Very much appreciated. Glad this has helped.
hi! this is very informative, thank you for creating this video. would you mind sharing the template please?
Hi Nicoy, I think that I already have shared this with you on LinkedIn.
@@Engineeringly yes, much appreciated! Looking forward to more videos.
I am able to segregate bar styles only by resource names. Can I segregate bar styles by resource group
How I can know the under allocated resources manhours (as we have overallocated resources in red.
Thank you!
Thanks to you for engaging with our content!
Thanks for your help!
Thanks to you for engaging with our content!
I am a civil engineer..can i take MS in engineering management?
Hi Mohammad, yes you can. You will be taking more technical courses. While in project management you will be taught skills and techniques required to successfully lead and manage projects.
Hello can i ask if its possible to do a question i seem to be struggling on. i am a student in project management and watch a lot of your videos which are helpful. would it be possible if we can do some question together?
Hey Ngebulana, we will be glad to take any type of questions from our audience specifically about project management. Please comment your questions, and will make sure to attend them the earliest possible.
!A very good video. I think it was a bit fast for a beginner and you did some steps in there that you didn't entirely explain but I figured it out. Thanks!
Hi, thank you for the positive and constructive feedback. We’ll definitely take those into account going forward.
Great video. Thanks for that. 🥰
Hi Gloria, glad you found this helpful. Thank you for the positive feedback!
Any chance you could possibly put in the specific clauses for what you're referencing in here? All your steps, could you put in the clauses for them, perhaps in the video description?
Hey, yes of course. Your point is well noted and it will be incorporated in the video very soon. Thank you for the useful feedback!
PLEASE SHARE TEMPLATE
Hi Gehan, thank you for engaging with our content. Kindly comment down your email or contact me directly on LinkedIn at www.linkedin.com/in/aqhotak
Hi can you make for Power BI
Hi Ratnesh, thank you for the comment. Yes, we will plan to have the video the earliest. And I’ll leave you the link to that under your comment here.
excellent !!!!!!!!!!
Thank you very much for the positive feedback!
Instructions start at 5:30.
Hey Hayek, thank you for pointing that out. We were planning to add that in the description of the video to make it easier for the audience. The long explanation at the beginning is because we feel that the audience should clearly understand what they’re going to watch. Thank you once again for the heads up!
@@Engineeringlyit’s not a long video he is just lazy thank you for your effort
Very much appreciated, thank you!
Can you please provide the template?
Shared through LinkedIn!
isn't the ultimate soil bearing capacity already identified in the soil report , so what we've calculated at 4:55 is the actual stress on soil which we should compare with the ultimate bearing capacity of soil?
That’s a 100% right.
Thanks for this. It was easy to comprehend
Glad to hear that. Thank you very much for the positive feedback!
provide dataset
Hi, thank you for engaging with our content. Would you please share your email address?
Where can i find the table for rho min for temp and shrinkage? Which clause?