Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How much time needed for 100 students report in Excel, displaying color bars for different Marks,Ranks,Overall result with in it's cell?

user-image
Question ajoutée par Syed Hussaini , Senior Design engineer , private
Date de publication: 2014/03/12
Mohammed Younus Pasha
par Mohammed Younus Pasha , Assistant HR Manager , Drops

That may include2 tings and may take an hour or two

1) data enrtry:- enter all the data pertainig to the students, Name, Subjet, Total Marks, Passing marks & actual marks obtained.

2) Data processing :- Which includes few IF Commands (giving you the actual results like pass, fail percentage etc) and conditional formatings.

It defers from peson to person

Abdul saleem
par Abdul saleem , sales man , neamah beakari

Frist student marks,overal result commanli2mints then after total member's results with in milli secons... we can solve.

Utilisateur supprimé
par Utilisateur supprimé

although its depend by which method we are going to calculate  the sheet.

its depends time may vary from seconds to minutes.

for me i think might be minute.

Salam Al-Qerem
par Salam Al-Qerem , Business Service Manager , UNRWA

Using the office2010, coding colors for differnt values in numerous columns is very easy through coditional formatting options and can take seconds.

More Questions Like This