- 31
- 6 721
Excel Adda
เข้าร่วมเมื่อ 20 พ.ค. 2014
Excel videos to help you go through tough things in a easy way!
How to add Slicers & timelines in Pivot table | #exceltutorial
Have you ever thought of advanced filters in pivot table? Did you know that you can filter your data with multiple filters and that too with the ease of few clicks!! Slicers and timeline will help you do the same.
Let's go through the video to learn more!!
#exceladda #exceltutorial #exceltips
क्या आपने कभी पिवट टेबल में उन्नत फ़िल्टर के बारे में सोचा है? क्या आप जानते हैं कि आप अपने डेटा को कई फ़िल्टर के साथ फ़िल्टर कर सकते हैं और वह भी कुछ ही क्लिक की आसानी से!! स्लाइसर और टाइमलाइन आपको ऐसा करने में मदद करेंगे।
आइए अधिक जानने के लिए वीडियो देखें!!
Let's go through the video to learn more!!
#exceladda #exceltutorial #exceltips
क्या आपने कभी पिवट टेबल में उन्नत फ़िल्टर के बारे में सोचा है? क्या आप जानते हैं कि आप अपने डेटा को कई फ़िल्टर के साथ फ़िल्टर कर सकते हैं और वह भी कुछ ही क्लिक की आसानी से!! स्लाइसर और टाइमलाइन आपको ऐसा करने में मदद करेंगे।
आइए अधिक जानने के लिए वीडियो देखें!!
มุมมอง: 68
วีดีโอ
How to make a Pivot table | #exceltutorial #exceladda
มุมมอง 5128 วันที่ผ่านมา
Just a simple video on how to make a pivot table in excel. Pivot tables are one of the most powerful tools when it comes to data analysis and summary. People use it most of the time and if you don't know how to make it, you are seriously lacking the most needed skill in excel and you need to watch this video right now!! #exceladda #exceltutorial #pivots एक्सेल में पिवट टेबल कैसे बनाएं, इस पर बस...
9 Excel shortcuts that will make your life super easy!! #exceladda #exceltips
มุมมอง 102หลายเดือนก่อน
Shortcuts in excel just make it easy for you to work on your project in a faster way!! Beginners in excel might not be familiar with these shortcuts. But when you come to know about them, I bet it will make your life a whole lot easier!!! #exceladda #exceltips #exceltricks #exceltutorial एक्सेल में शॉर्टकट आपके लिए अपने प्रोजेक्ट पर तेजी से काम करना आसान बनाते हैं!! एक्सेल में शुरुआती लोग इन शॉ...
How to highlight cells/rows in Excel? #exceladda #exceltutorial
มุมมอง 58หลายเดือนก่อน
Highlighting cells in excel is easy using conditional formatting. But what would you do when you have to highlight entire rows which are duplicate? If you have ever come across a situation like this, then this is the video you need to watch!! #exceladda #exceltips #exceltricks #excelformula एक्सेल में कंडीशनल फ़ॉर्मेटिंग का उपयोग करके सेल को हाइलाइट करना आसान है। लेकिन जब आपको पूरी पंक्तियाँ हा...
How to change Case of letters to Uppercase, Lowercase & Proper case | #exceladda
มุมมอง 102หลายเดือนก่อน
So, this video is about changing the case of letters to uppercase, lowercase & proper case. Sometimes, you come in a situation where your raw data is not in clean form which means the case is not same or the spaces between letters are not same. This video will help you guide how you can clean your data using upper, lower & proper case functions in conjunction with TRIM function. So, get along a...
ERLP #9 : How to generate random decimal numbers between a range? | #exceltutorial
มุมมอง 1042 หลายเดือนก่อน
Sometimes you come under a situation when you to write random decimal numbers between two numbers and that too with a fixed decimal places? How would you do that?? There is no direct function in excel which can do this. But here we are!! We have made this video just for you, so go and learn this trick!! You can use it to generate numbers between any range. #exceltutorial #exceltips #exceladda #...
ERLP #8 : How to make Pareto chart in Excel that refreshes automatically!! | #exceltutorial
มุมมอง 1153 หลายเดือนก่อน
If you ever tried making a Pareto chart in excel, then most of the times you might have faced issues while making Cum% column & automatically refreshing data!! In this video, we will help you with both and make it with help of a pivot table!! #exceltutorial #exceltips #exceltricks #exceladda If you like the video, please share & subscribe !!!
ERLP #7 : How to use replace function to quickly clean your data? | #exceltutorial
มุมมอง 1003 หลายเดือนก่อน
Data uniformity is a big concern in Excel. If the data that we are entering is not uniform, it can lead to wrong analysis. So, many times we face such situations in excel where the data that we import is having many format errors or mistakes. But how do we clean it in one go? Excel's replace function can do it for you in seconds!! You just need to have the ability to properly use it. This video...
ERLP #6 : How to remove Blank rows/columns from your data? | #exceltutorial
มุมมอง 744 หลายเดือนก่อน
Somewhere back in time, you might have faced have faced problem where there are blank rows & columns in your data. This makes it difficult to analyze data!! But do not worry! Here we are with another Excel real life problem video and we will surly help you out!! Go watch this video right away!! #exceltips #exceltricks #exceladda #advanceexcel
ERLP #5 : How to format cells based on a condition? | #exceltutorial on conditional formatting
มุมมอง 524 หลายเดือนก่อน
Want to format cells based on a given condition? Use the formula editor in conditional formatting to format the cells according to any criteria!! Go watch the video now to learn more!! #exceladda #exceltutorial #exceltips #exceltricks क्या आप किसी दी गई स्थिति के आधार पर cells formatting करना चाहते हैं? किसी भी मानदंड के अनुसार cells को format करने के लिए conditional formatting में formula edit...
ERLP #4 : How to combine two text/strings into one ? | #exceltutorial for concatenate function
มุมมอง 274 หลายเดือนก่อน
Sometimes we get into a situation where there are two strings which are present in different columns. But we need to combine them and make a single word. How can we achieve this? In this video we will be talking about concatenate and ampersand function to combine two strings in different columns with delimiters in between...For better understanding, go watch the video now!!! #exceltutorial #exc...
Real life Problem #3 : How to convert from text to number format? | Resolve data format error !!!
มุมมอง 524 หลายเดือนก่อน
Have you ever encountered any data format error while exporting data from external source? You might have seen green highlights appearing on the cells. This is because the data that is stored is a number but it is stored in the text format. Here in this video, we have talked about two different ways to resolve this error!! Go watch the video now!!! #exceltutorial #exceladda #exceltips #exceltri...
Excel Real life Problem #2 : How to generate random integers & decimal numbers | #exceltutorial
มุมมอง 444 หลายเดือนก่อน
This video is about generating random numbers with & without decimal places. You can learn about the RAND, RANDBETWEEN 7 ROUND function in this video and how to use them in combination to generate random decimal numbers with desired decimal places... Go check out this video to learn more!! यह वीडियो दशमलव स्थानों के साथ और उसके बिना यादृच्छिक संख्याएँ उत्पन्न करने के बारे में है। आप इस वीडियो म...
How to use Pivot tables to summarize data Part II | #exceltutorial on Pivot table
มุมมอง 194 หลายเดือนก่อน
This video is succession to Pivot table video Part I. Just the same data but summary in a different way!! Go watch this interesting video to learn more!! #exceltutorial #exceltips #pivot_table Video links: How to make pivot table - th-cam.com/video/5CYA9RKIe6U/w-d-xo.htmlsi=2dpd2sAXP2ofaaPU यह वीडियो पिवोट टेबल वीडियो भाग I का उत्तराधिकार है। बिल्कुल वही डेटा लेकिन एक अलग तरीके से सारांश!! अधिक...
Excel Real life Problem #1: How to repeat a set of cell values infinitely | #exceltutorial
มุมมอง 864 หลายเดือนก่อน
Excel Real life Problem #1: How to repeat a set of cell values infinitely | #exceltutorial
How to summarize data using Pivot tables | #exceltutorial on PIVOT TABLES
มุมมอง 1044 หลายเดือนก่อน
How to summarize data using Pivot tables | #exceltutorial on PIVOT TABLES
How to generate letters/alphabets in series | #exceltutorial for generating alphabets in a row
มุมมอง 714 หลายเดือนก่อน
How to generate letters/alphabets in series | #exceltutorial for generating alphabets in a row
How to use Data Validation in Excel | Data validation kaise lagate hain? #exceltutorial
มุมมอง 644 หลายเดือนก่อน
How to use Data Validation in Excel | Data validation kaise lagate hain? #exceltutorial
How to use Hlookup function | #hlookup in excel #exceltutorial
มุมมอง 614 หลายเดือนก่อน
How to use Hlookup function | #hlookup in excel #exceltutorial
Understanding the INDEX & MATCH function | Alternative to Vlookup | #exceltutorial
มุมมอง 1904 หลายเดือนก่อน
Understanding the INDEX & MATCH function | Alternative to Vlookup | #exceltutorial
Common Mistakes/Errors while using Vlookup in Excel | #exceltutorial
มุมมอง 724 หลายเดือนก่อน
Common Mistakes/Errors while using Vlookup in Excel | #exceltutorial
How to apply Vlookup in Excel ? | Using Vlookup function in Excel #exceltutorial
มุมมอง 4.6K4 หลายเดือนก่อน
How to apply Vlookup in Excel ? | Using Vlookup function in Excel #exceltutorial
How to use CountIF for multiple criterias in same as well as different columns | #exceltutorial
มุมมอง 335 หลายเดือนก่อน
How to use CountIF for multiple criterias in same as well as different columns | #exceltutorial
Using CountIFs function for multiple criteria | #excelformula
มุมมอง 255 หลายเดือนก่อน
Using CountIFs function for multiple criteria | #excelformula
Using CountIF for a single criteria or condition | #exceltutorial for CountIF function
มุมมอง 365 หลายเดือนก่อน
Using CountIF for a single criteria or condition | #exceltutorial for CountIF function
How to use CountIF, SumIF in Excel | Excel tutorial for beginners
มุมมอง 565 หลายเดือนก่อน
How to use CountIF, SumIF in Excel | Excel tutorial for beginners
How to book confirm tickets amid waitlist tickets!! Easily get confirmed tickets!
มุมมอง 24ปีที่แล้ว
How to book confirm tickets amid waitlist tickets!! Easily get confirmed tickets!
How to place trade in Fyers? | Place buy & sell trades easily!!
มุมมอง 19ปีที่แล้ว
How to place trade in Fyers? | Place buy & sell trades easily!!
How to book tickets on IRCTC website? | Easily book tickets in minutes!!
มุมมอง 25ปีที่แล้ว
How to book tickets on IRCTC website? | Easily book tickets in minutes!!
Informative
👍👍
👍
👍👍👍
👍👍👍👍
👍👍👍👍
Very nice sir...👍
👍
👍👍👍
Well explained sir
Thanks and welcome 🤗
Sir , you have explained it soo easily
🙂👍
Guys...if you feel anything can be improved in this video...feel free to comment
Very nicely explained . .. sir 👍
Very useful!
Usefull
Thanks
Very useful!
Hiii, Isme agar hum koi drawing karte hai tto kya vo save rehta hai logout karne ke bad bhi??
yes it is saved