Posts

Showing posts with the label Excel Tips and Tricks

Use Filters in Ms Excel

Image
 Use Filters Effectively in excel - Filters function is the essential feature in ms excel you can either use the ctrl + shift + L or you can use Alt + D + F + F for the filter the specific work sheet in ms excel #Filter and the #AdvanceFilter how to use this function more smartly in the series i have covered for the same.    #MsExcel checkout the more learning for #Analytics and #BusinessSolution with us , we also offer certifications with free of cost and career guidance #SixSigma we are launching soon hence urge you to subscribe our channel and get Free of cost #YellowSixSigma Certificate . It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the whole job. Discover Talent Presents what we offer work on large worksheet effectively check out the video and share your comments in below section and don’t forget us to subscribe because your one subscribes or thumb in the form of like motivate us to

Correct VALUE Error in Excel

Image
 Discover Talent Presents | How to correct a VALUE error in the Excel function #Shorts  in this series are covering the topic called #VALUE_Error, this error is most often the result of specifying a mathematical operation with one or more cells that contain text...  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same. We are here to help you out the #VALUE!  It means the Wrong type of argument in a function or wrong type of operator These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandling

How do you concatenate cells in Excel

Image
 In this Tutorial we have covered #concatenate  ( #TextFunction , #HowToCombineText , #MsExcelTutorial  ) function which is available in ms excel.  This will save your lots of time and you will be more productive in your daily routine work .  The word concatenate is just another way of saying "to #combine" or "to join #together". We have also showed very basic step of #Text function or formula how do we leverage this in our daily routine as per our requirement complete your choice.  This whole tutorial in hindi we made it to make you understand . There may be other uses of this function but here we covered the basic thing . Text function specially ( DD, DDD, DDDD ) How it will change to the dates.  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  text function in excel How to Combine Cells in Excel - Text or Numbers – Contextures How do you concatenate cells in Excel? How do you concat