Discover Talent™

How to use HLOOKUP Excel Function | Hookup formula in excel | Hlookup vs Vlookup function in Excel  if you are starting with the basics  we are here to help you out learn more about spreadsheets and more importantly the use of  #Formulas which is used in #MsExcel we will guide you each step one by one in this series we have covered the horizontal lookup which retrieve the value which is placed in horizontal way check out our #vlookup shorts as well where we have defined how to use the vlookup and hlookup function we would encourage you to subscribe this channel so you wont missed the important #dataanalysis technique #freecertification  #certification by Discover talent presents if you want to know more about us do  Search us on google typing Discover Talent Presents and enroll 100% free without any cost This function is really effective for any company when we have the large data sets we can't go ahead and manually perform the task instead with. The help of =Hlookup()  function wi

 Ms Excel  vlookup function will help you to look up value vertically across different worksheet sheet or cell  This will function is most popular function among every industry ( small scale and Large scale) This excel function majorly used in skills MIS ( management information system) WFM ( Work force management) back office related , accounting etc.  Take a look at below video and understand how we can use this in frequently in our daily regime  You can also search us on google just type Discover Talent Presents and learn more excel function along with Powerpoint and Ms Word if you wish to learn more  Type your comments on YouTube ▶️ section and do let us know if you want to learn any specific function or formula we are here to help you with 100% training do  also take a note we also provide 100% free certification explore more on  YouTube 

Discover Talent Presents | Learn Basic Ms excel – Tutorial 1 https://www.youtube.com/watch?v=09lIUqJlf2s Discover Talent Presents | Learn Basic Ms excel – Tutorial 2 https://www.youtube.com/watch?v=6aHU3e4ib9Y https://www.youtube.com/watch?v=6aHU3e4ib9Y https://www.youtube.com/watch?v=OO67gUO8cx8 https://www.youtube.com/watch?v=OKh1rr4o81k https://www.youtube.com/watch?v=sIlStC2qkJI https://www.youtube.com/watch?v=Lvtq3T3G41M Learn with Discover Talent presents and get #BasicExcel #MsExcel #MsExcelTips&Tricks #ExcelHacks #FreeCertification in #MsExcel  videos. We also available on #facebookwatch #youtube #instagram #Tumblr  #Pinterest #Linkedin to reach the right candidate  We are covering all the menu bars one by one in our upcoming video series so stay up to date with me #discovertalentpresents Feel free to Like | Share | Comment – Recommend this channel with your friends too and get a chance to earn #Rewards.  Don’t miss any single video visit us  https://msexcel-free-tutorial.b

 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