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

[@afreenkhatoon1222]

Bahut accha hai sir Mujhe achhe se samjh aa gaya

[@shatrudhanprasad2354]

Sir you are best teacher in the world

[@VijayCompEducation]

So nice of you...

[@TahirGujjarTahirGujjar-g3u]

Sir your best teacher in the world ❤

[@VijayCompEducation]

Thank you so much for your kind words!

[@mr.indiancreator4483]

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

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

Fantastic and useful lecture...❤❤❤

[@VijayCompEducation]

Glad you liked it

[@Lofi_lyrics23]

MAJA a gya video dekha ke acha video he

[@SurekhaKumari-fz5sb]

Thanks sir samagha achhe se🙏🙏🙏

[@MdImran-iq7yi]

Nice sir boht acche se smjhaya

[@rahuldebpal9268]

Thank you Sir very much for this useful video.

[@chotupal235]

Thanku so Mach sir 😎😎

[@TahirGujjarTahirGujjar-g3u]

Video good ❤

[@VijayCompEducation]

Thanks a lot!

[@diljalekumar1672]

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

[@trishaghadigaonkar450]

Thankyou so much sir for this vedio

[@mugdhawaghavekar8386]

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

[@ManasiMurmu-y5b]

Thank you sir for help 😊

[@fakiratadvi5868]

Thank you so much sir very useful video

[@VijayCompEducation]

So nice of you

[@absentmind7056]

Thanku sir may Allah bless you

[@shprajapati4017]

Thank you very much sir itni help krne ke liye

[@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

[@jugalkishor7360]

Thanks you so much sir 🙏

[@asifazam2315]

very useful information work.

[@VijayCompEducation]

Glad you think so!

[@abf_rouf]

Awesome ❤

[@VijayCompEducation]

Thanks 🤗

[@mdshahanawajhussain4016]

Thank you so much sir ❤

[@ah.najeemnooran4075]

Hello sir do we need chart 📊 for this project?

[@VijayCompEducation]

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

[@LoveYou-pm2tt]

Thnq. U so much sir😊

[@sharukzada963]

Thanku bro u explain very well💥🥵🏌️

[@manojahirwar1231]

Bahut NIC

[@krupa67]

Tq sir❤❤❤

[@arjunraja2040]

Thank you 👍👍❤️

[@VijayCompEducation]

You're welcome 😊

[@rajeswarpani9018]

Very good and excellent

[@VijayCompEducation]

Thank you so much 😀

[@SunnyKumar-ee6yu]

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

[@Iphone_storyyyy]

Video start in 1:16

[@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

[@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

[@debasishroy5751]

Bahot a66e vedio

[@anandmaharana7371]

Superb video

[@VijayCompEducation]

Thank you so much 😀

[@pramilayadav7606]

Thank U so much sir

[@VijayCompEducation]

Most welcome

[@ZULQURNAINHAIDER51214]

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

[@sangx23]

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

[@ifatjan9185]

HOW TO MAKE INDIVIDUAL MARKS CARD OF A STUDENT

[@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

[@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

[@rohitchakma4404]

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

[@Barbie_in_pakistan]

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

[@nisargghadshi4166]

Thanku so much sir for the great explain ❤️

[@VijayCompEducation]

Always welcome

[@manojk1912]

Nice

[@sportslover647]

@@VijayCompEducation num pls

[@AmanKumar-ho6tm]

Thanku sir

[@akrajput1501]

Thankyou sir for teching

[@VijayCompEducation]

Always welcome

[@tanmoydey715]

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

[@shatrudhanprasad2354]

You are for me of god

[@babulsingh9364]

When someone is absent then how to use min formula

[@palashde4984]

Excellent

[@VijayCompEducation]

Thank you so much 😀

[@chocolakes452]

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

[@mohammadsaleem1182]

Weldon

[@VijayCompEducation]

Thank you...

[@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?

[@user-uv5ir9sy2g]

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

[@kaushikvishwas9060]

thankyou sir.

[@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

[@omarrashid4181]

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

[@abhilashpatel3602]

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

[@DHRUMIL_1207]

Thanks sir

[@VijayCompEducation]

Welcome

[@BadyalAshu-ww1lg]

Nice

[@Youtubernot01]

Thank you

[@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.

[@princebeniwal2342]

Awesome

[@skwahid7058]

This video usefull for me 👍

[@Nikhil-vx7ci]

Nice video

[@sudhakarooty8288]

Very nice teaching..plz talk with english

[@ANKITKUMAR-nz6cj]

Thik you sir

[@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)

[@kapilsingh9628]

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

[@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.

[@sudiptobose2612]

Bhaijaan Excel main Khali Marksheet banta hai yah kuch or?

[@souviksaha6701]

What is the difference between Excel and Advance Excel?

[@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)

[@onlyatozstudy1908]

Nice sir

[@VijayCompEducation]

Thank You...

[@robertralte683]

Fail student ka rank nahi chahiye to kya karna hai

[@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

[@itishreenaik9265]

Thank you 🙏

[@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.

[@jaydeepraghuvanshi681]

Thanks

[@VijayCompEducation]

Welcome

[@macwanjayeshmanuel9354]

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

[@yashwantraomeshram9315]

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

[@VijayMahato-dh5pe]

Thank you sir ji

[@VijayCompEducation]

Welcome

[@satishjha8980]

Video started1:15

[@fitnessmotivation4443]

Thanks sir ji

[@eceofficeeceoffice]

thanks

[@shortsworld3424]

BEST OF LUCK TOMORROW IS YOUR COMPUTER EXAM😂😂😂👍👍👍

[@kritikaaburmanarora]

Please share formulas

[@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

[@suraiyakhan6384]

aapne batae nahi k4 k liye kya select karna hai

[@amishashah9021]

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

[@itz_arun_kashyap.]

Are Sir mujhko Aata hai Fir fir thaku 🙏

[@subratakundu1004]

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

[@maheshsada1473]

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

[@SK_GAMER7060]

Thanku so mach

[@jyotipaperplay8527]

Result me Jo lines he usko Kya Kahate he

[@jaysinghjay5471]

एवरेज कैसे निकाले

[@Lofi_lyrics23]

bhai mere excel sheet me persantage nahi a rahe he

[@SulagnaRay-ti6mq]

Rank formula & grade formula tike comments karantu

[@amreshaks]

Isme kuch error hai jb student fail ho gya tho usko rank kaise mil gya....

[@lakhan666gaming7]

bilkool sahi 😂😂🤣😂🤣😂😂marksheet ke saste nashe😂🤣🤣😂🤣😂🤣😂

[@ruchisharma05]

Aree 10 students me uski koi na koi position to hogi hi na bhale hi vo fail ho

[@GOPICKOBalram_Kashyap]

@@ruchisharma05 vahi to ye log kon samjega 😂😂😂

[@shubhamsahu4965]

kzbin.info/door/5X7-1hGHnarGU9HgBShAyg

[@shubhamsahu4965]

kzbin.info

[@sonalhathila949]

Grade ko formula Puri show nahi karti plz repeat it.