chandu brother i am at the age 53 i am understanding your class very well brother thank you brother upcoming students ki me class chala use aowthavi brother👍👍
Here you go. Have updated the video with them as well. 0:00 - Introduction to Excel Formulas 0:51 - The data set and 10 business problems 1:49 - Why we use Excel functions & formulas? 6:00 - Business problem 1: Total salary and headcount by department 16:48 - 2: All employees with more than $100k salary 22:40 - 2: Adjusting filter function to see only a few columns 25:38 - 3: All female employees with more than $100k salary 30:52 - 4: Lowest, highest and top 5 values 34:36 - 4: Using TAKE + SORT functions to get the top 5 values 39:45 - 5: List all departments by removing duplicates and count them 44:08 - 6: VLOOKUP, INDEX+MATCH functions with a business problem (our favorite) 51:03 - 7: Using XLOOKUP to replace VLOOKUP and INDEX / MATCH functions 56:03 - Using INDEX+MATCH functions vs. using XLOOKUP 1:03:17 - 8: Complex formula - who is the person with highest salary? 1:08:50 - 9: Complex formula - all employees that joined in the month of March 1:12:21 - 10: Complex scenario - make a department report using many different formulas 1:18:20 - In closing
First of all tysm for uploading such useful videos.Sir please create more videos in telugu on power query, copilot ,like how to automate our data in excel for free in telugu, it's a sincere request from our end... Hope u take time and publish the videos soon.
If someone dont't have TAKE function use this formula =LARGE(SORT(FILTER(staff[Salary],staff[Gender]="male"),,-1),G6:G10) without sort also you can do this problem
Anna ela nay MIS Executive or MIS Analyst ki samdenchina Real time projects chy Anna using Advance excel and SQL use chysi please chela help aeodhi🤗🤗🤗🤗🤗
home work 1. =COUNTIFS(staff[Department],B3:B16,staff[Employee type],"permanent") 3.=FILTER(staff[[Emp ID]:[Start Date]],(staff[Salary]>F67)*(staff[Gender]="female")*(staff[Start Date]>=DATE(2020,1,1))) 5.=TRANSPOSE(SORT(UNIQUE(staff[Department])))
HI Sir Big Thank you, Video is very useful, I am facing an issue with CHOOSECOLS Function. it's not working my Excel is there any function to replace CHOOSECOLS. Please Reply me. Thank You.
Dear sir, If possible make a video I have a request we are actually.using SAP script & dumping the data Excel like vba automation. That script works directly in Dear sir, "We're currently using SAP Script to extract data and then employing VBA automation to dump it into Excel. This script operates directly within Excel. I understand that a similar process is possible in Power BI. My query is: Is there a direct link or integration method to connect SAP directly to Power BI, bypassing the intermediate Excel step? This would streamline the data extraction and analysis process." Or, for a more concise version: "We're using SAP Script and VBA to extract SAP data into Excel. Is there a direct way to connect SAP to Power BI for more
SIR NADI EXCEL 360 EY KANI NA EXCEL LO FILTER VASTUNDI KNI CHOOSECOLS,TAKE FUNCTION LEDU EMI AINA SETTINGS CHANGE CHEYYALAAA SIR IF ANY ONE KNOWS PLZ REPLY MEE
Tried third Home work Taks - Who joined in or after 2020 with below formula it showed correct result =FILTER(staff[Emp ID]:staff[Salary], (staff[Salary]>F67)*(staff[Gender]="Female")*(staff[Start Date]>=DATE(2020,1,1)))
brother i havèa dought 1st nen danni clear ga explain cehyyaaniki try chesta plz kasta opikiga chadavandi im working on a marketing field ikkada naku daily task okati untadi target montly untadi aithey yesterday nen oka 10 sops sale chesina cell C lo enter chesina and to day oka 6 sopas sale chesina n repu kua 15 chesina ani expect chestunna aithey! nen daily sale enter cheyyaniki refrence cell okati teesukunta cell D naku ninnati data C lo undi e roju data D cells lo undi. ninnatidi and e roju di cell C lo total kavali aiheu past old data antha ninnatidi monnatidi aha mundu di antha C cell add ayyi undali and nenu daily D cell lo add chesta naku past date antha e roju data ki add kavali malla nenu D chell lo repati data add cheste old data + today data anedi naku kanipiyyali fourmula etla sir adi
Bro, meeru cheppina new formulas web page lo Microsoft 365 login chesi try chesthunte formula bar kanipinchatledu + cells lo kuda formula enter cheylekapothunna. What's the alternative to use new age powerful formulas, please suggest? Paid version teeskuntene panichestada? Pls reply
హాయ్ సర్ మీరు echina excel file lo formulas work avutunnayi , meeru echina file lo unna data ni copy cheysi excel new lo paste chesysi formula apply cheysanu but its shows 0, please help me in this
అన్న 2012లో mba చేసా మధ్యలో చాలా జాబ్స్(teaching +It job)చేసా ఇప్పుడు data analyst గా జాబ్ చేయాలనీ ఉండి skills నేర్చుకున్న but no జాబ్స్. Without DA exp నాకు జాబ్ వస్తుందా?
Anna meru table array select chese Pani lekunda Ela staff , employee id create chesaru, formula lo kodite vachelaga ,if anyone known about it let me know 😊
01/10 i selled 10 sops entereed in cell A 02/10 i selled 12 sops entereed in cell A or B 03/10 i selled 9 sops entereed in cell C 04/10 i selled 8 sops entereed in cell c 05/10 i selled 10 sops entereed in cell c naku C cell lo daily sale enter chesta naku B lo o1 to 5 total undali 49 soaps 06/10 i sell 6 chesina naku automatics ga 49 ki 6 add ayyi UNDALI
Here you go. Have updated the video with them as well. 0:00 - Introduction to Excel Formulas 0:51 - The data set and 10 business problems 1:49 - Why we use Excel functions & formulas? 6:00 - Business problem 1: Total salary and headcount by department 16:48 - 2: All employees with more than $100k salary 22:40 - 2: Adjusting filter function to see only a few columns 25:38 - 3: All female employees with more than $100k salary 30:52 - 4: Lowest, highest and top 5 values 34:36 - 4: Using TAKE + SORT functions to get the top 5 values 39:45 - 5: List all departments by removing duplicates and count them 44:08 - 6: VLOOKUP, INDEX+MATCH functions with a business problem (our favorite) 51:03 - 7: Using XLOOKUP to replace VLOOKUP and INDEX / MATCH functions 56:03 - Using INDEX+MATCH functions vs. using XLOOKUP 1:03:17 - 8: Complex formula - who is the person with highest salary? 1:08:50 - 9: Complex formula - all employees that joined in the month of March 1:12:21 - 10: Complex scenario - make a department report using many different formulas 1:18:20 - In closing
anna i went on interview,today i faced how to remove duplicates in excel using only function ans: I told Unique function. I used unique function in excel sheet, but i didn't get answer. formula =unique(B2:B340)
Female Ratio =C6#&":"&COUNTIFS(staff[Department],B6#,staff[Gender],"Female") Median Salary =MEDIAN(FILTER(staff[[Department]:[Salary]],(staff[Department]=B6)*(staff[Salary]))) anna idhi correcte na
DID ANY ONE DO 2ND HOME WORKK FEMALE 2020 PLZ WRITE OR CORRECTION MY FUNCTION =FILTER(staff,(staff[Salary]>F67)*(staff[Gender]="female")*(staff[Start Date]>"2020"))
Anna asalu staff table ekkadundi akkada naku total sal avg kuda avvatledu mistake ento teliyatledu cheppu anna pls, mi data ni copy chesi new tab lo paste chesi chesthunte ravatledu y anna
after you have pasted the data in Excel, select any cell in the data and see if you have "table design" or "design" ribbons. If so, you have a table. Go to that ribbon and check the table name in the corner. Change it to "staff". If you don't have that ribbon, while keeping any one cell selected, press CTRL+T and create the table. Now change the name to "staff"
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
అన్నా నువ్వు మా పాలిట దేవుడు అన్న నిజంగా నువ్వే లేకపోతే ఈరోజు మేము ఈ స్థాయిలో ఉండేవాళ్ళం కాదన్నా థాంక్స్ చెందన్న
Yes u r right
Hi bro what do you do bro present
Sir we are waiting for new video sir ,we love you so much and your videos are so helpful in our work place
I really appreciate you taking the time to teach Excel formulas. It's a game-changer
Annayya chala manchi video chesaru. Edarilo unnavallaki oasis lantidi ee video. Thank you.
Thank you sir, Very useful Class
chandu brother i am at the age 53 i am understanding your class very well brother thank you brother upcoming students ki me class chala use aowthavi brother👍👍
Chala baga cheoutunnaru really you are great🙏🏻🙏🏻
Wow, superb
Here you go. Have updated the video with them as well.
0:00 - Introduction to Excel Formulas
0:51 - The data set and 10 business problems
1:49 - Why we use Excel functions & formulas?
6:00 - Business problem 1: Total salary and headcount by department
16:48 - 2: All employees with more than $100k salary
22:40 - 2: Adjusting filter function to see only a few columns
25:38 - 3: All female employees with more than $100k salary
30:52 - 4: Lowest, highest and top 5 values
34:36 - 4: Using TAKE + SORT functions to get the top 5 values
39:45 - 5: List all departments by removing duplicates and count them
44:08 - 6: VLOOKUP, INDEX+MATCH functions with a business problem (our favorite)
51:03 - 7: Using XLOOKUP to replace VLOOKUP and INDEX / MATCH functions
56:03 - Using INDEX+MATCH functions vs. using XLOOKUP
1:03:17 - 8: Complex formula - who is the person with highest salary?
1:08:50 - 9: Complex formula - all employees that joined in the month of March
1:12:21 - 10: Complex scenario - make a department report using many different formulas
1:18:20 - In closing
Thank you ❤
First of all tysm for uploading such useful videos.Sir please create more videos in telugu on power query, copilot ,like how to automate our data in excel for free in telugu, it's a sincere request from our end... Hope u take time and publish the videos soon.
it will give female ratio in each DEPARTMENT
=COUNTIFS(staff[Department], B6, staff[Gender], "Female") / COUNTIF(staff[Department], B6)
నమస్తే చందూ అన్న, power BI ఫుల్ కోర్స్ తెలుగులో
very useful class sir
Namaste Anna wonderful explanation thankyou ❤
anna super for helping us 🤩🤩🤩🤩
Thanks for all your videos anna
Great Man
Anna Thank you soo much for your efforts
out fit bagundi sir chalaaa
Thankyou so much sir🙏🙏
Thanks chandoo
I'm new subscriber to you anna ur explaining very well ❤❤
PermanentEmployee Head count each department Answer : =COUNTIFS(staff[Employee type],"Permanent",staff[Department],B3)
Got the answer Thank you very much
Got it ,Thanks Bro
double qoute iyyatle permanent ki sir nen anduku ani error vastu undi tnq bossss
=COUNTIFS(staff[Department], B3:B14, staff[Employee type], "Permanent")
14:20 Previously i used a formula but I used =avrage only but thè actual is =averagesifs i forget ifs then I used Total Salary/Headcount simple
=COUNTIFS(staff[Department], B3, staff[Employee type], "Permanent")
=COUNTIFS(staff[Department], B3, staff[Employee type], "Temporary")
=COUNTIFS(staff[Department], B3, staff[Employee type], "Fixed Term")
If someone dont't have TAKE function use this formula =LARGE(SORT(FILTER(staff[Salary],staff[Gender]="male"),,-1),G6:G10)
without sort also you can do this problem
Complete MS Outlook mida video cheyandi please
Anna ela nay MIS Executive or MIS Analyst ki samdenchina Real time projects chy Anna using Advance excel and SQL use chysi please chela help aeodhi🤗🤗🤗🤗🤗
home work
1. =COUNTIFS(staff[Department],B3:B16,staff[Employee type],"permanent")
3.=FILTER(staff[[Emp ID]:[Start Date]],(staff[Salary]>F67)*(staff[Gender]="female")*(staff[Start Date]>=DATE(2020,1,1)))
5.=TRANSPOSE(SORT(UNIQUE(staff[Department])))
Chandoo sir please start Data Analytics free course in telugu also please sir
Can you please make complete video on python in your way
Azure data gurinchi oka basic video cheyandi annayya meku time unnappudu.
Is azure data required for data analyst
Data Analysis project Yala Chayalo chapthara sir
HI Sir Big Thank you, Video is very useful, I am facing an issue with CHOOSECOLS Function. it's not working my Excel is there any function to replace CHOOSECOLS. Please Reply me. Thank You.
sir home work file kuda ivvandi sir nen try chesina kani rale so that nen refer cheyyaniki check cheyyaniki option lekunde naku ami
Anna nenu ne video use cheskovacha plz chala usefull ga undi
Use ante?
Chadukoneki and office vallaki nerpincheki and ma channel lo pettukoneki
Sorry no. You can refer them to my channel. Don't copy or download the video illegally.
I am not using illegally I am asking you directly there is nothing to do illegal
Any ways tq
hello Sir,in my Excel i do not find chossecols , is there any alternative for that ??
Thanks for the knowledge sharing please use better Mike and remove background noise while editing and set echo properly
You are welcome. I think the problem is with your ear phones or audio. The audio quality is pretty good.
@@data_with_chandoo no sir it's resounding like a closed room any way thanks for the reply please do more useful vedios.
You are welcome brother :) Try with another device or headphones. I can't hear such echo or reverb (unless I really try hard).
@@sairamnandigam5525 voice clarity is excellent not even ok ok.. frst check your mobile audio or earphone quality then comment
Sir Suprise answers please
sir i am new begineer to excel can you please send that chalenge task formulas its little tough to me to solve that challenge tasks
Dear sir,
If possible make a video
I have a request we are actually.using SAP script & dumping the data Excel like vba automation.
That script works directly in
Dear sir,
"We're currently using SAP Script to extract data and then employing VBA automation to dump it into Excel. This script operates directly within Excel.
I understand that a similar process is possible in Power BI.
My query is: Is there a direct link or integration method to connect SAP directly to Power BI, bypassing the intermediate Excel step? This would streamline the data extraction and analysis process."
Or, for a more concise version:
"We're using SAP Script and VBA to extract SAP data into Excel. Is there a direct way to connect SAP to Power BI for more
SIR NADI EXCEL 360 EY KANI NA EXCEL LO FILTER VASTUNDI KNI CHOOSECOLS,TAKE FUNCTION LEDU EMI AINA SETTINGS CHANGE CHEYYALAAA SIR
IF ANY ONE KNOWS PLZ REPLY MEE
Sir I want growth engine pivot table plsss
Tried third Home work Taks - Who joined in or after 2020 with below formula it showed correct result
=FILTER(staff[Emp ID]:staff[Salary], (staff[Salary]>F67)*(staff[Gender]="Female")*(staff[Start Date]>=DATE(2020,1,1)))
Still the start date column is not showing!!!formatt!!!
@@srivarshathandra9156 It worked for me
Thank you, bro! I got the result
@@srivarshathandra9156 Check the formula properly
brother i havèa dought 1st nen danni clear ga explain cehyyaaniki try chesta plz kasta opikiga chadavandi im working on a marketing field
ikkada naku daily task okati untadi
target montly untadi aithey
yesterday nen oka 10 sops sale chesina cell C lo enter chesina
and to day oka 6 sopas sale chesina n repu kua 15 chesina ani expect chestunna
aithey!
nen daily sale enter cheyyaniki refrence cell okati teesukunta cell D
naku ninnati data C lo undi e roju data D cells lo undi. ninnatidi and e roju di cell C lo total kavali aiheu past old data antha ninnatidi monnatidi aha mundu di antha C cell add ayyi undali and nenu daily D cell lo add chesta naku past date antha e roju data ki add kavali malla nenu D chell lo repati data add cheste old data + today data anedi naku kanipiyyali fourmula etla sir adi
Bro, meeru cheppina new formulas web page lo Microsoft 365 login chesi try chesthunte formula bar kanipinchatledu + cells lo kuda formula enter cheylekapothunna. What's the alternative to use new age powerful formulas, please suggest?
Paid version teeskuntene panichestada?
Pls reply
Ai గురించి కూడా చెప్తారా
హాయ్ సర్ మీరు echina excel file lo formulas work avutunnayi , meeru echina file lo unna data ni copy cheysi excel new lo paste chesysi formula apply cheysanu but its shows 0, please help me in this
sir app link send cheyaraa sir
❤❤
అన్న 2012లో mba చేసా మధ్యలో చాలా జాబ్స్(teaching +It job)చేసా ఇప్పుడు data analyst గా జాబ్ చేయాలనీ ఉండి skills నేర్చుకున్న but no జాబ్స్. Without DA exp నాకు జాబ్ వస్తుందా?
Anna meru table array select chese Pani lekunda Ela staff , employee id create chesaru, formula lo kodite vachelaga ,if anyone known about it let me know 😊
01/10 i selled 10 sops entereed in cell A
02/10 i selled 12 sops entereed in cell A or B
03/10 i selled 9 sops entereed in cell C
04/10 i selled 8 sops entereed in cell c
05/10 i selled 10 sops entereed in cell c
naku C cell lo daily sale enter chesta naku B lo o1 to 5 total undali 49 soaps
06/10 i sell 6 chesina naku automatics ga 49 ki 6 add ayyi UNDALI
BROTHER PLEASE MENTION THE TIME STAMPS
Here you go. Have updated the video with them as well.
0:00 - Introduction to Excel Formulas
0:51 - The data set and 10 business problems
1:49 - Why we use Excel functions & formulas?
6:00 - Business problem 1: Total salary and headcount by department
16:48 - 2: All employees with more than $100k salary
22:40 - 2: Adjusting filter function to see only a few columns
25:38 - 3: All female employees with more than $100k salary
30:52 - 4: Lowest, highest and top 5 values
34:36 - 4: Using TAKE + SORT functions to get the top 5 values
39:45 - 5: List all departments by removing duplicates and count them
44:08 - 6: VLOOKUP, INDEX+MATCH functions with a business problem (our favorite)
51:03 - 7: Using XLOOKUP to replace VLOOKUP and INDEX / MATCH functions
56:03 - Using INDEX+MATCH functions vs. using XLOOKUP
1:03:17 - 8: Complex formula - who is the person with highest salary?
1:08:50 - 9: Complex formula - all employees that joined in the month of March
1:12:21 - 10: Complex scenario - make a department report using many different formulas
1:18:20 - In closing
@@data_with_chandoo thanks 🙏
Anna data entry jobs untya chopu anna
anna i went on interview,today i faced how to remove duplicates in excel using only function
ans: I told Unique function. I used unique function in excel sheet, but i didn't get answer. formula =unique(B2:B340)
May be the data is not clean? There are some spaces or invisible characters or something else that is making unique ineffective?
Female Ratio =C6#&":"&COUNTIFS(staff[Department],B6#,staff[Gender],"Female")
Median Salary =MEDIAN(FILTER(staff[[Department]:[Salary]],(staff[Department]=B6)*(staff[Salary]))) anna idhi correcte na
DID ANY ONE DO 2ND HOME WORKK FEMALE 2020
PLZ WRITE OR CORRECTION MY FUNCTION =FILTER(staff,(staff[Salary]>F67)*(staff[Gender]="female")*(staff[Start Date]>"2020"))
Date(2020,1,1)
let me know what i did mistake
Anna asalu staff table ekkadundi akkada naku total sal avg kuda avvatledu mistake ento teliyatledu cheppu anna pls, mi data ni copy chesi new tab lo paste chesi chesthunte ravatledu y anna
after you have pasted the data in Excel, select any cell in the data and see if you have "table design" or "design" ribbons. If so, you have a table. Go to that ribbon and check the table name in the corner. Change it to "staff".
If you don't have that ribbon, while keeping any one cell selected, press CTRL+T and create the table. Now change the name to "staff"
Done anna thank you for the instant reply ❤
Thank you BRO
Thank you so much sir