- 99
- 349 672
karpagam Excel Prime
India
เข้าร่วมเมื่อ 16 พ.ค. 2019
My name is Karpagam Aras. I've created this channel to share the knowledge to the passionate excel learners community. I make short videos ranging from 1 min to long videos upto 10 mins. I'm into teaching excel for one decade and wanted to help people to learn excel at their convenient time. By subscribing to this channel, you will find lots of short videos and long videos Whether you want to learn a specific concept or want to learn in depth, you will find it here.
Filter data Dynamically | How to apply filter function in Excel
Filter function is available in Excel 2021 or Microsoft 365.Filter any data at ease with this function.
Keep Watching, Keep learning.
#filter #filterinexcel #Lookupfunction #lookup
Keep Watching, Keep learning.
#filter #filterinexcel #Lookupfunction #lookup
มุมมอง: 192
วีดีโอ
Excel Drop and Take function in Excel |
มุมมอง 3.1K2 ปีที่แล้ว
In this video, you will learn how to select the data that needs to be retained and deleted from the selection. It works best with Microsoft 365 subscription Keep Watching,keep learning #Excel #drop #take
Convert Timestamp to time easily
มุมมอง 2.2K3 ปีที่แล้ว
In this video, you will learn how to convert a timestamp to time easily using text function and time function We will use mid and time function to do this job. #time#timestamp #Excel Keep Watching, Keep Learning
How to Highlight every Saturday (any day ) of the week
มุมมอง 17K3 ปีที่แล้ว
In this video, you will learn how to highlight any day of the week without using any formula. You can do this by using simple data validation and conditional formatting. #highlightanysaturday #highlightanyday #excel #exceltips&tricks Keep Watching, Keep Learning
How to move rows and columns without inserting and deleting a row or column
มุมมอง 1.8K3 ปีที่แล้ว
In this video, you will learn how to move not a row or column but also a range of cells. 1. Select the row or column 2. Place the mouse key around its border till it turns into a 4 directional or 4 headed arrow. 3.Hold shift key and left mouse key together to see a green line appearing. 4.Choose the desired position and leave it. #moverow #movecolumn #movecells #Excel Keep Watching, Keep learning
Concat Vs Textjoin - Which one to use ?
มุมมอง 9343 ปีที่แล้ว
If you were perplexed regarding which one to use, this is the video that you are looking for. In this video, I have made a comparison between concat and textjoin function. Textjoin scores more when there is a text involves involved whereas concat is used more for numbers. #concat #textjoin #concatvstextjoin Keep Watching, keep learning.
How to consolidate data from multiple sheets to a single sheet
มุมมอง 8093 ปีที่แล้ว
In this video, you will learn how to consolidtae multiple sheets into a single video. #Excel #consolidate #multiplesheetstosinglesheet. Keep Watching,Keep Learning.
Learn the new Filter function in excel
มุมมอง 3614 ปีที่แล้ว
In this video you will learn how to use filter function in excel. This function is availble only in office 365 but a dynamic function which can make your job easy. This is an alternative to filter icon in the excel sheet. When you use the excel function it can help you in keeping the main table intact and the data can be extracted in another table. #Filterfunction #dynamic array #excel Keep Wat...
How to count dates in a year | Count dates based on the year
มุมมอง 2774 ปีที่แล้ว
Learn how to count the number of dates in a specific year using sumproduct and year function. Consider you have a customer database for the last 3 years. You are interested to find out how many purchases they have done and based on that you want to extend certain promo offers to them. At the first level, pass in sumproduct function and input double negative sign in the formula,post this pass ye...
Must pass 3 out of 4 subjects | How to find the Eligibility status with multiple criteria
มุมมอง 3454 ปีที่แล้ว
In this video, you will learn how to extract the data for 2 different condition. In this sheet, there is a table which consist of candidate name and training program they have attended . In order to appear for examination, they should have should 75% attendance in at least 3 subjects out of 4. In order to extract the data, i have used countif and if function together. Countif will calculate how...
How to find text within a parentheses
มุมมอง 5634 ปีที่แล้ว
Have you ever wondered how to find text within a parentheses, then this video is for you. I have used mid and search function to extract the text within a parentheses. 1. Identify the starting position of the parentheses and along with this identify the position of the first character within parentheses 2. Identity the closing position of the parentheses as it marks the end of your text 3. Dedu...
How to mask mid of a text in Excel | How to mask mid of a text in Excel using concat
มุมมอง 6K4 ปีที่แล้ว
Learn how to mask mid of a text or a string using Text functions. I have used five functions to mask the number for 3 different category. 1. Right 2. Mid 3.Left 4. Rept 5. Concat. If you want to know how to pad text and then mask number, please follow this link. th-cam.com/video/Q2Rz4VW4mz0/w-d-xo.html #masknumbers #masktext #left #mid #right #rept #concat Keep Watching,Keep learning.
How to pad text in Excel | Do you know how to pad text in excel
มุมมอง 2.5K4 ปีที่แล้ว
In this video, i will show you how to pad text in excel. This is one of the most pressing problems that people will come across while data cleaning. I have used text formula to pad the unequal length of record to equal length of record. Identify the max length of the array using len(max(a1:a9).let us say the max length from the array is 6 Then use a text formula =text(a2,"000000"). Post then i ...
How to find missing values | How to find missing values using if and countif function
มุมมอง 2.4K4 ปีที่แล้ว
Learn how to find missing values using if and countif function. If function is a logical function and countif is a statistical function. If function will perform the logical test and countif will perform missing values. When missing values are found, if function will perform logical test. #excel #if #countif #missingvalues #karpagamexcel To know more about if function,please click on this link ...
How to use substitute function in Excel | Case sensitive match use substitute function
มุมมอง 2064 ปีที่แล้ว
How to use substitute function in Excel | Case sensitive match use substitute function
How to use replace function in Excel | Learn replace function from basic to advanced
มุมมอง 2764 ปีที่แล้ว
How to use replace function in Excel | Learn replace function from basic to advanced
How to fix errors in Excel | #DIV/0! | #NAME? | #NULL! | #VALUE! | #N/A | #### | #NUM! | #REF
มุมมอง 6064 ปีที่แล้ว
How to fix errors in Excel | #DIV/0! | #NAME? | #NULL! | #VALUE! | #N/A | | #NUM! | #REF
Learn these new 6 formulas to become more productive at workplace | New formulas in Excel 2019 & 16
มุมมอง 3654 ปีที่แล้ว
Learn these new 6 formulas to become more productive at workplace | New formulas in Excel 2019 & 16
3 ways to highlight column differences | How to highlight column differences
มุมมอง 2864 ปีที่แล้ว
3 ways to highlight column differences | How to highlight column differences
How to copy and paste visible rows and columns
มุมมอง 3434 ปีที่แล้ว
How to copy and paste visible rows and columns
How to count only visible rows in a filtered list | Count only visible rows using a filtered rows
มุมมอง 6K4 ปีที่แล้ว
How to count only visible rows in a filtered list | Count only visible rows using a filtered rows
Index and Match : Basic to Advanced | Index and Match with Max,Min and Average function
มุมมอง 3.4K4 ปีที่แล้ว
Index and Match : Basic to Advanced | Index and Match with Max,Min and Average function
Get accurate results with Index and Match | How to use Index and Match
มุมมอง 2114 ปีที่แล้ว
Get accurate results with Index and Match | How to use Index and Match
How to highlight intersect columns and rows| Highlight intersect rows and columns -Logical functions
มุมมอง 6174 ปีที่แล้ว
How to highlight intersect columns and rows| Highlight intersect rows and columns -Logical functions
Generate Secure and Dynamic Password every time | How to create unique password everytime
มุมมอง 1.4K4 ปีที่แล้ว
Generate Secure and Dynamic Password every time | How to create unique password everytime
Insert symbol when a condition is met | How to insert symbol when a condition is met
มุมมอง 1684 ปีที่แล้ว
Insert symbol when a condition is met | How to insert symbol when a condition is met
Save lots of time with DMAX and DMIN function
มุมมอง 1944 ปีที่แล้ว
Save lots of time with DMAX and DMIN function
MAXIFS & MINIFS function in excel | Increase your productivity with maxifs & minifs function
มุมมอง 2174 ปีที่แล้ว
MAXIFS & MINIFS function in excel | Increase your productivity with maxifs & minifs function
How to calculate consecutive Saturdays or any days of a month | Calculate nth day of any week
มุมมอง 2.9K4 ปีที่แล้ว
How to calculate consecutive Saturdays or any days of a month | Calculate nth day of any week
How automatically put True as 1 and false as 0
Thank you mam!
Bkk
Grazie carissima !
Thank you so much it's a great help
Thank you for the short and sweet demo..it really worked
I know this video is 4 years old but it deserves 10k likes
What if one name comes to time
Thanks very useful
Very nice explanation make more videos and thank you
This is not working 😪
Hello, is there a website that I can reach out to you?
very nice thank you
Annnnd I don’t have the three dots lmao
Thank you Queen
Owsam video here, after going through some many videos that took me round in circles, you nailed it right here... am super grateful... Asante Sana..
Thank you so much!
shortcut for formatting is Alt + O + D and then choose New rule For those who can't understand because of accent like me
Very nice
Thank you, great video
Need to specific the fix for when sorting data. Whats the fix for that?
Excellent thank you
Thank you
I tried concatenating the contents from 2 xls sheets and this method worked flawlessly. keep up the good work.
Not working, plz decribe properly
Please tell us What to do if I want to highlight elements in the outlet row that are restock instead of higlighdinf restock cell itself higgglight element that is restock it would be more easier to pick items Thank u
Thank you. It really helped me with my project.
Awesome explained
Thank you
Great video
Super madam
Thanks ma'am
Very nice
Many thanks!!! Worked exactly how you demonstrated. And thanks for being so clear and direct to the point!
nice
Hi if we have duplicates in table 2 how to address this formula
I have not seen anyone explaining left padding in Excel. This is super helpful! I'm a big fan. 🤩🤩
Need start n end time same for five days n different only for Thursday. How???
Thankyou do much for this video mam really saves a lot of time.
How can we use conditional concatenate. Suppose my array is 30 cells and between 1 to 30 5 to 6 cells are empty and i want add in one cell value only which is greater than or equal to 1. Please guide i have been finding since one month
What is the shortkey to unhide the columns and row? Pls write
Great Vid!
I'm working on a schedule for work, during the week there are two shifts and on the weekend there are three shifts. I want to have Monday thru Friday then a row to add in the different times for the weekend and then a row again to add in the time for the weekdays I want this pattern to repeat and also change for every month??
Quite helpful. ❤
Thank you mam you are a greatest teacher of this world
💯
This is Great, Thank you
awesome video its ctrl 9
Finally! Something that really works.
Great tutorial. Thanks for sharing