Discover Talent™

E xtract User Name from an Email ID in Excel | Improve Productivity |  Office Tips #excel  #excelgeek Discover Talent Presents - Extract User Name from an Email ID in Excel Seprate Column Information in Excel  In #Excel when we have raw dump with email id's and we need to adhere ETL ( Extract , Transform and Load ) in excel that time formulas and function  plays a really important role in this tutorial as well i have demonstrated how you can segregate user name from email id with 2 unique ways  feel free to comment in below section which step you loved the most and which save your time make you more productive in your daily regime office work #LEFT #Search Function and #FindAndReplace  . These steps are simple and easy to perform if you still find any difficulty to perform feel free to ping me on FB / LINKED IN / Youtube / Instagram channel Happy to assist You can type this on the google Discover talent presents to get the free learning material for MsexcelTraining Hurry up.! We

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

Everyone uses Ms excel. People called it there is difference between basic and advance excel. Ms excel is one there is no basic and advance only thr practice makes you more proficient. As I'm using Ms excel last 10years now here I've came up with channel name Discover Talent Presents where Ive started sharing Basic level excel training for those who  novice with Excel Also distributed so far 100 certification free of cost which is amazing count for me at least our goal is to up skill my subscriber or the fans who aligned on Facebook, linked in, Pinterest, blogger reader like you, Tumblr.  Now after covering with the Ms excel basics now I've started with Ms excel Hacks, Tips and Tricks and important function which you could use in your daily regime specially in Offices, School and College's where you can use those function Easy to find us you may search on google Typing Discover Talent Presents ( as Google is the #1) search engine across globe hence we shared this refere

 In this video #InsertRibbonTab series we will cover How to visualize a mini chart A #sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use spark lines to show trends in a  series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. #Slicer and #Timelines ( Filter option in ms excel will help you to filter large sheet ms excel file in one go )Please note watch video till end to understand the #MsExcelTipsandTricks #ExcelHacks #LearnExcel  This will help you to not only use the insertion function like #clipart #logo #button #image #graphics #photo but also it helps you to #datavisulization how to do that . watch this video till end its an free ware asset for all of you and it’s a great platform to enhance your skill So keep watching this video till end and share your love with us by clicking on the #Like button. #WinChart , #ColumnChart #WinAndLossChart  #Filters  We are going to issue

Discover Talent Presents | Home Ribbon Tab - Conditional Formatting Tutorial 5-6 In this video series we will cover the #ConditionalFormatting #FormatAsStyles #CellStyles #MsExcel #MsExcelTraining . If you are New to my channel would recommend you to subscribe my channel on YouTube .We have covered #Clipboard, #Font, #Alignment , #Number & and in this series we will cover #Styles.  Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. So stay with me and watch the complete video series this made for the beginners who wish to start there career in #Reportng #Anlyst #WorkinMsExcel   Type on Google #DiscoverTalentPresents for FREE Certification in Excel By Discover Talent Presents ( Like , Share , Comment ) Discover Talent Presents | Learn Basic Ms excel – Tutorial 1 https://www.youtube.com/watch?v=09lIUqJlf2s Discover Ta