Can Excel Generate Result, Grade & Percentage Automatically?
Excel IF, IFs, Countif, Conditional Formatting All in One tutorial in Hindi
My name is Vishvas Parolkar. My primary objective to make this channle is to help you in learning Data Analysis skills and office automation techniques.
About this video:
In this video you will learn everything about result processing with logical functions to calculate total marks, Pass/Fail/Supplimentry, Divisions - First/Second/Third, Grades - A+ to E grades, Conditional formatting to highlight students row with Green to highlight "Pass", Yellow for "Supplimentry" and Red for "Fail".
#excel #excelforbeginners #advancedexcel #excelformulas #exceltutorial #exceldataanalytics #exceltips #exceltricks #exceltipsandtricks #excelformula #dataanalysis
Download File for Practice:
https://docs.google.com/spreadsheets/...
Time Stamps:
00:00:00 Introduction
00:13:00 Total Marks Formula
00:19:30 Percentage of Marks
00:21:45 Result Pass/Fail
00:41:00 Grade A to E
00:48:42 Division - First/Second/Third
00:53:50 Conditional Formatting
My Playlists:
YouTube Shorts:
🔗 YouTube Channel: Watch my educational videos on Advanced Excel, Power BI, and more to boost your IT skills!
MS-Excel Basics for beginners:
• Excel Made Easy for Beginners
Office 365:
• Microsoft Office 365
Advanced Excel:
• Advanced Excel
Tally Accounting:
• Tally Accounting
Google Sheet:
• Google Sheet
My Social connections:
🔗 YouTube Channel: Watch my educational videos on Advanced Excel, Power BI, and more to boost your IT skills! / vishvasparolkar
🔗 LinkedIn: Connect with me professionally for updates on my latest content, industry insights, and discussions on data analytics and business tools.
Connect on LinkedIn
🔗 Facebook: Join my community to stay updated on my latest videos and tech tips.
Follow me on Facebook
🔗 WhatsApp Channel: Get real-time updates and direct access to my content via WhatsApp.
Join my WhatsApp Channel
🔗 Google Reviews: Have you enjoyed my content or training? Share your feedback on Google!
Leave a Review