Automatic Report Card in Excel | Student Result Card in Excel

Automatic Report Card in Excel | Student Result Card in Excel
In this video tutorial you learn how to create an automatic student result card in Excel. As you type or select roll number of the student in drop down, the report card will be prepared automatically. Very common formulas of Microsoft Excel are used to create it.
So watch the video and if you find it valuable please subscribe our channel: / powerexbyjitendra
Download our file:
docs.google.com/spreadsheets/...
Related Videos:
1. Drop Down List in Excel
• How To Create Auto Upd...
2. Vlookup Function in Excel
• Vlookup Formula in MS ...
3. Vlookup + Match Function in Excel
• How to Use Vlookup wit...
4. If Function in Excel
• If Function in Excel i...
5. Grade Calculation in Excel using Look Up Function
• Grade Calculation in E...
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
-----------------------------------------------------------
Gear I Recommend:
-----------------------------------------------------
1. Mice: amzn.to/3I2stPd
2. Mobile Tripod Mount: amzn.to/33gR8kh
3. Gurilla Tripod: amzn.to/3FqwsmT
4. amzn.to/3npWu3C
5. Tripod: amzn.to/3I4P3GV
6. Wireless Bluetooth Headphone: amzn.to/3K8XUcl
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#excel
#powerxbyjitendra
#exceltips
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@Hajora21]

Hello! A lot of thanks for this video!! Appreciate it so much, you really explained it clearly and smoothly! Thanks a lot it helping me so much with my work… ☺️

[@khushikhushihappily7690]

Really this is helpful. Zajakallah khairun

[@inoxentgirl9854]

Thanks you sir ap na bht acha samjhaia jizakallha ❤️

[@simplevlogs79]

Best video 👏👏💯💯..Thankful to Teacher 🙏

[@PowerExbyJitendra]

Thank you so much

[@gowherbhat9182]

Need your no sir​@@PowerExbyJitendra

[@chiduprabhas]

You saved my lot of time and effort, Thank you Very much sir 🙏 🙂

[@sureshram6907]

Grade technique is best way explained sir ji.

[@PowerExbyJitendra]

Thanks a lot

[@khushisendre7426]

Very nice and useful thank you so much sir

[@AmitYadav-hy8py]

bahut achchhe se samjhaye hai sir 🙏🏻🙏🏻🙏🏻

[@PowerExbyJitendra]

Thanks

[@lifewithkangnajain2534]

It helped me for my practical thank hou sir

[@yashwantkumarpatel5558]

This video is very helpful please make a video and tell how to take print this automatic report card easily.

[@user-gw2bb1ds5o]

thanks for your tutorial it help me allots.

[@Hajora21]

How can I print all the students report cards at once please
Thank you very very very very much for this helpful video!
Appreciate it

[@gamestechandmovies6207]

THANKS BROTHER......
please can you help me with how to print all the reports with one click

[@khejuriaghatmodernacademyo2423]

thanks sir very informative video.

[@isaacnzayisenga1189]

Thank you!

[@nikhilpandey5373]

Thank you so much. This video is most useful for me. thanks a lot sir.
I love you sir 🙏

[@PowerExbyJitendra]

Thanks

[@techforallneeds]

good explanation keep it up

[@srinuclassic9238]

Thankyou soo much sir..💥

[@VikashGupta-ke1lf]

Thanks 👍🙏 bro

[@TspscTG]

Sir why u used match formula without match formula we can NOT get exact SUBJECTS MARKS ????? 🙏🤗
PRESENTATION VERY NEAT AND CLEAN

[@rocksonboateng8061]

Please Sir, can you kindly take me through the steps in setting page to print more reports….thanks for the video too❤❤❤

[@umer-nz4bm5fd3u]

Thank you soooooo Much Sir☺☺☺

[@shantilalrajput8708]

V.nice Sir Thank You Sir 🇮🇳🇮🇳🇮🇳

[@PowerExbyJitendra]

Thanks ji

[@Nghata]

Good explanation and good example

[@PowerExbyJitendra]

Thank you so much

[@satyajitchatterjee3713]

Well explained 👏

[@PowerExbyJitendra]

Thanks

[@parthbhadoriya8489]

Amazing video brother! You saved my day!

[@PowerExbyJitendra]

Thanks

[@parthbhadoriya8489]

Can we print all report cards at once??

[@dolphin1008]

@@parthbhadoriya8489 I think, Not possible.

[@kabphonehub]

It's possible bro to print them actually u can export them as pdf all at once

[@AbdulganiyuBamigboye]

How to export them at once?

[@HAZRATALI-rn9xg]

Very impressive sir

[@ArshadAli-ph9zt]

Hello sir it's. Fantastic and very helpful for me.
Kindly tell how we can add pictures of students that will be also change automatically???

[@bittu25]

Thanks for teaching Student Result Card.

[@PowerExbyJitendra]

Welcome

[@BeGeniusjd]

Nice informative video
Subscribed

[@PowerExbyJitendra]

Thanks

[@HAZRATALI-rn9xg]

Amazing 😮

[@SanaZahra_]

IT WAS GREAT HELP...😇

[@PowerExbyJitendra]

Thanks

[@abuddin514]

nice job

[@bharatikhichi7297]

Thanks sir! It was great study

[@PowerExbyJitendra]

Thanks a lot

[@tahirmushtaq3936]

excellent

[@qazimtahir]

Really EXCELLENT 👍👍👍👍

[@PowerExbyJitendra]

Thanks a lot

[@ramzannazir2662]

thanks dear

[@govindhitech]

Thanks Sir for nice explanation

[@PowerExbyJitendra]

Welcome

[@pfmsproblems151]

wel done sir very useful

[@PowerExbyJitendra]

Thanks

[@rheajobin06]

It is easy to do it!!

[@PowerExbyJitendra]

Thanks

[@saleemmalik699]

Great Sir

[@PowerExbyJitendra]

Thanks ji

[@HAMIDURRAHMAN-dc1su]

Thank You sir this video really helpfull.

[@85MA]

It was amazing to learn with you. Thanks for helping us learn! I have a scenario where I have data in Column B2 to H2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column D2 to F2. Is it possible to highlight in this way? The thing to remember is that the data is in Excel worksheet not in table

[@PowerExbyJitendra]

Thanks

[@misterbeastinurdu]

i liked b/c i learned a lot.

[@PowerExbyJitendra]

Thanks

[@misterbeastinurdu]

@@PowerExbyJitendra but sir there is problem in printing. it appears half.

[@jyotiagrawal3750]

Thnx sir so much

[@PowerExbyJitendra]

Welcome

[@samsonlal9899]

Wowww... 👏👏👏👏

[@PowerExbyJitendra]

Thanks a lot

[@aditimalani8102]

What if we want to add some roll no in data base how can we make changes un the report card as all the array are already fixed

[@basavarajkamatar197]

Thank you

[@PowerExbyJitendra]

Welcome

[@maypeaceprevailonearth4191]

Nice explanation

[@PowerExbyJitendra]

Thanks

[@arajahan4165]

Sir plzzz Mje ye btaye agr percentage range m hoga like70-75 percent phr grade look up value se kyse nkale. Sir apke respond ka wait kr rhe hu

[@mangeshchaure9994]

Thanks

[@Mohmand-Learning_Center]

thank you so much

[@PowerExbyJitendra]

Thanks

[@ssedits4338]

Sir please tell how to add print in same report card

[@rahulnayak8357]

Great job brother but if I want to take a multiple print at a time then I need to copy the individual report card then after copying I cannot see the automatic report card generation

[@piubhalla9241]

Same my question

[@piubhalla9241]

This method is for few students for bulk of students what we can do?

[@golamrabbani4863]

Oh it's great .............

[@PowerExbyJitendra]

Thanks

[@online_class_with_ajibola]

Good good Job, please translate to English. I really need this. Please!

[@sadhna_singh_RSL]

Nice video sir

[@PowerExbyJitendra]

Thanks

[@user-ux7oi2we6y]

Is there a shortcut to print all the report cards without clicking on Roll no 1by1 ?

[@kabphonehub]

Ya it's there

[@Hanisha777]

Thanks❤❤❤

[@PowerExbyJitendra]

Thanks a lot

[@Seriously_Busy_in_Patna]

GOOD ONE

[@PowerExbyJitendra]

Thanks

[@peraiahnavuluri1087]

GOOD

[@taufiqhussain7837]

👍👍👍

[@PowerExbyJitendra]

Thanks

[@ShivanandShindhe]

Incase of optional subjects, how to show only particular subject particular student

[@DineshKumar-fl7lb]

What if the database values are in rows instead of columns

[@PowerExbyJitendra]

No issue Match will do it

[@Rayyantahir879]

Hello dear sir ... Your style nd method is amazing. Kia aap soft copy day sakty hain

[@aqeelahmad8237]

Best video

[@PowerExbyJitendra]

Thanks a lot

[@sdokmk3158]

EXCELLENT

[@PowerExbyJitendra]

Thanks

[@Ashwanisharma-zv7lh]

thanx

[@Shameem07867]

nice

[@simuislam5752]

Nice video

[@PowerExbyJitendra]

Thanks

[@naatzindagihai8914]

Sir agar koi student 1 subject mai fail ho raha ho or hame total result fail karna ho to kaise kare ge

[@nycollassilva3558]

Hwnd
Aqsm

[@Altaf_Alam]

Bro IF + AND function ko combine karke use karna hoga

[@mantucreation9827]

=IF(MIN(subject range)>35,"PASS","FAIL") Try Once..👍

[@jeevansuna4902]

​@@mantucreation9827right sir ji

[@mhhasan2005]

All you right

[@_all__dance__so_]

Thenk your sir

[@PowerExbyJitendra]

Welcome

[@aamirali195]

Hi,
I need your assistance for data validation I have create a list and another list for data validation but as when as I try to open source sheet in source my excel does not work for it. What is problem in it or what can I do for source option to work

[@crafteducationalacademy258]

Sir kindly explain me how to add a photo in this report card

[@suhaibkarchoo9688]

Sir how to prepare marks sheet of different terms of examination like U1, U2, summative and so on.

[@sujeshvpsnair]

Can I print all report card ?if explain

[@user-qv9yb7tk4q]

THANK YOU SIR IT HELPS ME A LOT

[@PowerExbyJitendra]

Welcome

[@shireenshah6928]

Sir ye one by one print kr skte h ya ek sath sb hojaega

[@technicalsupport435]

thanks sir

[@PowerExbyJitendra]

Welcome

[@sakeenabano2003]

sir please advise how to fill automatic fill marks first second third semester marks

[@manishchaudhary9110]

Sir final term result ke liye bhi video bna dijiye, jisme 1st term aur 2nd term ka bhi result ho, please sir

[@nikhilgoyal7037]

If any student is fail in one or two subjects and we want to show final result fail for those
Then how can we do that

[@HeyYou-hy6zm]

If I want to promote a student who gathered 5 Ds and want to generate his status as " Promoted Under Consideration ", which formula I have to use?
Plz reply, sir.

[@prabeshneupane3566]

How do you print all the marksheets at once?

[@Natureatglance___11]

Did you find any way yet? If you have found, please tell me, it'll be a great help

[@aimbond2101]

Thanks for this video. How can I print the report card for all the students? Thanks

[@PowerExbyJitendra]

Please make setting in Page Setup

[@aimbond2101]

@@PowerExbyJitendra ok. I will check it out. Thanks sir

[@danielishayac]

@@aimbond2101 Please have found out how to do it?

[@SMCreationShivinsalmani]

Lekin sir jab ham data base me new member add krenge to wo bhi automatic report card me add ho Jana chahiy dobara se farmula lagay Bina automatic

[@aryankushram]

Data Validation Me Dusra Sheet Add Nhi Ho Raha Hai

[@samuellawrence7140]

How can I get the English version or a subtitle?

[@priiyankaasetia5576]

Sir your video help me a lot but I am facing one problem when we click on data validation then select list in allow but I am not able to select database sheet!please help where I am wrong?

[@user-xg4dm3wj1x]

Same problem here

[@hamzashakeel729]

❤❤❤

[@PowerExbyJitendra]

Thanks

[@mubashirhassan8815]

If any one is absent in any one subjects then what's is the formula

[@nabinsoren]

Hello sir

[@Jazbasportsnetwork]

Sir agr bcha Absent mark krna ho to sari row ka data null show ho ga aur report shi ni show jo gi. Direct method hy jis sy 0 ho jay values

[@saminanasreen6719]

Can you do one for googlesheets

[@khushboofarooq5354]

How to print individual marks card

[@KingofEntertainment83462]

when i do vlookup , NA appears , why is it so, and Fixing is also an issue using f4

[@sakshi47632]

Sir jo icon wala option hai wo ms office 2007 me nhi hota hai kya?

[@user-uo6ey4nn4v]

Data validation part is not process in my excell sheet please guide us sir

[@rajindarparsad9052]

Lot of data, so i want to put Roll nunber which i have remember, so tell me how to add put up button.
Like it difficult to search roll number

[@mnw703]

If we want to save each student card then what to do