చందూ గారికి ధన్యవాదాలు! చందూ గారూ ! నేను మీ యూట్యూబ్ పేజీని రెగ్యులర్ గా ఫాలో అవుతూ ఉన్నాను ! దయచేసి మన మాతృభాష తెలుగులో నా లాంటి ప్రారంభకులకు MS Excel వీడియోలను క్రమం తప్పకుండా అప్‌లోడ్ చేయండి!
Hi sir this video was very helpful Eclairs or Orange Choco - Which sells more? Eclairs total amount = 87213 (=SUMIFS(E6:E209,D6:D209,"Eclairs") Total sells = 5133 (=SUMIFS(F6:F209,D6:D209,"Eclairs") Orange Choco total amount =59661(=SUMIFS(E6:E209,D6:D209,"Orange choco") Total Sells =7007 (=SUMIFS(F6:F209,D6:D209,"Orange Choco") so in this the Orange Choco sells are more All "Venkat" sales Total Venkat sales amount =57967 (=SUMIFS(E6:E209,C6:C209,"*Venkat*") Total Boxes = 3999 (=SUMIFS(F6:F209,C6:C209,"*Venkat*") Chandoo sir is this correct??
Hi Chandoo, it was nice to watch your videos related to excel. So i request you to make a video's related to prepare hr reports and hr analytics reports and hr monthly reports and add with those reports with Power BI and Tableau. It would be useful for professional
Hi sir , just now seeing your videos its really nice way to understand and continue the videos , and coming to the home work Eclairs has sell 5133 boxes and in amount has 87213 & orange choco is sell 7007 boxes and amount is 59661 ,, and venkat sales boxes is 3999, in amount is 57967.
Hi Nice to see you again with words ☺️. I'm watching your videos since one year. I like way teaching & easy to understand as well as give file to practice. Thanks.
మీ వీడియో చాలా బాగున్నాయి. సాధారణంగా 2019 గాని అంతకన్నా ఎక్కువ వెర్షన్ office soft ఎక్కడ దొరుకుతుంది. ఆన్లైన్ లో one year ki చాలా ఎక్కువ. Lifetime use తక్కువలో ms office దొరకదా?
Anna given data in excel how to we know which formula we use for this given data like sumifs, countif, countifs, H, V, please make one video on this please
Hi Sir, Could you please Tell Advance Excel ..how to use in Mis executive or Mis analyst or data analyst.....Because you are giving life, who are interested to do job in real life
Hlo chandu gaaru i am a working professional with banking industry and want to learn the POWER BI can you recommend the channel from which I can Learn the course
Complete data visualisation in excel (maps, graphs, bars, charts etc) ela cheyali... simple & short video okati Cheyandi please... because, konni companies lo PowerBi & tableau ki money invest cheyakunda, only Excel meeda work cheyamantunnaru...hope you understand.
bro nenu chesanu bro meeru ichina home work oka doubt vachindi naku ippudu first point Eclairs and orange choco which selles more daniki nenu two steps lo chesanu individual ga chesanu andi rendu okkasare yela cheyyali in one step please cheppandi
Hi Anna, In case of number of boxes, Orange choco sells more with 7007 boxes And All Venkat sales are Rs.57967/- Please let me know Anna wheather right or wrong
Hi Sir, I am raja I billing person. I have questions sir. . In A Column I have written dates. And the B column is the time I haven taken bill to complete. in some cell I will write the date in it. Besides, it wants to calculate to total time taken to bill one on that date. When every change date it's that day's Avg time.
Looks like you almost got it. If AVERAGEIFS is giving error, it means there are no bills or all times on that day are 0. In either case, you can use IFERROR() to print another message.
1) Eclairs sales 87213 2) Orange choco sales 59661 3) All venkat sales 57967 correct kada bro if correct please reply it motivate me. and meru elanti videos inka enno cheyyandi last lo home work marchpokandi
Question is " which sells more" they didn't ask product details. So, Formula will be =IF(SUMIFS(E5:E208,C5:C208,"Orange Choco")>SUMIFS(E5:E208,C5:C208,"Eclairs"),"Orange Choco","Eclairs") This will give you which has more sells. Correct me if i'm wrong
చందూ గారికి ధన్యవాదాలు!
చందూ గారూ ! నేను మీ యూట్యూబ్ పేజీని రెగ్యులర్ గా ఫాలో అవుతూ ఉన్నాను !
దయచేసి మన మాతృభాష తెలుగులో నా లాంటి ప్రారంభకులకు MS Excel వీడియోలను క్రమం తప్పకుండా అప్‌లోడ్ చేయండి!
Hi Chandoo Anna, data analyst complete course Telugu lo plan cheyyandi anna please.
చాలా థాంక్స్ చందు గారు.. మాతృ భాష మరచిపోకుండా మీ వంతు కర్తవ్యం చేస్తున్నారు, irrespective of views, you are uploading videos 🙏
Thanks for ur passion for Telugu videos ❤
Hi sir this video was very helpful
Eclairs or Orange Choco - Which sells more?
Eclairs total amount = 87213 (=SUMIFS(E6:E209,D6:D209,"Eclairs")
Total sells = 5133 (=SUMIFS(F6:F209,D6:D209,"Eclairs")
Orange Choco total amount =59661(=SUMIFS(E6:E209,D6:D209,"Orange choco")
Total Sells =7007 (=SUMIFS(F6:F209,D6:D209,"Orange Choco")
so in this the Orange Choco sells are more
All "Venkat" sales
Total Venkat sales amount =57967 (=SUMIFS(E6:E209,C6:C209,"*Venkat*")
Total Boxes = 3999 (=SUMIFS(F6:F209,C6:C209,"*Venkat*")
Chandoo sir is this correct??
Hi Chandoo, it was nice to watch your videos related to excel. So i request you to make a video's related to prepare hr reports and hr analytics reports and hr monthly reports and add with those reports with Power BI and Tableau. It would be useful for professional
Chala Baga explain chesaru all the best ilane manchi videos Inka cheyyandi
Followers lerani badha padakandi miru iche lessons kavali anukunna variki chala use avuthaunnay thanku sir
Hi sir , just now seeing your videos its really nice way to understand and continue the videos , and coming to the home work Eclairs has sell 5133 boxes and in amount has 87213 & orange choco is sell 7007 boxes and amount is 59661 ,, and venkat sales boxes is 3999, in amount is 57967.
Send formula
@@sridharnalla8554 Same shown in the video
Please do more excel related video's in telugu. am eagerly waiting.
Nice to see you in telugu language ;)😉
Please do full video on excel it will helps us alot
Hi
Nice to see you again with words ☺️. I'm watching your videos since one year. I like way teaching & easy to understand as well as give file to practice.
Thanks.
ALL THE BEST' FOR TELUGU CHANNEL 🎉🎉🎉
nice video we need more from you
మీ వీడియో చాలా బాగున్నాయి. సాధారణంగా 2019 గాని అంతకన్నా ఎక్కువ వెర్షన్ office soft ఎక్కడ దొరుకుతుంది. ఆన్లైన్ లో one year ki చాలా ఎక్కువ. Lifetime use తక్కువలో ms office దొరకదా?
Chala baga chepparu anna
Could you please make a video on Mainframe..
Anna, menu bar (task bar) or ribbon paina em options ela, enduku, ekkada nundi (ela) pettukunte manchidi .. oka video cheyandi please...
Chandu గారు నమస్తే. మీరు కేవలం టోటల్ కు మాత్రమే చెప్పారు. ఆలా కాకుండా చివరి రెండు సెల్స్ ఎలా multiply చేయాలో cheppandi
Anna given data in excel how to we know which formula we use for this given data like sumifs, countif, countifs, H, V, please make one video on this please
HI Chandoo annya SQL telugu lo upload chestara ah.....if possible Machine learning videos kuda me style lo..!!!
Hi Sir,
Could you please Tell Advance Excel ..how to use in Mis executive or Mis analyst or data analyst.....Because you are giving life, who are interested to do job in real life
Hlo chandu gaaru i am a working professional with banking industry and want to learn the POWER BI can you recommend the channel from which I can
Learn the course
H1: Orange Choco sells 7007 boxes which is more than Eclairs(5233).
H2: All Venkat named sales amount 57967.
Complete data visualisation in excel (maps, graphs, bars, charts etc) ela cheyali... simple & short video okati Cheyandi please... because, konni companies lo PowerBi & tableau ki money invest cheyakunda, only Excel meeda work cheyamantunnaru...hope you understand.
Hi Chandoo how to convert a formula as numbers after certain time automatically
bro nenu chesanu bro meeru ichina home work oka doubt vachindi naku ippudu first point Eclairs and orange choco which selles more daniki nenu two steps lo chesanu individual ga chesanu andi rendu okkasare yela cheyyali in one step
please cheppandi
Hi Anna,
In case of number of boxes, Orange choco sells more with 7007 boxes
And All Venkat sales are Rs.57967/-
Please let me know Anna wheather right or wrong
Awesome chocolates becomes "Adbuthamaina chocolatluu"😄😄
Should be "adbhuthamaina tayilalu" or laddulu. 😋
Every one giving product details
Please send formula of eclair and orange chaco
=IF(SUMIFS(E5:E208,C5:C208,"Orange Choco")>SUMIFS(E5:E208,C5:C208,"Eclairs"),"Orange Choco","Eclairs")
Sir last lo target reached ani Icon add chesaru. Adhi ela add chesaru
Eclairs or Orange Choco - Which sells more? : Orange Choco(7007)
All "Venkat" sales : 57967/-
Hi Sir, I am raja I billing person. I have questions sir. . In A Column I have written dates. And the B column is the time I haven taken bill to complete. in some cell I will write the date in it. Besides, it wants to calculate to total time taken to bill one on that date. When every change date it's that day's Avg time.
Sir help me on this reply
hh:mm:ss
00: 31:02
averageifs function is not taking zero sir. It's getting #DIV/0!
Looks like you almost got it.
If AVERAGEIFS is giving error, it means there are no bills or all times on that day are 0.
In either case, you can use IFERROR() to print another message.
I mail about this sir. Once check sir.
@@data_with_chandoo sir once check mail sit
1) Eclairs sales 87213
2) Orange choco sales 59661
3) All venkat sales 57967
correct kada bro if correct please reply it motivate me. and meru elanti videos inka enno cheyyandi last lo home work marchpokandi
Question is " which sells more" they didn't ask product details. So, Formula will be
=IF(SUMIFS(E5:E208,C5:C208,"Orange Choco")>SUMIFS(E5:E208,C5:C208,"Eclairs"),"Orange Choco","Eclairs")
This will give you which has more sells.
Correct me if i'm wrong
@@vihalgupta900 Product sales depend on No.of Boxes sold, not the amount of boxes.
Power bi not yet started in Telugu?
I will be adding Power BI videos later this year and next year too.