Sushil Kumar
Sushil Kumar
  • Видео 28
  • Просмотров 2 051
Filter Function to filter data on the basis of Dates
Hello,
Good day!
I have created this video to explain the Filter function by using of this function you can make a automate filter data on the basis of Date, like I want to filter the employees who have work anniversary today from my Master Data.
You can do your practice by opening below google sheet:-
docs.google.com/spreadsheets/d/1fPjo5U7dZkAqumPgBcTUw8xi2IRimCJR1Tsy19gEwow/edit?usp=sharing
Просмотров: 35

Видео

Filter function in Excel 2021 or Office 36511:31Filter function in Excel 2021 or Office 365
Filter function in Excel 2021 or Office 365
Просмотров 232 месяца назад
In this video I explained basic and bit advance filter function in Excel and for your information advance function works in MS Office 2021 or above version Office 365. If you don't have any of these you can use Google Spreadsheet to do it. Sample File URL:- docs.google.com/spreadsheets/d/1fPjo5U7dZkAqumPgBcTUw8xi2IRimCJR1Tsy19gEwow/edit?usp=sharing
Vlookup with IF ISNA function5:07Vlookup with IF ISNA function
Vlookup with IF ISNA function
Просмотров 208Год назад
Greetings of the day to all! In this video you will learn how to use IF-ISNA function with Vlookup, I hope it will help you with your task. You can download sample file by clicking on below link docs.google.com/spreadsheets/d/1ZjOM_Q67azQ5KDzjnfoCR0xlNoib0ip2/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
Lookup Function in Excel4:54Lookup Function in Excel
Lookup Function in Excel
Просмотров 200Год назад
Hello Everyone, Greetings of the day!, in this video you will learn how to use Lookup function for the result vectors on the basis of range. You can download the Practice file by click on below link docs.google.com/spreadsheets/d/15QbbNfNdq0oB0nxxBj2adlbCbGM4tn9u/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to lookup value on the basis of multiple criterias7:07How to lookup value on the basis of multiple criterias
How to lookup value on the basis of multiple criterias
Просмотров 93Год назад
Hello, In this video you will learn how to fetch the result on the basis of multiple criteria's. You can download the practice file by clicking on below link drive.google.com/file/d/1R3DhLMAtexCjlDJ3oXteI5krfMMHgF5I/view?usp=sharing
How to search value with multiple criteria's6:00How to search value with multiple criteria's
How to search value with multiple criteria's
Просмотров 74Год назад
Hello Everyone, Greetings of the day In this video I explained how to lookup a value on the basis of multiple criteria's. Click on this link to download the sample file docs.google.com/spreadsheets/d/1-a_4m1nPtjTamscdLpeU8_rPNbrFkjd0/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to Calculate Warranty12:04How to Calculate Warranty
How to Calculate Warranty
Просмотров 72Год назад
In this video I explained the Edate function and how to calculate warranty by using of Edate function in Excel. Download same file by clicking on this url:- docs.google.com/spreadsheets/d/16ETiyYBo0sWfdPepyyRWjdlyNhKRLyME/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to Calculate total number of hours in excel8:44How to Calculate total number of hours in excel
How to Calculate total number of hours in excel
Просмотров 144Год назад
In this video you will learn how to calculate total hours when we have in time and out time, you can download sample file by clicking on this url:- docs.google.com/spreadsheets/d/1GiTcks4fvGQyIenWvg9D9gm-eDL3Qske/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to Fetch Last Name6:19How to Fetch Last Name
How to Fetch Last Name
Просмотров 46Год назад
In this video, I explained how to fetch last name with using a very small formula. You can download sample fil by clicking on this link:- docs.google.com/spreadsheets/d/1BxyxJZFV5bONxazrKsdZPzNl1_qWVVsx/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to Fetch Middle Name17:14How to Fetch Middle Name
How to Fetch Middle Name
Просмотров 282 года назад
In this video I explained how to fetch Middle Name, you can download practice file by clicking on below URL:- Practice File:- docs.google.com/spreadsheets/d/1S_Qv_0LVqt3TVo0bHwGxamsE2fAAsPJj/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to Fetch first name only4:57How to Fetch first name only
How to Fetch first name only
Просмотров 392 года назад
In this video I explained that how to fetch First Name of user through left function in Excel You can download sample file by clicking on this URL:- docs.google.com/spreadsheets/d/1fEHV3uhr7Rxle06SjCCdy2FyP-YpaHsR/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
Advance Filter in Excel8:14Advance Filter in Excel
Advance Filter in Excel
Просмотров 1192 года назад
Good day everyone, in this video I explained Advanced filter in Excel. Link to download sample file is: - drive.google.com/file/d/1N1WJ2n9M0zF4-SO6xVdxV8qbf5RTT4Ss/view?usp=sharing
Large function Excel3:45Large function Excel
Large function Excel
Просмотров 412 года назад
In this video you'll learn how to use Large function in excel You can download sample file from here:- docs.google.com/spreadsheets/d/1yGDH4KOgTIjB9MtG7qkorTc0uzSOI9m4/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
Transpose Function in Excel2:12Transpose Function in Excel
Transpose Function in Excel
Просмотров 412 года назад
In this video you will learn how to use transpose function in excel Download Sample file/Practice file: - docs.google.com/spreadsheets/d/1OinTMTseQA9ipcScsCD0Qh91_OMZuyCc/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
How to use Indirect function in Vlookup function9:34How to use Indirect function in Vlookup function
How to use Indirect function in Vlookup function
Просмотров 742 года назад
In this I explained Indirect function in vlookup Download Sheet with function:- docs.google.com/spreadsheets/d/1S3XxnbmTqGMDqHAckQAHTLNdbLN8iopW/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true Download sheet to do practice:- docs.google.com/spreadsheets/d/1UQdYqrJ-uYBZUP_E21kUg8pvcQcYTi8n/edit?usp=sharing&ouid=102382875076747247193&rtpof=true&sd=true
Indirect function instead of Vlookup6:19Indirect function instead of Vlookup
Indirect function instead of Vlookup
Просмотров 332 года назад
Indirect function instead of Vlookup
How to calculate age, time duration between two dates9:09How to calculate age, time duration between two dates
How to calculate age, time duration between two dates
Просмотров 552 года назад
How to calculate age, time duration between two dates
How to remove the time from Date in excel3:04How to remove the time from Date in excel
How to remove the time from Date in excel
Просмотров 402 года назад
How to remove the time from Date in excel
How to calculate Negative or Positive values in a range in Excel3:11How to calculate Negative or Positive values in a range in Excel
How to calculate Negative or Positive values in a range in Excel
Просмотров 372 года назад
How to calculate Negative or Positive values in a range in Excel
How to set dynamic value in Column Number by using Match function in Vlookup and other functions12:05How to set dynamic value in Column Number by using Match function in Vlookup and other functions
How to set dynamic value in Column Number by using Match function in Vlookup and other functions
Просмотров 692 года назад
How to set dynamic value in Column Number by using Match function in Vlookup and other functions
How to set dynamic value in Column Number by using Columns function in vlookup...11:00How to set dynamic value in Column Number by using Columns function in vlookup...
How to set dynamic value in Column Number by using Columns function in vlookup...
Просмотров 272 года назад
How to set dynamic value in Column Number by using Columns function in vlookup...
Index and Match function in Excel23:34Index and Match function in Excel
Index and Match function in Excel
Просмотров 312 года назад
Index and Match function in Excel
How to Fill out the Details in blank cells3:54How to Fill out the Details in blank cells
How to Fill out the Details in blank cells
Просмотров 282 года назад
How to Fill out the Details in blank cells
How to calculate Percentage through Vlookup formula11:03How to calculate Percentage through Vlookup formula
How to calculate Percentage through Vlookup formula
Просмотров 3092 года назад
How to calculate Percentage through Vlookup formula
Basic Vlookup Function in Excel21:36Basic Vlookup Function in Excel
Basic Vlookup Function in Excel
Просмотров 532 года назад
Basic Vlookup Function in Excel
How to fetch data from multiple sheets by using vlookup formula6:03How to fetch data from multiple sheets by using vlookup formula
How to fetch data from multiple sheets by using vlookup formula
Просмотров 952 года назад
How to fetch data from multiple sheets by using vlookup formula
How Enter the Random Names by using Choose and Randbetween formula3:31How Enter the Random Names by using Choose and Randbetween formula
How Enter the Random Names by using Choose and Randbetween formula
Просмотров 202 года назад
How Enter the Random Names by using Choose and Randbetween formula
How to Enter Random Values by using Randbetween2:52How to Enter Random Values by using Randbetween
How to Enter Random Values by using Randbetween
Просмотров 252 года назад
How to Enter Random Values by using Randbetween

Комментарии

  • @sushilexcel4966
    @sushilexcel4966 Год назад

    Thank you for your suggestion, I m preparing the same and will be sharing by today EOD

  • @anitavishnoi5813
    @anitavishnoi5813 Год назад

    Thank you Sushil, Sushil I am looking for a function, let's take an example, I have the list of 50 students now I recieve a list of 10 students those have paid their fee. How can I put their status as paid in 50 students list.

  • @anitavishnoi5813
    @anitavishnoi5813 Год назад

    Thank you so much, I was looking for the same formula... 🎉

  • @anitavishnoi5813
    @anitavishnoi5813 2 года назад

    Very nice sir, this is fantastic and I was looking for the same....

  • @rohitrawat2131
    @rohitrawat2131 2 года назад

    You cool and awesome trick sir keep uploading more videos🎉💕🎉

  • @anitavishnoi5813
    @anitavishnoi5813 2 года назад

    Very nice information thank you so much