Discover Talent™

  In this video we have covered How to create #rotational week off #attendance sheet with 4 Simple Formulas in #MsExcel TOP MNC’s projects having such requirement also during this pandemic Virtual #Schools #Colleges staff management may have this requirement so urge you to watch this video till end  If you have #FixedWeekOff in place then watch the below video  https://www.youtube.com/watch?v=xi7xhqu1mNs if you need to #PractiseMaterial then please do share your email id in below comments  PS :- People who subscribed #DiscoverTalent143 those only get the practise material . .  You may have queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  How to create attendance sheet in excel ? Which formulas should I use while making a attendance sheet ? What is the charges for attendance sheet ? How quickly you will make attendance sheet ? What things needs to be in consideration while making a attendan...

 What is trace #precedents and #dependents in Excel?. Trace Precedents and Trace Dependents are related features in Excel. With your cursor in a cell that contains a formula, Trace Precedents draws arrows from that cell to each cell referenced in the formula. Trace Dependents is exactly the opposite. It will draw arrows from every cell containing a formula that references your current location. This visualization help you to avoid using the function key which we used to use in our daily routine work which is F2 hot key .  In Excel 2007 or later, you will find both buttons on the Formulas ribbon, along with a Remove Arrows button that you can use to clear the arrows from your screen when you are done. For versions older than 2007, go to the Tools menu and choose Formula Auditing where you can select either one from a submenu. In addition to pointing you to related cells, the arrows also let you jump to those cells. Double click on any blue arrow and your cursor will move to the...