![Excel Rush](/img/default-banner.jpg)
- Видео 73
- Просмотров 4 848 269
Excel Rush
Индия
Добавлен 28 фев 2015
Learn how to use Excel on a daily basis, in real-life scenario's.
- Manage Personal Finance
- Business analysis
- Use and analyze Sales data efficiently
Online course on - Master Business Reporting with Pivot tables and charts in Excel
Click the link here - www.udemy.com/master-business-reporting/
- Manage Personal Finance
- Business analysis
- Use and analyze Sales data efficiently
Online course on - Master Business Reporting with Pivot tables and charts in Excel
Click the link here - www.udemy.com/master-business-reporting/
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
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
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
Thanks bro ❤
i tried but the connect the data line tab is not highlighted what else should i do
Thank you so much.I was searching for this info but finally I have known how to freeze selected columns
Now how to Freeze pane 3 rows at the Bottom?
always to the point
THANKS
Thank u so much bro❤ I SUBBED
thank bhai aapne mera soluation bata diya
thanks, its work
Great work
Thank you u solved my problem😊
super useful. A question, what if you have a pivot chart that is associated with a pivot table that you also want to copy?
Thank u. U really fixed the issue within a minute. Kudos 💐
Thanks so much . That worked for me i was having hard time freezing middle rows .
Thank you for this quick and simple explanation. You've fixed my graph!
Thanks, you made that easy
Upto how much times multiple criteria will work.
After a lot of searching I found this video, it's really rare video Thank you so much
excellent
Thank you
Thanks very much for solving my problem so quickly 🎉
Super 😮😂
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.
Thank so much Sir
Thank you
You have no idea how useful this was. Thank you!
Good job man..short and simple 💪
What a simple explanation in a small time. Thanku
Thank you so much sir .What a explaination🔥🔥
Thanks! I have just resolved an issue related to your tutorial...... May Allah bless you!
🎉🎉🎉Good one🎉🎉🎉
not mentioned the desire number of row... only menting top and left blended rows and column... making the people fool
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!
@@Excelrush Here you replied with ' top & left', this should be there in video title.. where mentioned multiple rows and columns
Appreciate the feedback. Will apply this learning in future videos. Thanks!
Len=gend
thanks bro
Great
Thanks alot... How to do final sumup of all the difference??
Thank you.
super rush, so easy to understand, no bla bla bla, straight to the core!!!, amazing, thank you prof.!
Thank you thank you thank you
Excellent explanation'
THANK YOU
Thank You
Very well explained in short
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....
❤❤❤❤❤ 💯
Thanks
useful learning Material
Thank you for this quick explanation.
would it be unfair for the student with the same scores to rank lower?
I really like it. It is very useful. Thank you.