Excel Rush
Excel Rush
  • Видео 73
  • Просмотров 4 848 269
How to run Vlookup with multiple conditions
Vlookup typically works with only 1 condition, but there is a way to use Concatenate function with Vlookup, so that you can make Vlookup work with multiple inputs conditions.
See the whole video for 2 examples, to get a good understanding of how to use this in different scenarios.
SUBSCRIBE NOW!
ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg
How to Reverse or flip data range in Excel
ruclips.net/video/Gu_026Iu220/видео.html
Click this link to learn more awesome functions in Excel
ruclips.net/p/PLsHesq9dVLnIs6bmsI1FW5RpQBTiz9LVJ
Просмотров: 76

Видео

How to remove multiple hyperlinks together in Google Sheets
Просмотров 39114 дней назад
There seems to be no direct option to remove multiple hyperlinks together in Google Sheets, but there actually is! See this less than 1 minute video to know how. How to remove duplicates using Unique function in Google Sheets ruclips.net/video/DKqgwBSXiZQ/видео.htmlsi=Zdm8PmAzKhVlOC3m SUBSCRIBE NOW! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg Click this link to learn how to manage your persona...
How to display the date correctly inside Concatenate function in Excel
Просмотров 11621 день назад
Whenever you use Date inside the Concatenate function in Excel, the date displays as a number. Using the Text function inside Concatenate let's you format and display the date the way you want it to be. SUBSCRIBE NOW! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg Click this link to learn the most essentials of Excel ruclips.net/p/PLsHesq9dVLnKvf3Lw4qEYT7e07QAJQuBB Click this link to learn more a...
How to transpose multiple rows and columns in Excel in one shot
Просмотров 44 тыс.Год назад
Using the Transpose feature of Paste Special in Excel can help you convert a row data into column, and column data into row. But instead of transposing 1 single row or column, you may need to transpose multiple rows and columns together. This is very easily possible as well. SUBSCRIBE NOW! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg Click this link to learn the most essentials of Excel ruclips...
How to Hide and Show the top menu ribbon in Excel using a keyboard shortcut and a mouse trick
Просмотров 8 тыс.Год назад
The top menu in Excel, also called the Ribbon, is most used for using various features in Excel. But it also sometimes comes in the way when you're trying to work on a large Excel sheet and need more screen space available. Learn how to quickly hide and show the top menu using a quick keyboard shortcut and a simple mouse trick. SUBSCRIBE NOW! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg Click t...
How to use SUMIF and SUMIFS functions in Excel
Просмотров 978Год назад
Use SUMIF when you want a summation of some value based on 1 condition. Use SUMIFS when you want the summation based on multiple conditions. To learn Pivot tables, click this link ruclips.net/video/e2yBVexENiI/видео.html For more videos on managing Personal Finance using Excel, click this link ruclips.net/p/PLsHesq9dVLnKFoNtLSrLbrPXPL_xZc6AG SUBSCRIBE! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1...
How to create an Insurance tracker and manage Insurance policies efficiently using Excel
Просмотров 13 тыс.4 года назад
You have 4 family members in the house and 5 different types of Insurance policies. It is very difficult to have all the details on the tip of your tongue. How do you track all the policies in 1 single place? Use this Excel model to create a tracker and manage all your Insurance policies with ease. To learn Pivot tables, click this link ruclips.net/video/e2yBVexENiI/видео.html For more videos o...
A Drop of Excel - 12 | Reporting using Pivot Tables, Slicers and Pivot Charts in Excel
Просмотров 1,1 тыс.4 года назад
To Learn Pivot Tables in Depth MASTER BUSINESS REPORTING USING PIVOT TABLES & CHARTS www.udemy.com/course/master-business-reporting/?couponCode=AA4E458F885D80E2ED11 * Example file link drive.google.com/file/d/15L8YG5pPizowg5t1OJSSrT7DqsYg1Cfb/view?usp=sharing \ Previous video: ruclips.net/video/PQWAI5qbu4o/видео.html / Understanding of the data being used in the examples: ruclips.net/video/KQce...
A Drop of Excel - 11 | $ referencing, How to use Vlookup in most simplified method, Xlookup in Excel
Просмотров 1,7 тыс.4 года назад
Vlookup seems very confusing and you may often forget it even if you have learnt it earlier. We will here learn Vlookup in a very simplified manner that you will not forget. $ referencing is also a must to learn to understand how to make cell references constant in formulas. Xlookup has been recently released by Excel and is much easier to use even than Vlookup! We will also be learning about I...
How to remove blank rows in one shot in between data in Excel
Просмотров 9 тыс.4 года назад
A lot of times you have blank rows in between data. Removing these blank rows is a very time consuming and tedious job, specially if you have thousands of rows of data. There are very simple 2 techniques shown here to remove blank rows in Excel. SUBSCRIBE NOW! ruclips.net/channel/UC8S-Az-vTSItYE-XR9Fb1Zg Click this link to learn the most essentials of Excel ruclips.net/p/PLsHesq9dVLnKvf3Lw4qEYT...
A Drop of Excel - Introduction
Просмотров 22 тыс.4 года назад
Hi, welcome to A Drop of Excel. A lot of people have come to me saying that learning Excel is a very long process and seems very tedious, because it's too vast and too much to learn. So what i've tried to do here is, put in all the 'essentials only' in a 12 video series called 'A Drop of Excel'. Each of these videos requires your 1 hour dedicated time to learn and practice. After this, you will...
A Drop of Excel - 10 | Paste Special, Find & Replace, Go to Special
Просмотров 1,2 тыс.4 года назад
Let us today learn about, Paste special - Paste with same column width as source - Paste as values - Transpose in Excel Find & Replace - Replace in whole sheet - Replace in selected cells only - Replace with a space - Replace with a blank Go To Special - Blanks - Formulas * Example file link drive.google.com/file/d/1qrIGAZqdkIi4pyFZ5gjgqV-3ZCMByRUr/view?usp=sharing \ Previous video: ruclips.net...
A Drop of Excel - 09 | Working with IF Conditions and Conditional Formatting in Excel
Просмотров 8774 года назад
Conditions are very important to understand and use in Excel. It has the power to save you hours and hours of time by automating your calculations. For example, You have to give a value of 0 incentive to any order upto the value of 5,000 and 10% incentive to any order above the value of 5,000. You have 17,000 orders data. It would take you a very long time to do this manually. Even if you use s...
A Drop of Excel - 08 | Restrict and Protect in Excel
Просмотров 7794 года назад
In terms of applying restriction and protection, let us learn the most essentials that you must know in Excel, - How to make a dropdown in Excel - How to allow data entry only in certain cells in Excel - How to allow only numbers greater than 0 or 1000 or any number - How to lock Excel file with a password * Example file link drive.google.com/file/d/1paOrNub_BfyVlps7psoC8sRVRZOdgoU2/view?usp=sh...
A Drop of Excel - 07 | How to work with a Large Set of Data in Excel
Просмотров 1,3 тыс.4 года назад
Working with a lot of data and numbers in Excel can be intimidating sometimes. If you learn the following features and tricks in Excel, it will become very easy for you to manage large data sets in Excel, - How to split data 1 column to multiple columns - Text to columns - Sort on single column and even on multiple columns - Filter data quickly to see desired data only - Remove Duplicates or ge...
A Drop of Excel - 06 | How to work with Dates in Excel
Просмотров 1,1 тыс.4 года назад
A Drop of Excel - 06 | How to work with Dates in Excel
A Drop of Excel - 05 | How to create a Formula across Sheets and or Files in Excel
Просмотров 1,2 тыс.4 года назад
A Drop of Excel - 05 | How to create a Formula across Sheets and or Files in Excel
A Drop of Excel - 04 | How to create Formulas and work with various Functions in Excel
Просмотров 2,4 тыс.4 года назад
A Drop of Excel - 04 | How to create Formulas and work with various Functions in Excel
A Drop of Excel - 03 | Data and Cell Formatting
Просмотров 2,1 тыс.4 года назад
A Drop of Excel - 03 | Data and Cell Formatting
A Drop of Excel - 02 | Data types and Data structure in Excel
Просмотров 4 тыс.4 года назад
A Drop of Excel - 02 | Data types and Data structure in Excel
A Drop of Excel | Understanding the dataset used in the examples
Просмотров 2,1 тыс.4 года назад
A Drop of Excel | Understanding the dataset used in the examples
A Drop of Excel - 01 | User Interface and Cell Referencing Basics
Просмотров 4,1 тыс.4 года назад
A Drop of Excel - 01 | User Interface and Cell Referencing Basics
How to use Filter function in Excel and Filter data based on 1 or 2 or more criteria
Просмотров 63 тыс.4 года назад
How to use Filter function in Excel and Filter data based on 1 or 2 or more criteria
How to use SORT and SORTBY functions in Excel and Sort on single or multiple columns
Просмотров 6 тыс.4 года назад
How to use SORT and SORTBY functions in Excel and Sort on single or multiple columns
How to create a Calculated Field in Pivot Table in Excel
Просмотров 2,1 тыс.4 года назад
How to create a Calculated Field in Pivot Table in Excel
How to create a pivot table from multiple sheets of data
Просмотров 27 тыс.5 лет назад
How to create a pivot table from multiple sheets of data
Preserve and keep formatting constant when refreshing Pivot Table in Excel
Просмотров 45 тыс.5 лет назад
Preserve and keep formatting constant when refreshing Pivot Table in Excel
18 Most Useful Excel Shortcuts
Просмотров 2,4 тыс.5 лет назад
18 Most Useful Excel Shortcuts
How to use Format Painter on multiple cells together in Excel
Просмотров 10 тыс.5 лет назад
How to use Format Painter on multiple cells together in Excel
How to Reverse or flip data range in Excel
Просмотров 237 тыс.6 лет назад
How to Reverse or flip data range in Excel

Комментарии

  • @sujirkomath7221
    @sujirkomath7221 10 часов назад

    Thanks bro ❤

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

    i tried but the connect the data line tab is not highlighted what else should i do

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

    Thank you so much.I was searching for this info but finally I have known how to freeze selected columns

  • @owensunuwar697
    @owensunuwar697 4 дня назад

    Now how to Freeze pane 3 rows at the Bottom?

  • @Szantuyy.
    @Szantuyy. 5 дней назад

    always to the point

  • @biabia-m8b
    @biabia-m8b 7 дней назад

    THANKS

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

    Thank u so much bro❤ I SUBBED

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

    thank bhai aapne mera soluation bata diya

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

    thanks, its work

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

    Great work

  • @er.s.k.bharti3110
    @er.s.k.bharti3110 14 дней назад

    Thank you u solved my problem😊

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

    super useful. A question, what if you have a pivot chart that is associated with a pivot table that you also want to copy?

  • @ayaznoorie.8895
    @ayaznoorie.8895 15 дней назад

    Thank u. U really fixed the issue within a minute. Kudos 💐

  • @jasleentoor2528
    @jasleentoor2528 15 дней назад

    Thanks so much . That worked for me i was having hard time freezing middle rows .

  • @TheFlashman
    @TheFlashman 16 дней назад

    Thank you for this quick and simple explanation. You've fixed my graph!

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

    Thanks, you made that easy

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

    Upto how much times multiple criteria will work.

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

    After a lot of searching I found this video, it's really rare video Thank you so much

  • @sharathykumar314
    @sharathykumar314 27 дней назад

    excellent

  • @jacksonkazimya2223
    @jacksonkazimya2223 27 дней назад

    Thank you

  • @nancyvictor3989
    @nancyvictor3989 27 дней назад

    Thanks very much for solving my problem so quickly 🎉

  • @krishnabharath8900
    @krishnabharath8900 27 дней назад

    Super 😮😂

  • @dilpreetsingh1998
    @dilpreetsingh1998 28 дней назад

    Thank you so much sir.... I was really puzzled since a long time for this and you just explained that simple and the most important trick within seconds... Finally I know how to do it.

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

    Thank so much Sir

  • @saf-1razali846
    @saf-1razali846 Месяц назад

    Thank you

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

    You have no idea how useful this was. Thank you!

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

    Good job man..short and simple 💪

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

    What a simple explanation in a small time. Thanku

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

    Thank you so much sir .What a explaination🔥🔥

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

    Thanks! I have just resolved an issue related to your tutorial...... May Allah bless you!

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

    🎉🎉🎉Good one🎉🎉🎉

  • @S.K.B_The_Writer
    @S.K.B_The_Writer Месяц назад

    not mentioned the desire number of row... only menting top and left blended rows and column... making the people fool

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

      It's fun to read such comments !! 😀 Freeze panes feature is meant for top & left, do try it out! An extra tip from me, try to use the Split option. Maybe that's what you're looking for instead of freeze panes!

    • @S.K.B_The_Writer
      @S.K.B_The_Writer Месяц назад

      @@Excelrush Here you replied with ' top & left', this should be there in video title.. where mentioned multiple rows and columns

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

      Appreciate the feedback. Will apply this learning in future videos. Thanks!

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

    Len=gend

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

    thanks bro

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

    Great

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

    Thanks alot... How to do final sumup of all the difference??

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

    Thank you.

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

    super rush, so easy to understand, no bla bla bla, straight to the core!!!, amazing, thank you prof.!

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

    Thank you thank you thank you

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

    Excellent explanation'

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

    THANK YOU

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

    Thank You

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

    Very well explained in short

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

    Can you please help Please give the correct formula of RANK like this A-100--1 rank B-100--1 rank C-100--1 rank D-90--2 rank E-80--3 rank F-100--1rank G-90--2 rank H-100--1 rank I-90--2 rank J-80--3 rank Here if the student getting same no they got all same rank And there is no skip of any rank also If a student got 100 then for every student it is rank 1 not 1,2,3,4....

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

    ❤❤❤❤❤ 💯

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

    Thanks

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

    useful learning Material

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

    Thank you for this quick explanation.

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

    would it be unfair for the student with the same scores to rank lower?

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

    I really like it. It is very useful. Thank you.