sir i am from pakistan i am a bigg fan of yours ......awsome teacher you are.....zendabad........sir English spilling k bare mai ek series honii chahyeee......LOVE U
Sir, I am doing a job. Now I want to learn advance excel so that I can get a job or do freelance work. Please help me on how to make myself eligible for freelance work or get a job learning ms excel 🙏🏻
I have a question in Excel. I have a large dataset with product details like order name, order title, size, color, material, and package contents. How can I find the color, material, or other specific information? I have tried many times but i working on manually, How can I use automation or a formula? . If you have any ideas, please share or make a video.
Yes, you can 1) Filters: - Select your dataset, go to the Data tab, click Filter, and use dropdowns in headers to select specific values. 2) VLOOKUP: - Use =VLOOKUP(lookup_value, table_array, col_index_num, FALSE) to find details based on another column (e.g., color by order name). 3) INDEX and MATCH: - Use =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) for a flexible lookup (e.g., finding material based on order name). 4) Conditional Formatting: - Highlight specific information by selecting your data, going to Conditional Formatting, and setting rules based on your criteria. 5) PivotTables: - Insert a PivotTable to summarize and analyze data quickly by dragging fields into Rows and Values. 6) FILTER Function (Excel 365): - Use =FILTER(range, criteria) to dynamically filter data (e.g., =FILTER(A2:F100, C2:C100="Red") for all red items).
@@Excel_Tutorial but product details information one cell then how can I select lookup value for specific color or material find, can you share WhatsApp number I will share Data.
Excellent and nice explanation
Sir please such kind of videos on Power BI, Power Query and Power Pivot.
Thanks a lot
Sir ye videos dekh ke Excel me aag laga dala 😅😂💥💥
Jhakkash sir
Sir plz data cleaning pr ek video lao jisme ache se data clean kerna ajaye
Lovely 🌹🌹🌹🌹😍😍😍😍😍
Bahut achcha sikhate Hain sir aap
Kudos!!!
Mind blowing sir❤
very clearly explained all the formulas thank you asif sir🥰
Thank you sir❤
MAJA AA GYA SIR
Good explanation sir Tq very much.
good concept sir ji 🥰🥰🥰🥰🥰
Thanks a ton 🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳
Yes, I understand it's good
😊 thanks sir .
Excellent sir you are so good
Always watches Ur videos Satish sir ❤❤
😊 thanks
Very promising ❤
Thanks 😊
You're welcome! 😊😊😊😊😊😊😊
Excellent
Use full sir
19:06 NAHI SIR JI YE FINAL NAHI HAIL FINAL TO TAB HOGA JAB VLOOKUP KE SATH MATCH FORMULA KA USE KARENGE.
Kiraak...
Beautiful ❤
Thank you! 😊
sir i am from pakistan i am a bigg fan of yours ......awsome teacher you are.....zendabad........sir English spilling k bare mai ek series honii chahyeee......LOVE U
Sure 😊
Marvelous Sir
Excellent video great ❤not great more than great
Sir chalange complete ho gaya
Assalamu Alaikum Wa Rahmatullahi Wa Barakatuh Asif Sir
Awasome
😮any Excel supported
Gjb ba
You are most welcome 😊😊😊😊😊😊
Sir, can we pick up data of multiple cells from rows i-e horizontally by a lookup value cell at once using vlookup ? Will definitely answer, please.
Thankful I am pakistan
Islamabad
Sir मुझे पहले se aata hai aapki hi video se sikha tha
❤❤❤
Many many thanks 😊😊😊😊
❤
Thank you for the video, I have practice this formula but I’m not sure with some name’s this is not working
Sir I like you to launch a video on ageing receivables with 4 column of ageing and number of days dues to be shown in last column
excel formula for ACCOUNTANT make video full details
Sir pivort table par ek oneshort video banaiye,please
Will upload soon 😊😊😊😊😊😊😊😊😊
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
Sir plz sumif with vlookup formulas ka lesson karaye.
Ak dam lolipop sir, 😄😄😄
Sir, I am doing a job. Now I want to learn advance excel so that I can get a job or do freelance work.
Please help me on how to make myself eligible for freelance work or get a job learning ms excel 🙏🏻
=VLOOKUP($K$3,$A:$F, COLUMNS($K$6:L6),0) i will use cloumns() instead of row () for vertical columns.
Sir plzz email per course laiye
Kis kis ko sir ka padaya pasand aata he Masti ke saath 😊😊😅
Data cleaning video plz
Sure 😊
Sir mai aap ko contact kaise kro
Sar data cleaning per ek hi video Nahin Banai aapane ek video banaa do
Vlookup series 2nd time with Practice. 9/Dec/2024m ,
Thanks for watching 🥳🥳🥳🥳🥳🥳🥳🥳
I have a question in Excel. I have a large dataset with product details like order name, order title, size, color, material, and package contents. How can I find the color, material, or other specific information? I have tried many times but i working on manually, How can I use automation or a formula? . If you have any ideas, please share or make a video.
Yes, you can
1) Filters: -
Select your dataset, go to the Data tab, click Filter, and use dropdowns in headers to select specific values.
2) VLOOKUP: -
Use =VLOOKUP(lookup_value, table_array, col_index_num, FALSE) to find details based on another column (e.g., color by order name).
3) INDEX and MATCH: -
Use =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) for a flexible lookup (e.g., finding material based on order name).
4) Conditional Formatting: -
Highlight specific information by selecting your data, going to Conditional Formatting, and setting rules based on your criteria.
5) PivotTables: -
Insert a PivotTable to summarize and analyze data quickly by dragging fields into Rows and Values.
6) FILTER Function (Excel 365): -
Use =FILTER(range, criteria) to dynamically filter data (e.g., =FILTER(A2:F100, C2:C100="Red") for all red items).
@@Excel_Tutorial but product details information one cell then how can I select lookup value for specific color or material find, can you share WhatsApp number I will share Data.
Sir koi work from home job ho excel wali to batiye
Dhakkn
9
Hila daala
I am pattan, so send another comment for pattan name
Far dala
Hudibaba
JHAKAS BOLO TO HILA DALA
Jyada bak bak not like satish sir . Not like professional it's like kids