Create a Student Fee Record with Automated Progress and Eligibility Status in Excel
In this video, learn how to create an Excel spreadsheet that makes managing student fee records easy and efficient. We'll guide you step-by-step to set up a fully automated system that displays the fee progress at the top of the sheet. Additionally, we’ve included an exam eligibility column that automatically updates to 'Not Eligible' if the fee isn’t paid and assignments or projects are not submitted. Perfect for educational institutions, this tutorial will help you streamline your student data management with ease!
✅For more videos please subscribe our channel:
ua-cam.com/users/PowerExbyJitendra
Sample workbook:
==============================
docs.google.com/spreadsheets/d/16v2_2Y5ZZwq7r_h7ynq4sy6Mt4HmFGGn/edit?usp=sharing&ouid=110173023604601251691&rtpof=true&sd=true
==============================
Playlist of Power BI:
ua-cam.com/play/PLBy4kMPmMt7QJGRCEG04HKDO36kDxUELl.html&si=-Q3sWD3Mvze7WSxk
Must watch these three videos:
👉 ua-cam.com/video/a2xUK6jLIPY/v-deo.html
👉ua-cam.com/video/tP5MdZojMOg/v-deo.html
👉ua-cam.com/video/oAkbqLB2YLw/v-deo.html
Playlists of our top videos:
1. Stock Management System in Excel
ua-cam.com/play/PLBy4kMPmMt7QWl0YvOQumw4A730f36qAV.html
2. Advanced Excel Formulas
ua-cam.com/play/PLBy4kMPmMt7TI0y3zNNVYqc-y0JfFjwgg.html
3. Awesome MS Word Videos
ua-cam.com/play/PLBy4kMPmMt7SYFXHhY2tWTSL3uYG5dRG-.html
4. Conditional Formatting in Excel
ua-cam.com/play/PLBy4kMPmMt7Q8udcHSUO4va9eE_mL1aBL.html
5. Data Entry Form
ua-cam.com/play/PLBy4kMPmMt7TyCiEa2z_j2Hh3pCJrARjT.html
6. Custom Number Formatting Tricks
ua-cam.com/play/PLBy4kMPmMt7TJknWcSfKA17oiaRZDnI0H.html
7. Recent Uploads
ua-cam.com/play/PLBy4kMPmMt7RIG4EhjmidQOsB5uuLX5QF.html
8. Best Excel Shortcut Keys
ua-cam.com/play/PLBy4kMPmMt7Qpqc7rr8GrRYj70_m5Lulm.html
9. Power Query Tutorials
ua-cam.com/play/PLBy4kMPmMt7Qp0F_gR5GLLYD5jBoNjv3b.html
10. MIS Report in Excel
ua-cam.com/play/PLBy4kMPmMt7TTHMnzfqIP5vWeLKpK5nOY.html
11. Excel PivotTable
ua-cam.com/play/PLBy4kMPmMt7SM15JjjcmlXBBQiGKftLrw.html
12. Task Tracker or To-Do List
ua-cam.com/play/PLBy4kMPmMt7RpxCvzNPcP7APowZZWa_qG.html
13. Excel for Accounting
ua-cam.com/play/PLBy4kMPmMt7TZmLrSrx3k8KBznKQ62a1c.html
14. Excel Lookup Functions
ua-cam.com/play/PLBy4kMPmMt7TT2Xp7Jjs1hb3KxzK4dIWV.html
15. Filter
ua-cam.com/play/PLBy4kMPmMt7SZmCx_0w9qmO2t86gdeV8K.html
-------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#dataentry
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11?igshid=zd7v216sfxr7
Facebook : PowerEx-by-Jitendra-108422660912839/
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