How to create Mark sheet in MS Excel Step by Step in Hindi | Report Card in MS Excel

How to create Mark sheet in MS Excel Step by Step in Hindi | Report Card in MS Excel
Iss video me main aapko batanuga ki MS Excel me marksheet kaise banaye aasan tarike se | How to create marksheet in excel in hindi step by step
Video acchi lage to like , share or comment jarur kariye aur mere channel ko subscribe karna na bhule or bell icon ko v daba de.
Like, share and Support my channel.
Aap mujhe follow v kr skte hain :
Twitter : @CompVijay
Instagram : vijaycompeducation
Facebook : vijaycompeducation
-~-~~-~~~-~~-~
Please watch: "Create an Interactive Checklist in Excel || How to Add Check Box In MS Excel || Vijay CompEducation"
• Create an Interactive ...
~-~~-~~~-~~-~

[@shatrudhanprasad2354]

Sir you are best teacher in the world

[@VijayCompEducation]

So nice of you...

[@diljalekumar1672]

Thank you sir ye video bahut achha laga aur samjh me bhi aa gya

[@mugdhawaghavekar8386]

Very informative & an easy method you described this formulas. Thanks 😊

[@afreenkhatoon1222]

Bahut accha hai sir
Mujhe achhe se samjh aa gaya

[@mr.indiancreator4483]

Thank you Sir, after watching your video i got a better idea about Excel

[@rahuldebpal9268]

Thank you Sir very much for this useful video.

[@MdImran-iq7yi]

Nice sir boht acche se smjhaya

[@shprajapati4017]

Thank you very much sir itni help krne ke liye

[@Lofi_lyrics23]

MAJA a gya video dekha ke acha video he

[@SurekhaKumari-fz5sb]

Thanks sir samagha achhe se🙏🙏🙏

[@chotupal235]

Thanku so Mach sir 😎😎

[@trishaghadigaonkar450]

Thankyou so much sir for this vedio

[@manojahirwar1231]

Bahut NIC

[@jugalkishor7360]

Thanks you so much sir 🙏

[@1000.subscribars]

Thanks sir ji 🙏🙏🙏

[@shah-Nawaz-Ali-Bhutto-3995]

Fantastic and useful lecture...❤❤❤

[@VijayCompEducation]

Glad you liked it

[@LoveYou-pm2tt]

Thnq. U so much sir😊

[@fitnessmotivation4443]

Thanks sir ji

[@asifazam2315]

very useful information work.

[@VijayCompEducation]

Glad you think so!

[@fakiratadvi5868]

Thank you so much sir very useful video

[@VijayCompEducation]

So nice of you

[@absentmind7056]

Thanku sir may Allah bless you

[@mdshahanawajhussain4016]

Thank you so much sir ❤

[@itishreenaik9265]

Thank you 🙏

[@parwizahmadi4823]

Thank you Vijay Sir it really help me to calculate my marks and you explained very good through your examples.🙂🙂🙂🙂🙂

[@VijayCompEducation]

You are most welcome

[@akrajput1501]

Thankyou sir for teching

[@VijayCompEducation]

Always welcome

[@debasishroy5751]

Bahot a66e vedio

[@mohit_gaming_388]

Thmku so much sr

[@kaushikvishwas9060]

thankyou sir.

[@unromanticabf]

Awesome ❤

[@VijayCompEducation]

Thanks 🤗

[@AmanKumar-ho6tm]

Thanku sir

[@arjunraja2040]

Thank you 👍👍❤️

[@VijayCompEducation]

You're welcome 😊

[@princebeniwal2342]

Awesome

[@Ronak_hacker2011]

Sir iss vedio se maine practical mein top kar dala 40 out of 37 thank you so much ❤🎉

[@VijayCompEducation]

Grt...nice to hear that..btw 37 out of 40 hoga...

[@rajeswarpani9018]

Very good and excellent

[@VijayCompEducation]

Thank you so much 😀

[@SK_GAMER7060]

Thanku so mach

[@pramilayadav7606]

Thank U so much sir

[@VijayCompEducation]

Most welcome

[@ferozasattar9949]

thanks bhai

[@shatrudhanprasad2354]

You are for me of god

[@hargurveer1145]

Thanks you sir 😊

[@VijayCompEducation]

Most welcome

[@golitaluk6766]

Thanks 👍

[@VijayCompEducation]

Welcome 👍

[@anandmaharana7371]

Superb video

[@VijayCompEducation]

Thank you so much 😀

[@ReflexGodop]

Thank you

[@krupa67]

Tq sir❤❤❤

[@sharukzada963]

Thanku bro u explain very well💥🥵🏌️

[@pratikdas5005]

I tried to use rank formula but due to some problem it didn't workout. I had put everything in order but when tried to lock it won't work. So please help me.. but I liked your teaching style of way to explain in a very simple way. Thank you

[@ifatjan9185]

USE SHIFT 4

[@dharmeshbaba9124]

=rank(select 1st column of average $ alfabet of column $ number of 1st average column : $ alfabet of average column $ number of last average column) enter then double click on corner of your single result you will get all grade

[@Nikhil-vx7ci]

Nice video

[@skwahid7058]

This video usefull for me 👍

[@palashde4984]

Excellent

[@VijayCompEducation]

Thank you so much 😀

[@balajikiladliskr1665]

Thank you sir

[@VijayCompEducation]

Most Welcome...

[@kalutdai9723]

Thanks

[@onlyatozstudy1908]

Nice sir

[@VijayCompEducation]

Thank You...

[@mohammadsaleem1182]

Weldon

[@VijayCompEducation]

Thank you...

[@sudhakarooty8288]

Very nice teaching..plz talk with english

[@tanmoydey715]

Sirr please tell me the short kat formula that you used , i could not understand it right now please sir 🙏🙏

[@SunnyKumar-ee6yu]

Very.much.❤❤❤❤❤❤❤🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉

[@ANKITKUMAR-nz6cj]

Thik you sir

[@shushrutrandive3695]

Beginer Excel kaise and kahe sikhe sir isper sir app detail me video banye sir point to point hum le request ek ek point ansur sir

[@babulsingh9364]

When someone is absent then how to use min formula

[@amishashah9021]

but students who failed don't get a rank, u should have added a condition while calculating ranks

[@BadyalAshu-ww1lg]

Nice

[@kedarpatel2509]

Sir ji m.p. state ki p s/m s school ki mark sheet kaise banayege sir ye bataye ki . monthly and subject ak sath kaise mark sheet banayege pls sir help me

[@subratakundu1004]

how can i convert this data sheet into the individual marksheets for each student? please say.

[@sangx23]

Obtain mark total aaney meh konsa key use Kiya pls reply ?

[@omarrashid4181]

Sir, can you write rank as 1st, 2nd, 3rd, 4th.................................?

[@AMITJAIN-vo7tm]

How to use if function when any student is absent in all exam or particular subject.

[@meowff3027]

At that time we use Vlookup formula

[@level2456]

Thanks for the video. How do we compile a list showing only students that failed? Separating it from those who passed

[@ifatjan9185]

HOW TO MAKE INDIVIDUAL MARKS CARD OF A STUDENT

[@souviksaha6701]

What is the difference between Excel and Advance Excel?

[@edurchana]

Sir exact question toh bata nahi paungi lekin it was somewhat like "in a week which book gets issued most or how many number of times" I am not understanding how to do this?

[@nisargghadshi4166]

Thanku so much sir for the great explain ❤️

[@VijayCompEducation]

Always welcome

[@manojk1912]

Nice

[@sportslover647]

@@VijayCompEducation num pls

[@andrewpradhan2571]

English F.M 100/PM 40, Hindi F.M 100/ PM 40, Math FM 100/ PM 40, Moral Science FM 50, PM 20 and GK FM50 /PM 20. How can we make report card in this condition. Please make video and post. FM means Full Marks and PM means Pass Marks.

[@mnonazmulislam298]

I want to create a result sheet with the help of Excel.
I wish that if a student fails in 1 subject then his result will not fail but will come in D Great or 3rd class.
And if he fails in 2 subjects then fail will come.
I am seeking Sir's help in this matter.

[@VijayCompEducation]

Video uploaded regarding the same. Kindly watch that video : ruclips.net/video/cI0V9QyauQM/видео.html

[@Barbie_in_pakistan]

min marks 2 subjects k liye different or 6 k loiye different..inko kesy pass or faill krengy?

[@ah.najeemnooran4075]

Hello sir do we need chart 📊 for this project?

[@VijayCompEducation]

No need...if u want u can use chart...

[@rohitchakma4404]

What is the formula for removing of rank and division for 1 Subject fail

[@rasikravaleworld3050]

sir,
fail student can not get rank. Only pass student get rank. what is the exact formula for this.so please make a video that show this.

[@user-uv5ir9sy2g]

if we want to make grades as "F" for failed what to do

[@zulqurnainhaider1335]

BAHII execuse me ap muja bata sakhtay hain ki ap na average nikala tha too ap na bracet bnd kasay kiya

[@satishjha8980]

Video started1:15

[@samirk.chaudhari5946]

(1) Fail ko Rank nahi milta bhai.
(2) jo Desable Student hote he vo 20 mark se pass ho jate he. Baki normal student 33 se pass.

[@abhilashpatel3602]

Hello sir
Jo sutends fill ha usko number nahi dana ho to koi formula ha

[@chocolakes452]

Sir isme aapne F4 se lock kiya hai . Uska kya procedure hai. Kaise pata calega kaun se value lock karni hai.

[@Vinaykumar-yh4pl]

good morning sir please mujhe grade rank percentage result avreage ka formula type krk de do mujhe formule m bhot hi problome ho rahi h

[@VijayCompEducation]

ये सभी सूत्र मेरी वीडियो तालिका से संबंधित हैं।
grade : =if(k4>=90,"A+",if(k4>=80,"A",if(k4>=70,"B",if(k4>=60,"C","D"))))
rank : =rank(k4,$k$4:$k$13,0) - Maine Average liye hai rank nikalne k liye. Agar aap chahe to Percentage ya fir Obtain marks v le skte hain. Bas aapko cell value change krna hoga.
percentage : = Obtain Marks / Total Marks (maine cell ko percentage me change kr k rakha hai, nhi to aap % ka formula lga skta hai. )
result : =if(min(range)>=35,"Pass","Fail")
average : =average(range)

[@banjareroshani3326]

Ek error h Esme sir jo students fail huye h unka rank kaise aa gya
Or jo students supply honge unka bhi ek record hona chahiye
Fail or pass ke alawa

[@yashwantraomeshram9315]

Agar koi bachcha 1 subject me fail ho gaya to uska result pass hoga ya fail ise kaise karenge

[@govindmangrole5579]

How to find subject wise compartment?

[@shaundsouza-nx4cl]

Sir what u said to lock in rank which key to use F4 or shift 4 cant understand that pls do clear that sirji

[@VijayCompEducation]

For lock press f4

[@shaundsouza-nx4cl]

@@VijayCompEducation thank u sirji

[@ghanshyamdeep303]

Student supplementary aay to kya function lagana hai? Solve pls

[@VijayCompEducation]

Ghanshyam ji, supplementary k liye maine ek video bana diya hai. Aap jarur use dekhe. Asha krta hu ki aapka jo sawal tha wo solve ho jaega

[@anoparam3274]

Hello , sir isme jo student fail hai unki bhi class me rank lag rahi hai

[@kaushikvishwas9060]

SIR....I COUDEN'T UNDERSTAND THAT WHY DID YOU USE KEY F4 TO LOCK EVEN I DID USE IT WIHTOUT KEY F4 AND I HED GOTEN SAME RESULT. OH! YES TELL ME WHAT IS THE MATTER OF ZERO IN LAST BEFOR BRACKET =RANK(K4,K4:K13,0)

[@kapilsingh9628]

Sir grage ka samaj nahi aa rha hai or jyada laba process hai sir grade shoutcut me btao

[@itz_arun_kashyap.]

Are Sir mujhko Aata hai Fir fir thaku 🙏

[@maheshsada1473]

Ok you find rank so good but rank number is not asending oder

[@kritikaaburmanarora]

Please share formulas

[@suraiyakhan6384]

aapne batae nahi k4 k liye kya select karna hai

[@kairon676]

Sir Pls iss sheet ka link send kr do ji

[@macwanjayeshmanuel9354]

Sir fail hai unko bhi rank diya unko rank nahi dena hai to kya karne ka

[@sagarikadas4290]

Wby green colour triange

[@robertralte683]

Fail student ka rank nahi chahiye to kya karna hai

[@sudiptobose2612]

Bhaijaan Excel main Khali Marksheet banta hai yah kuch or?

[@shatrudhanprasad2354]

Sir