- Видео 561
- Просмотров 6 402 523
dptutorials
Индия
Добавлен 11 сен 2006
I upload a new video every Wednesday and shorts on daily basis.
Project Management is used in various fields to execute projects successfully, so the project manager should be supported by set of tools. Use of such Project Management tools makes the project manager's work easy and standardises the work.
Here, dptutorials channel will help you in learning some of the Project Management tools like Primavera P6, Microsoft Project including necessary business skills/tools like Microsoft Office, through easy learning tutorials and thus making your work pleasurable and productive.
Learn best practices -How-Tos here
Please write to info@dptutorials.com, for any support/help.
For more detail tutorials, visit
www.dptutorials.com
askplanner.blogspot.com
Project Management is used in various fields to execute projects successfully, so the project manager should be supported by set of tools. Use of such Project Management tools makes the project manager's work easy and standardises the work.
Here, dptutorials channel will help you in learning some of the Project Management tools like Primavera P6, Microsoft Project including necessary business skills/tools like Microsoft Office, through easy learning tutorials and thus making your work pleasurable and productive.
Learn best practices -How-Tos here
Please write to info@dptutorials.com, for any support/help.
For more detail tutorials, visit
www.dptutorials.com
askplanner.blogspot.com
How to Create a Histogram Chart in Excel
🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟
In this video, let us learn about the Histogram chart
Purpose: A histogram is a graphical representation that organizes a group of data points into user-specified ranges
Let’s understand this with an example
We have the salary details of 16 employees and if we want to see the distribution by some slab wise, we have to create the histogram. Let’s create now.
🔔 **Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon** 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration!
👍 **Enjoyed the video? Give it a Thumbs Up!** 👍 It helps us a lot!
💡 **About dptutorials:**
dptutorials is your go-to place for ...
In this video, let us learn about the Histogram chart
Purpose: A histogram is a graphical representation that organizes a group of data points into user-specified ranges
Let’s understand this with an example
We have the salary details of 16 employees and if we want to see the distribution by some slab wise, we have to create the histogram. Let’s create now.
🔔 **Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon** 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration!
👍 **Enjoyed the video? Give it a Thumbs Up!** 👍 It helps us a lot!
💡 **About dptutorials:**
dptutorials is your go-to place for ...
Просмотров: 77
Видео
How to Create a Column Chart in Excel
Просмотров 40821 час назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In this video, let us learn about the Column chart Purpose: : To compare values between different groups or to track changes over time We have this sample data range which we will use for creating the column chart now. 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! Don't miss out on the fu...
How to Create a Bar Chart in Excel
Просмотров 21714 дней назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In this video, let us learn about the Bar chart Purpose: To compare values between different groups or to track changes over time Here in this example, we have considered productivities of 2 employees by month-wise. So if we want to do some analysis with bar chart, we have to either draw trend or compare both employees. Let’s start bui...
How to Create an Area Chart in Excel
Просмотров 13721 день назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In this video, let us learn about the Area chart in Excel. Purpose: Area charts are primarily used when the magnitude of the trend is to be communicated Now in this example data, we have the count of Male and Female employees against each month. And let us draw the trend if you want to compare with the proportion of each category. 🔔 Su...
How to Highlight the Active Cell and Row in Excel with a Click
Просмотров 270Месяц назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll explore a visually effective technique: how to highlight the active cell and row in Excel with a click. Before we start, let's consider this worksheet for this demonstration. To highlight the active cell and row, we'll use a simple VBA 👉Link to VBA code: bit.ly/3yv5M6J 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the B...
How to Copy and Paste Multiple Cells into a Single Cell as a Stacked Column in Excel
Просмотров 250Месяц назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll be tackling a unique and practical Excel tip: how to copy and paste multiple cells into a single cell as a stacked column. This is the column with the data that we want to combine into a single cell. 👉Excel File: bit.ly/44N3RGK 👉VBA code: bit.ly/4bnfAhy 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to st...
How to Automatically Generate Serial Numbers Based on Data in Excel
Просмотров 329Месяц назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll be covering a practical and time-saving feature in Excel: automatically generating serial numbers based on data entered in your spreadsheet. 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration! 👍 Enjoyed the video? Giv...
How to Use the FILTER Function With Multiple Criteria
Просмотров 261Месяц назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll be exploring a powerful feature in Excel: using the FILTER function With Multiple Criteria. Consider this example data with the headers. Now, let's use the FILTER function to filter our data based on specific criteria: 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! ...
Easy Excel Hack: How to Create a Birthday Reminder in Excel
Просмотров 2122 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 Learn a simple Excel hack to never forget a birthday again! In this tutorial, you will discover how to easily create a birthday reminder table using Excel. Say goodbye to missing important dates with this easy-to-follow guide. Stay organized and on top of all your loved ones' special days with this Excel birthday reminder trick! 🔔 Subs...
How to Find Minimum and Maximum Values in a Column Using Conditional Formatting || dptutorials
Просмотров 2222 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll be focusing on a handy feature in Excel: using conditional formatting to quickly identify the minimum and maximum values in a column. Whether you're analyzing data, tracking trends, or making decisions, this simple yet powerful feature will help you identify outliers and make sense of your spreadsheet quickly an...
How To Quickly Reconcile two sets of Data In Excel
Просмотров 7752 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we'll be tackling a common challenge: reconciling two sets of data in Excel. Ofcourse you can reconcile the values by identifying the unique identifer in both the data sets and sorting them in an order and then manually identifying which ID is missing in both the data tables, but this can only be done in smaller table...
How To Calculate Actual Hours Worked In Excel
Просмотров 3212 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we will see calculating actual hours worked using Excel. In this example by date wise, we have the in and out times like this. 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration! 👍 Enjoyed the video? Give it a Thumbs Up! 👍 ...
Excel Chart Tricks Boost Your Data Visualisation Skills
Просмотров 2073 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we're going to explore some handy Excel chart tricks that will help you create and manipulate charts like a pro. 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration! 👍 Enjoyed the video? Give it a Thumbs Up! 👍 It helps us a ...
How to find duplicate entries in Excel
Просмотров 2943 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we're going to tackle a common data management task: finding duplicate entries in Excel. So, let's explore some techniques to find and deal with duplicate entries in Excel. 🔔 Subscribe ➡️ bit.ly/3sPIZvD and Hit the Bell Icon 🔔 to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration...
Create pivot table from multiple sheets in excel
Просмотров 3013 месяца назад
🌟 Welcome to dptutorials! Subscribe for Exciting Content! 🌟 In today's video, we're going to explore a powerful feature in Excel: creating pivot tables from multiple sheets. Pivot tables are an essential tool for analyzing and summarizing large datasets, and being able to pull data from multiple sheets adds another level of flexibility and insight to your analysis. Imagine you have data spread ...
Excel Worksheet Tricks Boost Your Productivity with These Tips
Просмотров 2433 месяца назад
Excel Worksheet Tricks Boost Your Productivity with These Tips
How To Use Vlookup To Pick Up Second And Third Matched Value In Excel
Просмотров 2874 месяца назад
How To Use Vlookup To Pick Up Second And Third Matched Value In Excel
How to split each excel sheet into a separate file from workbook
Просмотров 2984 месяца назад
How to split each excel sheet into a separate file from workbook
How to convert date to words in excel
Просмотров 4734 месяца назад
How to convert date to words in excel
Excel Pro Tip: Fill Blank Cells with Values Above
Просмотров 2714 месяца назад
Excel Pro Tip: Fill Blank Cells with Values Above
How to use the VLOOKUP function with wildcards in Excel
Просмотров 3254 месяца назад
How to use the VLOOKUP function with wildcards in Excel
3 Awesome Tricks To Know On Drop Down Lists In Excel
Просмотров 5705 месяцев назад
3 Awesome Tricks To Know On Drop Down Lists In Excel
Mastering Excel To Do Lists Adding Tick and Cross Marks Tutorial
Просмотров 3405 месяцев назад
Mastering Excel To Do Lists Adding Tick and Cross Marks Tutorial
Highlight Search Value Automatically In Excel
Просмотров 3585 месяцев назад
Highlight Search Value Automatically In Excel
How To Convert Numbers Into Words In Excel
Просмотров 4,4 тыс.5 месяцев назад
How To Convert Numbers Into Words In Excel
🔔 Easily Separate numbers and text in Excel 🔔
Просмотров 2906 месяцев назад
🔔 Easily Separate numbers and text in Excel 🔔
Excel Showdown XLOOKUP vs VLOOKUP - Unravelling the Mystery
Просмотров 3446 месяцев назад
Excel Showdown XLOOKUP vs VLOOKUP - Unravelling the Mystery
4.3: Primavera Learning Updating Baselines In Primavera P6
Просмотров 6136 месяцев назад
4.3: Primavera Learning Updating Baselines In Primavera P6
How to Create Progress Bars in MS Excel
Просмотров 4527 месяцев назад
How to Create Progress Bars in MS Excel
You saved me
Thanks!
One question though, Incase I might need to do this some other time do I have to save the code? Can I re use the code?
Thanks for this
Hoe to create new excel files with some reference column from main sheet? Any idea
💯
thank you!!
Hello, Thank you for the useful video, however, it is not working for me, I am trying to do the same step, after selecting the tasks to create a summary task, but for some reason only first task will be a part of the summary task and other tasks will not be included in summary task, any idea why this is happening? Thanks. PS: I am using MS Project 2021 Desktop version.
Thanks 👍👍👍😂
Too complicated.....
Thank you sooo Much ❤❤❤
Not working
I am sure there is simpler formula
Superb, you solved the prob exactly. Can you pls make a video to make live excel sheet to catch data from table from internet please
thank you for sharing, but when I calculate the data with decimal numbers, the result will automatically round down. how to handle that issue
nd formula jo lg gya h vo tera baap htyga?
Thanks for informative Video
Sir y r u use not very easy function SUMPRODUCT SUMPRODUCT is always best 😊
So the updates are only asyncronous... from one to another... there is no bidirectional linking approach?
Thank you. You beat AI on this one for sure.
It doesn't work for me. I'm trying to count across columns and rows. It just says "#NAME?"
Thank you very much... My problems solved 👍👍
Upload it in ChatGPT and ask it to do so and give you the new excel file with changes . It took 10 seconds
thnaks
Awesome, short and straight to the point keep the good work up. Do you do private lessons as well?
Thank you ❤
Thank you....... You have solved my problem, God bless you.......
Hi. Thank you for you wonderful videos. I have a question bothering me, the question is; How can I put the right activity relationship in the send of MEP rough-in phase work with structural phase work? I have seen so many videos linking MEP rough-in work after completion of structural which I think shouldn't be. Pls correct me, Engr
Thank you so much!!! You’re a lifesaver 🙏🏾
How to add the date on an unspecfied target cell
Great tip. Thank you
How can I get the excel sheet file?
I am getting error, #NAME? can anyone please help me?
Very helpful tutorial. Thank you very much.
Thank you a lot 🙏
Thanks. Nice video.
This works, thank you!
Similarly can you show how to unlink all check boxes
Bad idea
Bhai abhi bhi same hi aa raha h
Thank you for the formula, I can use the SumByColor to do my report. However, I am not able to get the figures after the decimal point, can you help to re-write the formula including figures after the decimal point? Thank you.
same question.. @dptutorials
In the code where it says "Dim cSum As Long" use "Dim cSum" instead
How we can do the same in Google sheet
Your voice quality is so bad
Your video is always ultimate .Iam watching your video for the past 3 years.Now iam Planning Engineer because of you.Thanks for your support and efforts.
That's interesting 😁... 👏 👏 🎉🎉 But the row highlight is going outside the table 😢... Could you control it so that row highlight stays only upto the table
I have a column that has the names like this: JohnandMarySmith. What would the code be to make it John and Mary Smith
Nice! Thank you!
Very helpful! thanks!
ruclips.net/video/gHBpOJJL3Ho/видео.htmlsi=Al7YELWnSo_EjJ7K
ruclips.net/video/gHBpOJJL3Ho/видео.htmlsi=90bNQs9WeXSYjlIk