Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Syed Hussaini , Senior Design engineer , private
Date Posted: 2014/03/12
Mohammed Younus Pasha
by 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
by 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.

Deleted user
by Deleted user

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
by 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