Franchise To Open Computer Center, ABCSA,Computer Franchise, Free Franchise

 Unlocking the Secret Formula for Star Rating in MS Excel - You Won't Believe It! Get ready to revolutionize your Excel skills with the incredible Star Rating Formula! In this comprehensive video, we delve deep into the world of MS Excel, uncovering the mysteries behind star and bar ratings. 🌟 Whether you're a data enthusiast or a spreadsheet novice, this guide will take you step-by-step through the process of mastering these rating techniques. Watch now to unlock the potential of Excel and elevate your data visualization game to new heights! Formula for Star Rating in MS Excel The `REPT()` function in Excel is an amazing function and if it is used with some tricks then we can visualize our data in an interesting manner such as in bar form or in star rating form. The main use of rept() function is to repeat any text string as per number given in formula. It takes two arguments: the text you want to repeat and the number of times you want it to be repeated. Here's the sy

how to make ticket booking sheet in excel, step by step tutorial to make ticket booking program in ms excel, excel tips and tricks, excel, Microsoft excel, excel formula, excel project. Step by step tutorial to make Program in Excel for show booking, how to make concert booking software in Ms Excel without using Visual Basic?. Ms excel is very powerful and useful application in which we can do different types of office work easily. In todays tutorial we will know how to make booking window for show.  How to Make Ticket booking Sheet tutorial in excel In this we will use the following formulas: Conditional formatting Data Validation Countif formula in excel Addition formula in ms excel Date Converting date into Day by using TEXT formula. We will use the following Abbreviation: B For Booked R for Reserved Suppose we want to make a program in which we can book the seats for Comedy Show.  Total Seats available are 200 in hall and and in every row there are 10 seats available.  We will p

Best Excel Shortcut Keys || मिनटों का काम सेकंड्स में होगा , how to work fast in excel through keyboard. In this article we will learn 15 Excel Shortcuts uses which will help to work better. This is equally useful for teachers, students, operators etc.  Best Excel Shortcut Keys Best Shortcut keys of Excel: Ctrl+Pagedown  and Ctrl+PageUp:: To navigate among sheets-अगर आपको एक शीत से दूसरे शीट में जाना है बिना माउस का प्रयोग किये तो आप इस shortcut key का स्तेमाल कर सकते हैं|  Ctrl+R and Ctrl+D :: अगर आपको किसी formula या text को right में कॉपी करना है तो इस shortcut key का स्तेमाल कर सकते हैं | Ctrl+D ====== To Duplicate any object or To fill Down इसका स्तेमाल करके किसी भी कमांड को दुसरे सेल में कॉपी कर सकते हैं या फिर नीचे के सिलेक्टेड cells में कॉपी कर सकते हैं |  F2: इसका स्तेमाल करके एडिट कर सकते हैं किसी भी सेल को, जैसे किसी formula को एडिट करना हो या फिर किसी text को | F4== To Repeat last command and To Add Fixed Reference i.e. to fix any cell, Check Example in video.  Alt+= :

How to Calculate Commission in Excel?, calculate commissions, commissions, commissions payment, if statement, microsoft excel, excel, functions,  if we learn how to bring out commission in excel then we can make any sheet for office. This will be very helpful for marketing management people. Team leaders, MIS operators etc. How to Calculate Commission in Excel? To do this we will use a table which will contain 5 headings in columns i.e.  Name Basic Salary Sales Amount Commission Total Pay Now we will use  Nested IF to calculate COMMISSION Commission Calculation Criteria are as Follows: Sales Amount is Less than 150000 then 10% Sales Amount is Greater than or Equal to  150000  and less than 350000 then 15% Sales Amount is Greater than 350000 then 20% Now As per the Template we will use the following formula to calculate commission: =IF(D6<150000,D6*10%, IF(D6>=150000,D6*15%,IF(D6>35000,D6*20%))) And all Done. Drag the formula down and we will get the result in every cell.

How to make Fully Automatic Student Attendance Sheet In Excel – Free Download, step by step instruction with live demonstration in hindi. ये Student Attendance Sheet Fully Automatic है जिसमें आप पूरे 12 महीने की अटेंडेंस ले सकते हैं और हर साल इसे नए साल से बदल भी सकते हैं | Free For Life Long इस Attendance Sheet को बनाने के लिए किसी भी तरह के VBA Code का यूज नहीं किया गया है अगर आप इस Fully Automatic Student Attendance Sheet को Excel में खुद से बनाना चाहते हैं तो इसके लिए नीचे दिए हुए वीडियो को आप देखें जिसमें हमने Step by step जानकारी दी है |  इस excel project को करके आप excel में और बेहतर तरीके से प्रयोग कर सकते हैं |  How to Make Fully Automatic Student Attendance Sheet Excel इस project में हमने निम्न formulas प्रयोग किये हैं : MID(CELL(“filename”,B2),FIND(“]”,CELL(“filename”,B2))+1,255)  इसका एडवांस formula ये हैं - MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255)&" "&2023 बाद वाले फार्मूला में year को बदलने से वो उस साल