Thank you for providing questions related to the syllabus. It builds a confidence in us to be prepared for what's coming without getting a panic attack on the day of exam after looking at the questions. Thanks for all your effort. Keep teaching us. 🌸
For finding average after selecting the pivot table just go to option tab click 'summarize values by' thn click average ...No need to find again using formula ... Thanx ,useful video..
Pivot tables is not for using formula.. everything can be calculated from pivot table average count sum max min product standard deviations etc..you just have to click on the value icon from pivot table fields then click on "value field setting" then choose from the window whatever you want to calculate
Population Number calculate koribole "Gender" tu Row t assign koribo,, aaru "ID" ba "City" ba "Education" kunuba etak Values t assign kori dibo. Total Male and Female Population Number pai jabo. Pasot "Count of ...." Heading tu rename kori "Population" kori dibo.
Ayi questions ki formula apply kori koriboloi kowa nai just answer uliyaboloi koise so ji type apply korile khonkale solve koribo pariba khei mote koriba .
How to find the answer to the second question without using formula? Can anyone suggest a good video frm where I can get all the pivot table concept solved?
Pivot table se hi karna he ...ussne formula laga diya ye galat he pivot table me bhi average hota he just click on the sum of value arrow icon an window will open where you can select average instead of sum
Aapuni telegram t aase niki? Thakile muk poke koribosun. Question tu moiu korisu olop belegke. Aaru beleg question u aase mur logot. If you have no problem then kindly ping me.
Confusion dada..- jd Qstn paper ot ase je-- "He is very good and kind" but jd ami type korute "He is very good and Kind" ankua hoi jai due to cell space then kiba prblm hbo ne word to word same hbo lge
Dada moi ktha ata buji puwa nai এতিয়াও.....!!! Kuntu kot ভৰাব লাগিব knke janim??? Suppose ',,Department tu kuntu box t // Qty tu kun tu box t etc,,,plx bujai dbo sn
Thank you for providing questions related to the syllabus. It builds a confidence in us to be prepared for what's coming without getting a panic attack on the day of exam after looking at the questions. Thanks for all your effort. Keep teaching us. 🌸
For finding average after selecting the pivot table just go to option tab click 'summarize values by' thn click average ...No need to find again using formula ...
Thanx ,useful video..
Thank you
Bro you are amazing
Pivot tables is not for using formula.. everything can be calculated from pivot table average count sum max min product standard deviations etc..you just have to click on the value icon from pivot table fields then click on "value field setting" then choose from the window whatever you want to calculate
🤓👍
Thank you
Thanks
Where can I find value icon?
No of population formula
Countif(select gender column, "M") + enter. Thank me
Thanks bro
Q. No. 3) Gender tu row labels ot and
Customer ID tu Values ot dile hoy naki check koribo Sir🙏
Okey
drag the Gender option to sum values in pivot and then change the field settings to count
Yes
To find no of male and female using formula use countif(range,"M"); countif(range,"F")
Take Gender in Row Labels and customer ID in values
superb
Population Number calculate koribole "Gender" tu Row t assign koribo,, aaru "ID" ba "City" ba "Education" kunuba etak Values t assign kori dibo. Total Male and Female Population Number pai jabo. Pasot "Count of ...." Heading tu rename kori "Population" kori dibo.
Rename keneke korim
@@nazmaahmed2518 "Count of.... "t Right Click kori 'Value Field Setting't jabo. Taat " Custom Name"t rename kori ok kori dibo.
@@john-doe-in ok
eitu jodi pivot table use koribole die tetiahe koribo lagibo no?
jodi function use koribole diye? tetia?
Ayi questions ki formula apply kori koriboloi kowa nai just answer uliyaboloi koise so ji type apply korile khonkale solve koribo pariba khei mote koriba .
A bhai misa misi iman long korisa tumi
= countif formula use kri male ru female r number uliyab pari
Power point r question tu solve Kori dekhabo
Please can you make a video on references that comes under MS WORD
Link t thoka Question paper khon clear howa nai
Population Uliabloi
Data khini select kori pivot table t goi Gender2 Row levet and Coustom Id Values t rakhi dile hol
Seattle/ Delhi
Male female or babe count if use koribo pari
Okey
Sir question 2ta apunk dibo asil jdi help kre kindly kot potham jonabo
Assam govt r skill test t windows r kuntu version use kore?? Aru MS office r kuntu version use kore???
=countif(gender column,"F")
=countif(gender column,"M")
right....ankuai korilei ulai jai
Brother Pivot table t formula use korar dorkar nohoi....just Jikunu cellt right click kori summarised data by t select koribo pari
Pivot t Annual Purchase aru Education loi, tate average ulai besi bhal hol hoi
Question tu pivot table di krbo dia nsile.... prile formula used kri ako ebar kri dbo
How to find the answer to the second question without using formula? Can anyone suggest a good video frm where I can get all the pivot table concept solved?
countif hbo male ru female ulabole
Print preview colour kio naahe?? Please reply 🥺
Gom napau kio oha nai version purona hoise neki ms office r
@@acharjyagk8463 2007 version hoy
Drive t pic to clear howa kindly, kindly aru abar bhaldore dibo nki
Bhaiyya, Peek and type method se kartahumein.
.is it ok?
Average Tu pivot table use kori korile hobo ne dada, plz jonabo
Pivot table se hi karna he ...ussne formula laga diya ye galat he pivot table me bhi average hota he just click on the sum of value arrow icon an window will open where you can select average instead of sum
chart ahib janu ? Syllabus t ni baru..male 6jon, female 4..pie chart sun uluta hol..40%:male, 60% female.,buja ni eitu..bujabosun kindly
Female 6 male 4
Dada aiya question paper r pdf ase nki. Bht question aklge thaka. Jd ase dioksun please
Next video t gotei questions paper di dim
Male female count koribole customer ID tu values t select korilei ahi jabo
Sir, excel r cell t kot F4 press kri freez kribo lgr kot nalage ami kenek janim ? Plz jonabsn
Mane Hlookup, Vlookup formula apply karote gotei table jetiya select koriba hei khomoyat F4 press koribo lagibo
@@acharjyagk8463 mane sobote nalage excel r. Only V/H lookup t he lge .right ?
Hoi
Brother, question tu kun exam ot oha? Assam Government Exam or na private please Jonaba 🙏🙏🙏
Enekoa questionst kiman no. thake nu bro
Please reply
Upload kora Q r marksheet r uproot ata video diok na
Class, status t olp confusion hy ASA
Total annual purchase mur yaat value 0 show korise ... Kio? Dollar symbol tu krne values tu sum hua nai. Please help
Aapuni telegram t aase niki? Thakile muk poke koribosun. Question tu moiu korisu olop belegke. Aaru beleg question u aase mur logot. If you have no problem then kindly ping me.
Mailt send kora buddygaming1999@gmail.com
Catagory 2 grade 3 interview hobe ne na hobo
Confusion dada..-
jd Qstn paper ot ase je--
"He is very good and kind"
but jd ami type korute
"He is very
good and
Kind"
ankua hoi jai due to cell space then kiba prblm hbo ne word to word same hbo lge
Row level t gender aru values t Custer I'd add koria la hyjabo
If,and,or,sumif,countif etc. bur korai diok nij example ata di
Okey
Ayitu video sowa - ruclips.net/video/A9Onb_2qwL8/видео.html
@@acharjyagk8463 apunar sob video sai aso...apuni 21r agot complete korai diok...ai2 a request
First of all quality tu vl korok n proyujon hapekhye zoom kri dekhabo.apunihe bujise aru okol ki hikyse
video quality high kori suwa dekhi pai jba
Countif
Use countif to find number of F and M
When will admit Card Come?
Ami bhaale asu 😊
Dada moi ktha ata buji puwa nai এতিয়াও.....!!! Kuntu kot ভৰাব লাগিব knke janim???
Suppose ',,Department tu kuntu box t // Qty tu kun tu box t etc,,,plx bujai dbo sn
pivot koribo dea nai tu question t , aapuni dekhun pivot korise
Count
Ppt print kora ata video dibo
Gender or countif hobo formula countif(B3:B12,"male")
Countif(B3:B12,"female")
Okey bro
Customer ID di uliyale hbone baru
@@parthaboruah1136 moio teneke krisu Formula use kra ni
Delhi tu questions tut nai sun
Hoi city beleg asil kintu moi hei city Buji napalu so Delhi likhi dilu
@@acharjyagk8463 Seattle buli ase kintu Seattle buli dile bar chart khon quation paper nisinake bonabole nwari mne line tu reply dibasun
Hol hol prilu
Tan ase.. time consuming question
Sir , i have a question which I was unable to do, can you send me your mail id ?
buddygaming1999@gmail.com send kora
Sir eta question asy solve koribo para nai kindly apunar email diok moi send kori dim
buddygaming1999@gmail.com
Sir send korisu kindly check koriba
Mail t name ki ase apunar bisari puwa nai akou abar send koribo sun