Discover Talent™

  Data Validation Whole Number | Decimal | Drop Down List | Date | Text Length in Microsoft Excel #DropDownList #DataValidation is an essential function in Ms excel which is most frequently used in excel specially when we create structed forms or any #ExcelTemplate when users interact with your created forms or template and as a publisher and creator you want he /she chose the required field as per the #Validation then this rules needs to set it up as per your requirement there nice amount of options like If incase it's working the above video then refer the below video #WholeNumber #Text #Decimal #Date #List #SelectList and much more few I have covered in this series if you wish to know more about other categories too feel free revert us will help you out now in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents We have published more than 150 videos which are covering Ms excel basic t

 Learn with us #DiscoverTalent with easy steps how you can add the TIME in excel not only addition but also you can do the TOTAL of total hours are in placed.  Learn how to do formatting in #msxcel while using a #timestamp  As we all know adding time in ms excel while tracking a employees data is really importnat so usually do a ctrl+shift+; its nice but not always when we work in the multinational company as a #MIS ,Backoffice or any other post as we know ms excel is really importnat . After watching this video you will be able to set specific formatting in the excel sheet where you want to add the time stamp for in and out . this also helps to maintain #downtimetracker during this #covid situation  as we all know every one is almost doing work from home to track their attendance or shift time we usually use a time function and in this tutorial its almost cover how to recifty the #error time function and how to effectively use the time function we plotted this in three diffrent segeme

 Every excel user should know this  Learn with Discover Talent presents #QuickAnalysisTool , #GoalSeek , #Vlookup , #Filter , #Dropdownlist , #Edatefunction, #RemoveDuplicates, #Autofitcolumnwidth, #FlashFill #AutoFill and #PasteSpecial . We are well known about this acronym In ms excel especially the #MIS or #OfficeStaff but the people who is In the beginner level and they wish to learn about this functionality so for that we have prepared this video series  #QuickAnalysisTool – it helps you to easily prepared summary , charts calculation one single click to know more watchout our videos.   #GoalSeek – This is the most popular function in #MsExcel where people wanted identify the value  which will tally the given total, As per #Wiki - In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical mea

 World is demanding and companies also looking for the smart employees to work with their organization #FlashFill and #TextToColumn is the best option in #MsExcel where you can fill the necessary data in sequential form now what does that mean ? so to understand this you need to watch this video very simpler way we have portray the steps. This will help you to reduce your #ManualWork and it will increase your #WorkEfficiency.  Flash Fill automatically fills your data when it senses a pattern and Text to column You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard. As you know you can split the data with the help of #Texttocolumn and #Flashfill however you might be curious that how can you join the data hence we shared the bonus tip here “Concatenation” function in which you can merge to text cells in one . You might have the queries like  Flash Fill in Excel 2019, 2016 and 2013 with examples Flash fill short cut How to use

  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 attendance sheet ? What is discover t

 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 related