MS Excel - Student Mark Sheet Calculation Sum, Average, Rank, Grade, Pass Fail, Status

* View Online Course* : vedantaeducationalacademy.com/
---------------------------------------------------------------------------------------------------------------------
• Complete Accounting & Taxation Package (English) INR. 1099/-
• TallyPrime+ERP9+GST+IncomeTax+TDS+TCS+Microsoft Excel Combo Pack
vedantaeducationalacademy.com...
--------------------------------------------------------------------------------------------------------------------------------
• Computer Basics with Microsoft Office (English) INR. 699/-
vedantaeducationalacademy.com...
--------------------------------------------------------------------------------------------------------------------------------
• TallyPrime-TallyERP-GST-IncomeTax-TDS in Telugu (తెలుగులో) INR. 699/-
vedantaeducationalacademy.com...
---------------------------------------------------------------------------------------------------------------------
* Tally Official Digital & Verifiable Certifications*
• vedantaeducationalacademy.com...
* Buy Tally - Accounting Software’s *****************
vedantasoftwaresolutions.com/
-----------------------------------------------------------------------------------------------------------------------------
Download Mobile App : play.google.com/store/apps/de...
Our Contact information
Mail : [e-mail]
Mobile & WhatsApp : [phone]
Tags #excel
#onlinecourse #vedanta #vedantaeducation #ursravitelugu #ewaybill #einvoice #gst #tallyprime #tallyerp #computer #computerskills #msoffice #word #excel #powerpoint #freecourses #onlineeducation #onlineeducation #accountingcourses #incometax #tds #tcs
Visit Our Website : vedantaeducationalacademy.com/
↓↓↓Full Course Links Find Below ↓ - Vedanta Educational Academy ↓↓↓
_________________________________________________
1. Tally.ERP9 with GST Rs. 699/- vedantaeducationalacademy.com...
________________________________________________
2. MS Excel Rs. 499- vedantaeducationalacademy.com...
________________________________________________
3. Tally.ERP9 + GST + MS Excel Rs. 1049 vedantaeducationalacademy.com...
________________________________________________
4. Computer Basics - Rs. 3500 vedantaeducationalacademy.com...
________________________________________________
Full Course Links Udemy
________________________________________________
1. Tally.ERP9 with GST (Learn with Tally Authorized Faculty) - INR. 455 -
www.udemy.com/course/tally-wi...
________________________________________________
2. MS EXCEL - INR 455 -
www.udemy.com/course/master-m...
________________________________________________
3. TALLY.ERP9 + GST + MS EXCEL 9COMBO PACK) INR. 455 -
www.udemy.com/course/tally-er... #OnlineCourses #VedantaEducationalAcademy #Tally.ERP9 #GST #TallyPrime #tallyprime #Vedantu #VedantaEducationApp

[@shukussaim3472]

I was seeking for the fail and pass in one subject problem from within the month.
But now i knew it.
Thank you very much for this video.
Lots of love.

[@evelinalumato9052]

Where did he get 35 in pass or fail

[@moumitagupta8124]

Sir,the total range will be given in the question or we need to assume it as i2 and i11

[@Shukuruwilondja.3520]

I really love the way that you explain.

[@childrenreadingskills6024]

How do I send the answers and scored points (not points allocated to the questions) of my students' marked exam papers? They did not type the email address on the exam Google form.

[@techhack2006]

mai kisi ki bhi video pr comment bahut bahut hi rare hi chance h ki kru but sir You are brilliant Thank you so much Your Teaching Skill is osm🔥🔥I Salute you sir🔥

[@fatiharslanoglu6482]

Thank you very much! My project worked.. Wonderful video!

[@emmanuelkwesi2387]

That's a great tuition. Thanks so much.

[@mrCetus]

Hello sir, it's a helpful video. I'm need one help. What would be the formula to find the total marks for English plus best four subjects. There are total of six subjects. Your help would be highly appreciated. Thank you!

[@elvranjes5824]

More grace ur the best teacher 🙏🏻🙏🏻❤️

[@samardeepsingh82]

Thanks for the video, at 9:01, you mentioned poor, shouldn't you have used if statement for less than 50 too? Just asking for clarification. 🙏

[@shahataj1998]

Very informative thank you for teaching us

[@manojsoni1475]

A failed student is getting higher rank than who passed also status of failed students is good
Still required improvement in formula application

[@ashivashishth9759]

Thanks it's really very helpful I love this video

[@MuhammadUsmanTaj]

Great really fruitfull tutorial

[@mohanraje5035]

Good explanation thanks 👍

[@baaboss5036]

You are the best teacher i forgot the IF function but you remembered me thanks

[@madalaramesh3536]

tq sir I'm using this process
superb clarity

[@ayyappareddymandala5216]

Why did you allocate rank for failures?
Can you calculate ranks in serial order for passed out students without allocating rank for failures?

[@tewodroswerku3657]

It is a very good way of teaching and I understand each and everything thank you so much

[@smilemittal5164]

Sir please tell me that how to sort the list of students based on the final average marks?

[@azbz7]

the best teacher I ever found .you mastered it!!

[@HariniGurudev]

Thank you brother....🎉🎉🎉
Now I can understand very well

[@storeone363]

you are great sir .
it was really very helpful video specially for me

[@alieaiahjawara7136]

Thanks, it's really helpful

[@esmeraldaunged3039]

millions of thanks to you sir for this video.. May God bless you more with knowledge to share..

[@vinothkumar10]

thank u sir i have one doubt in case one student all subject have 35 marks 6*35=210 total another student one subject fail but this students 6-subject total 275 so how to calculate RANK ?? sir pls help me

[@neelamdh2926]

Wonderful.. 🙏 Thank You

[@thallurimoses]

is it possible to turn it into a form/software/app/interactive pdf after creating such excel, where we can enter just the marks and get the results?

[@rajeshakkineni4565]

nice information sir but i have a doubt .. when two students getting same marks then ranks also getting same but coming next rank person getting one rank below.... also i want to given conditions when student getting 400 above ranks on, above350 second rank like that.. how its came

[@DJ_FREESTYLE]

Very very helpful 👍☺️

[@shankargupta4364]

Thank you so much for this video .😊

[@a.peterrobinson7297]

thank you very much sir, it is more useful for me. I am thankful to you sir.

[@paulataufa8160]

Hi, thank you for your excellent video demo, however i wanted to know how can you calculate the to 5 marks only and displayed on your total column?

[@AnilYadav-tt5ox]

W 4th

[@deepaharishchandraprabhu3166]

thank you sir, well explanation

[@vesetoluvese6518]

How easily you explained thank you sir

[@TreasureYakub-yj9xu]

It was really helpful

[@geethav7474]

Really super sir very useful to us

[@bhushankahar1361]

dear sir your video so excelent I was searching this kind of video . now I want how to print as a mark sheet kindly inform me . I am a teacher conducting exam, deportment , so i want to do all data works easily.

[@user-vj6xe9gy3z]

Thank you so much sir

[@angelsworld8677]

Thank you 🎉

[@smshah6783]

The video is very excellent. I like to much

[@muhammadusamboaliyu5815]

Thanks very much. please how can I know my total marks range if I'm using different value

[@Short_Films709]

Thank you so much for this sir.

[@addissolomon2343]

thank you so much!!!

[@b2empiretv217]

You are the best,so simple and well detailed❤❤❤

[@akshaydarbar10]

Sir ,i hav a markshhet in this i want that students absent in all subject ..results colums shows absent instead of fail . How to write formula fr this
Becasue in result colum i hav given a condition that if a students pass in all subjects ,shows pass ,or fail then how to add absent condition for this .

[@macdonaldmendorinusnarib7892]

hi can you calculate how many students passed using sumif function, thank yu

[@miriraipetermatete7462]

This is just awesome. I was having problems with my ICT tasks

[@ramngaihzuala3212]

I have a question?.... Suppose a student who failed in one subject but score more in total mark then a student who score less in total mark but pass in all the subject... So, the question is how to make a rank on this kind of situation?

[@Alkhalil180]

This Rand formula did not work if there comes duplicate value. for example if two student gets the same number

[@yelatong8911]

Thank you so much sir it is so helpful

[@changadawa9482]

nice sir now my ict work is done

[@maitriroy5626]

reallly goood teachinggg 💖💖💖💖💖💖💖💖

[@rheajobin06]

Thank you sir!!

[@Rahul-oz7kb]

Thank you so much brother

[@hojiihojjetaa1945]

Thank youuuu!

[@mdmazharulislam5111]

Thanks for video.

[@RajSinha]

You're superb!

[@zer022pg]

Thank-you the video is very helful

[@sandileshezi1436]

Last words knocked me out "So this is how simple it is, thank you" 🤣

[@rajeshakkineni5127]

Simply superb

[@kevinogutu6553]

I wanted a case where there are values and grades how do you calculate total points

[@junaidjunaid7999]

Thank you 🙌

[@coolbabysv]

Thanks for the video. If some student is failed, he should not be given ranking, also factor for absence. Then we have to calculate ranking. Is it possible

[@debjanirai1235]

Thank you

[@sajidapatel6082]

It was eassy explanation one query if I want to count how many students are fail in each subject than filter to be used count method

[@epicurean9866]

What if two columns will be interpreted. please help me
Ex. c2 is frustration and e1 is instructional- the interpretation is frustration
if c3 is instructional and e3 is independent- the interpretation is instructional
if c4 is independent and e4 is independent- the interpretation is independent
I have two cells to be interpreted please help me out to generate automatically

[@subhasishmallick6183]

Thanks

[@michaelobiero519]

Nice and clear

[@ShubhamSharma-ss9xk]

If i want the name of student which is having rank 1 in a different cell, how can i get that??

[@anupomkumar2123]

Suppose 3 students get the same number in total, to make the position with the help of prior class Roll,Then what is conditions to make this result Sheet?

[@poornimarao6288]

If i want to find how many have passed or failed in a vertical way, how to find out

[@subrotamondal6012]

Thanks a Lot Sir

[@rubul6253]

Thanks bro

[@AMITJAIN-vo7tm]

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

[@apex_soul7116]

Thanks bro ❤️

[@dharmeshbaba9124]

Thank you sir you the best teacher

[@kiranbarru1918]

Sir Nice video, can we give ranks with using if formula, please give reply.

[@laxmikhatri3285]

Thank u so much ❤😊

[@katushaberacheal5345]

Best teacher

[@komalarya9179]

Thankyou bro

[@shaguftakulsoomteacher4554]

THANK YOU SO MUCH

[@aaranypalaninathan3267]

Thanks sir 👍🙏

[@smshah9400]

Excellent video😀😊😀😀😀😃😋

[@dicxontirkey3400]

Perfect Sir

[@srinivasatk3907]

Hi Sir,
If a student failed also you have given the status as good you have to include this condition as well both should be satisfied.

[@sathishkumar0642]

Nice work

[@iddiali4102]

can i ge step by step method for creating a report system

[@sairabanu2984]

Sir,while putting rank,we are getting rank for absentees also
How to rectify this

[@notveryc00l]

how u rename the a b c things

[@parvin.shaikh.]

Thank you sir for the explanation 🙏 👍 I understood how to do....thank you

[@hariprasad361]

excellent explanation thank you for your valuable time for us....!

[@aparadas2927]

Thank you so much

[@PankajMishra-xg9vf]

Sir, If I want to display the students name based on specified range of marks, how should I do that in excel. Kindly, help me regarding this..🙏

[@aliyukabir9011]

You shall right click between the row that you want put the student's name and click on insert, the option will appear that let you to find a space

[@Siva-rm6ts]

nice bro thanks

[@fauziffyt1503]

Thankyou sir

[@compassio2063]

TNANKS A TON

[@muradshaikh7422]

Firstly I want to give rank of the students who have passed then fail.
What is the formula?

[@level2456]

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

[@bipinemansing]

Thank you so much sir 🙏🙏🙏🙏🤩🤩🤩🤩.