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

For all online courses visit vedantacourses...
For offline/live online visit vedantaeducati...
For Tally Official Certifications visit vedantaeducati...
#VedantaCourses #VedantaCourses.com #VedantaEducationalAcademy #ursravitelugu #Tally #TallyPrime #TallyCertifications #TallySolutions #TallyEducation * View Online Course* : vedantaeducati...
---------------------------------------------------------------------------------------------------------------------
• Complete Accounting & Taxation Package (English) INR. 1099/-
• TallyPrime+ERP9+GST+IncomeTax+TDS+TCS+Microsoft Excel Combo Pack
vedantaeducati......
--------------------------------------------------------------------------------------------------------------------------------
• Computer Basics with Microsoft Office (English) INR. 699/-
vedantaeducati......
--------------------------------------------------------------------------------------------------------------------------------
• TallyPrime-TallyERP-GST-IncomeTax-TDS in Telugu (తెలుగులో) INR. 699/-
vedantaeducati......
---------------------------------------------------------------------------------------------------------------------
* Tally Official Digital & Verifiable Certifications*
• vedantaeducati......
* Buy Tally - Accounting Software’s *****************
vedantasoftwar...
-----------------------------------------------------------------------------------------------------------------------------
Download Mobile App : play.google.co....
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 : vedantaeducati...
↓↓↓Full Course Links Find Below ↓ - Vedanta Educational Academy ↓↓↓
_________________________________________________
1. Tally.ERP9 with GST Rs. 699/- vedantaeducati...
________________________________________________
2. MS Excel Rs. 499- vedantaeducati...
________________________________________________
3. Tally.ERP9 + GST + MS Excel Rs. 1049 vedantaeducati...
________________________________________________
4. Computer Basics - Rs. 3500 vedantaeducati...
________________________________________________
Full Course Links Udemy
________________________________________________
1. Tally.ERP9 with GST (Learn with Tally Authorized Faculty) - INR. 455 -
www.udemy.com/...
________________________________________________
2. MS EXCEL - INR 455 -
www.udemy.com/...
________________________________________________
3. TALLY.ERP9 + GST + MS EXCEL 9COMBO PACK) INR. 455 -
www.udemy.com/... #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

[@manojsoni1475]

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

[@Sanjeevianalysis]

TELL ME THAT FORMULA SIR

[@Samuelhauhulh3217]

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?

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

[@tewodroswerku3657]

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

[@nadeekagunasekara7047]

It is really easy to understand thanks alot

[@madalaramesh3536]

tq sir I'm using this process superb clarity

[@esmeraldaunged3039]

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

[@smshah6783]

The video is very excellent. I like to much

[@S.Wilondja]

I really love the way that you explain.

[@TreasureYakub-yj9xu]

It was really helpful

[@changadawa9482]

nice sir now my ict work is done

[@vesetoluvese6518]

How easily you explained thank you sir

[@abhimodel806]

Tq... Super explanation

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

[@Burka_Tech6330]

amazing tutor. Thank you very much.

[@zer022pg]

Thank-you the video is very helful

[@smshah9400]

Excellent video😀😊😀😀😀😃😋

[@storeone363]

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

[@techtricksgh]

It very educative, thanks for sharing

[@mishal0303]

HOW TO FORMULATE FOR DIFFERENT TOTAL MARKS IN ON E EXCEL PRIMARY CLASSES TOTAL MAKS IS 400 AND SECONDARY CLASSES TOTAL MARKS 600 ALL CALCULATION IN ONE EXCEL RSULT RANK GRADE ETC IN OFFICE 2010

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

[@ayyappareddymandala5216]

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

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

[@geethav7474]

Really super sir very useful to us

[@maitriroy5626]

reallly goood teachinggg 💖💖💖💖💖💖💖💖

[@fatiharslanoglu6482]

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

[@kaeez]

How quickly Mr. Ram went from being class topper to fail 😅

[@bipinemansing]

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

[@elvranjes5824]

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

[@fauziffyt1503]

Thankyou sir

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

[@alieaiahjawara7136]

Thanks, it's really helpful

[@habibriaz5651]

Thank You Sir

[@HariniGurudev]

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

[@deepaharishchandraprabhu3166]

thank you sir, well explanation

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

[@mdmazharulislam5111]

Thanks for video.

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

[@ASHRAFTANVIR]

thank you

[@muhammadusamboaliyu5815]

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

[@yelatong8911]

Thank you so much sir it is so helpful

[@a.peterrobinson7297]

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

[@Short_Films709]

Thank you so much for this sir.

[@aparadas2927]

Thank you so much

[@dharmeshbaba9124]

Thank you sir you the best teacher

[@AakibAli]

Create an Excel file to summarise the students data to find the total no of boys ,girls,passed and failed students ,distinction holders, first class,second class and third class students

[@neelamdh2926]

Wonderful.. 🙏 Thank You

[@hariprasad361]

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

[@poornimarao6288]

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

[@junaidjunaid7999]

Thank you 🙌

[@katushaberacheal5345]

Best teacher

[@akshitachauhan6999]

Plz kya aap hme ye bhi bta sakte hai ki iski percentage aur division kaise nikalte hai

[@rajeshakkineni5127]

Simply superb

[@sharmakhushi6594]

Sir hume agar sirf itna nikalna ho ki calculate the number of students failing in each subjects. Then konsa function use karenge?

[@hamsaaparajitha970]

Very nice sir

[@v2sirchemistry645]

Sir jo students fail he uska percentage nahi chahiye marksheet me to uske liye kya formula banegi

[@rajeshakkineni4565]

i think we should given false value is null or empty then its not came

[@michaelobiero519]

Nice and clear

[@AMITJAIN-vo7tm]

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

[@DJ_FREESTYLE]

Very very helpful 👍☺️

[@shahataj1998]

Very informative thank you for teaching us

[@kevinogutu6553]

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

[@ParvatiTallvar]

Thanks sir 🙏

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

[@sairabanu2984]

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

[@ashivashishth9759]

Thanks it's really very helpful I love this video

[@sathishkumar0642]

Nice work

[@miriraipetermatete7462]

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

[@muradshaikh7422]

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

[@Alkhalil180]

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

[@geneticscientistkohinoordi1539]

THANKS A LOT SIR

[@dineshdineshdhosthu1423]

Tq sir Excel Excellent sir

[@Rahul-oz7kb]

Thank you so much brother

[@virendersingh1234]

If the logical test for all the subjects are same. ..can we give them a single formula showing that if sub 1 to sub 6 less then 35 is fail

[@macdonaldmendorinusnarib7892]

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

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

[@Siva-rm6ts]

nice bro thanks

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

[@dicxontirkey3400]

Perfect Sir

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

[@shaguftakulsoomteacher4554]

THANK YOU SO MUCH

[@b2empiretv217]

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

[@Areejxblr]

My exam is literally in 1h , tysmmmmmmm

[@ShubhamSharma-ss9xk]

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

[@moumitagupta8124]

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

[@sudharaja1829]

Thank you very much

[@iddiali4102]

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

[@amroaizawl474]

After one year i knew how to indicate the division of rank...but how can i put Distinction, First, Second, Third... i used this formula but i cannot added THIRD divicion..anyway thank you

[@azbz7]

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

[@smilemittal5164]

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

[@compassio2063]

TNANKS A TON

[@Fousia22]

Well explained very useful thank you

[@zahid4370]

EXCELLENT

[@emmanuelkwesi2387]

That's a great tuition. Thanks so much.

[@baaboss5036]

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

[@hojiihojjetaa1945]

Thank youuuu!

[@ashishparakh8380]

Need a formula I have 2 tabs. In Tab A I have 2 Columns, Column A is named as Students, Column B is named as Pass or Fail. In Tab B I want to see only Passed Students. Help me with some Formula

[@elvranjes5824]

I really di understand

[@MuhammadUsmanTaj]

Great really fruitfull tutorial

[@prakashchandrabarik4651]

Sir Thanks 😊😊 Thanks Thankyou soooooooooo oo much My daout is clear 🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰