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👍👍
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.
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🤗🤗🤗🤗🤗
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
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)))
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
అన్న 2012లో mba చేసా మధ్యలో చాలా జాబ్స్(teaching +It job)చేసా ఇప్పుడు data analyst గా జాబ్ చేయాలనీ ఉండి skills నేర్చుకున్న but no జాబ్స్. Without DA exp నాకు జాబ్ వస్తుందా?
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
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)
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
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
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"
అన్నా నువ్వు మా పాలిట దేవుడు అన్న నిజంగా నువ్వే లేకపోతే ఈరోజు మేము ఈ స్థాయిలో ఉండేవాళ్ళం కాదన్నా థాంక్స్ చెందన్న
Yes u r right
I really appreciate you taking the time to teach Excel formulas. It's a game-changer
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🙏🏻🙏🏻
నమస్తే చందూ అన్న, power BI ఫుల్ కోర్స్ తెలుగులో
Thank you sir, Very useful Class
Annayya chala manchi video chesaru. Edarilo unnavallaki oasis lantidi ee video. Thank you.
Thankyou so much sir🙏🙏
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.
Namaste Anna wonderful explanation thankyou ❤
out fit bagundi sir chalaaa
very useful class sir
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
it will give female ratio in each DEPARTMENT
=COUNTIFS(staff[Department], B6, staff[Gender], "Female") / COUNTIF(staff[Department], B6)
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🤗🤗🤗🤗🤗
Anna Thank you soo much for your efforts
I'm new subscriber to you anna ur explaining very well ❤❤
Thanks for all your videos anna
Complete MS Outlook mida video cheyandi please
Great Man
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
Chandoo sir please start Data Analytics free course in telugu also please sir
Sir Suprise answers please
Thanks chandoo
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 Analysis project Yala Chayalo chapthara sir
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
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
sir home work file kuda ivvandi sir nen try chesina kani rale so that nen refer cheyyaniki check cheyyaniki option lekunde naku ami
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, Permanant count is 168, I have used "Countifs" function. is this correct.
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
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
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
అన్న 2012లో mba చేసా మధ్యలో చాలా జాబ్స్(teaching +It job)చేసా ఇప్పుడు data analyst గా జాబ్ చేయాలనీ ఉండి skills నేర్చుకున్న but no జాబ్స్. Without DA exp నాకు జాబ్ వస్తుందా?
hello Sir,in my Excel i do not find chossecols , is there any alternative for that ??
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
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?
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 🙏
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
Anna data entry jobs untya chopu anna
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
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 ❤