dptutorials
dptutorials
  • Видео 561
  • Просмотров 6 402 523
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 ...
Просмотров: 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 🔔
Age calculator in excel
Просмотров 2736 месяцев назад
Age calculator 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

Комментарии

  • @hope1527
    @hope1527 День назад

    You saved me

  • @c799651
    @c799651 2 дня назад

    Thanks!

  • @kosanilechambi8945
    @kosanilechambi8945 2 дня назад

    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?

  • @chifuyuuu_
    @chifuyuuu_ 2 дня назад

    Thanks for this

  • @latestvideos5870
    @latestvideos5870 2 дня назад

    Hoe to create new excel files with some reference column from main sheet? Any idea

  • @bhupatc
    @bhupatc 3 дня назад

    💯

  • @supratimbasu1373
    @supratimbasu1373 3 дня назад

    thank you!!

  • @israryousaf4995
    @israryousaf4995 3 дня назад

    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.

  • @fda.r5628
    @fda.r5628 5 дней назад

    Thanks 👍👍👍😂

  • @shivamshankhdhar5432
    @shivamshankhdhar5432 6 дней назад

    Too complicated.....

  • @TDS500
    @TDS500 8 дней назад

    Thank you sooo Much ❤❤❤

  • @amaragondaraju5153
    @amaragondaraju5153 9 дней назад

    Not working

  • @jennyhorton2088
    @jennyhorton2088 10 дней назад

    I am sure there is simpler formula

  • @gauravmaru9959
    @gauravmaru9959 10 дней назад

    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

  • @riohandoko6829
    @riohandoko6829 11 дней назад

    thank you for sharing, but when I calculate the data with decimal numbers, the result will automatically round down. how to handle that issue

  • @NituSingh-ou7bh
    @NituSingh-ou7bh 11 дней назад

    nd formula jo lg gya h vo tera baap htyga?

  • @user-uu9ke6nm8j
    @user-uu9ke6nm8j 11 дней назад

    Thanks for informative Video

  • @krishnatate4765
    @krishnatate4765 13 дней назад

    Sir y r u use not very easy function SUMPRODUCT SUMPRODUCT is always best 😊

  • @DukeGIJOE
    @DukeGIJOE 13 дней назад

    So the updates are only asyncronous... from one to another... there is no bidirectional linking approach?

  • @vonjon
    @vonjon 13 дней назад

    Thank you. You beat AI on this one for sure.

  • @kingeryck1
    @kingeryck1 14 дней назад

    It doesn't work for me. I'm trying to count across columns and rows. It just says "#NAME?"

  • @Yesa-desh-hai-mera
    @Yesa-desh-hai-mera 16 дней назад

    Thank you very much... My problems solved 👍👍

  • @queensgambit4982
    @queensgambit4982 17 дней назад

    Upload it in ChatGPT and ask it to do so and give you the new excel file with changes . It took 10 seconds

  • @eradotcom
    @eradotcom 17 дней назад

    thnaks

  • @bananarepublic8951
    @bananarepublic8951 19 дней назад

    Awesome, short and straight to the point keep the good work up. Do you do private lessons as well?

  • @jahirafjal8759
    @jahirafjal8759 19 дней назад

    Thank you ❤

  • @jpr1111
    @jpr1111 20 дней назад

    Thank you....... You have solved my problem, God bless you.......

  • @reginaldibenne6875
    @reginaldibenne6875 20 дней назад

    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

  • @IndraEighty-Six
    @IndraEighty-Six 20 дней назад

    Thank you so much!!! You’re a lifesaver 🙏🏾

  • @XRAYNSH
    @XRAYNSH 21 день назад

    How to add the date on an unspecfied target cell

  • @stephengaskell2227
    @stephengaskell2227 21 день назад

    Great tip. Thank you

  • @ahmadfm836
    @ahmadfm836 21 день назад

    How can I get the excel sheet file?

  • @8prabha
    @8prabha 23 дня назад

    I am getting error, #NAME? can anyone please help me?

  • @DAcutech
    @DAcutech 23 дня назад

    Very helpful tutorial. Thank you very much.

  • @hydraulicsmodeling1218
    @hydraulicsmodeling1218 24 дня назад

    Thank you a lot 🙏

  • @petlover6072
    @petlover6072 24 дня назад

    Thanks. Nice video.

  • @jinugeorge8422
    @jinugeorge8422 25 дней назад

    This works, thank you!

  • @KrishnaAgarwal-vt2lh
    @KrishnaAgarwal-vt2lh 26 дней назад

    Similarly can you show how to unlink all check boxes

  • @prashantsingh2016
    @prashantsingh2016 29 дней назад

    Bad idea

  • @automobiletechtips651
    @automobiletechtips651 29 дней назад

    Bhai abhi bhi same hi aa raha h

  • @JosephBut
    @JosephBut 29 дней назад

    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.

    • @riohandoko6829
      @riohandoko6829 11 дней назад

      same question.. @dptutorials

    • @riohandoko6829
      @riohandoko6829 11 дней назад

      In the code where it says "Dim cSum As Long" use "Dim cSum" instead

  • @nikunj84233
    @nikunj84233 Месяц назад

    How we can do the same in Google sheet

  • @user-zr2gf1pm2z
    @user-zr2gf1pm2z Месяц назад

    Your voice quality is so bad

  • @kabilansubramaniyan6978
    @kabilansubramaniyan6978 Месяц назад

    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.

  • @lazyreviewssupport9811
    @lazyreviewssupport9811 Месяц назад

    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

  • @ginamae8003
    @ginamae8003 Месяц назад

    I have a column that has the names like this: JohnandMarySmith. What would the code be to make it John and Mary Smith

  • @brutalbliss
    @brutalbliss Месяц назад

    Nice! Thank you!

  • @tylerguzinski6772
    @tylerguzinski6772 Месяц назад

    Very helpful! thanks!

  • @akyadav080yadav8
    @akyadav080yadav8 Месяц назад

    ruclips.net/video/gHBpOJJL3Ho/видео.htmlsi=Al7YELWnSo_EjJ7K

  • @ramkishoryadav9087
    @ramkishoryadav9087 Месяц назад

    ruclips.net/video/gHBpOJJL3Ho/видео.htmlsi=90bNQs9WeXSYjlIk