Posts

Showing posts with the label excel cool tips

SUBSTITUTE Function in Excel

Image
 Discover Talent Presents - Substitute Function in excel | SUBSTITUTE Formula in Excel |  Excel Formula Substitutes is the best function in ms excel which help you to replace from one old text to new text string . Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string we have shown to functions in our channel #ReplaceFunction #SubstituteFunction as well checkout our #Shorts and get hands on the #MsExcel Training tutorial free of cost we are here to help you out if incase you would need more support on the understanding #DiscoverTalentPresetns don’t forget us to subscribe on the Youtube Instagram we use to share #ExcelMemer hash tag and we share #Memes in such way so you can understand the concept of #excel trainings  We have published more than 150 videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume

=SUM() or Alt + = Which is best?

 Everyone beginner to experience holder who uses the Ms excel they know how to calculate total in Ms excel. Which is good part part. However being known excel and in reality being more productive in our daily regime is more important So here is the Quick Tip from discover talent presents how quickly you could add the sun value for respective cells in Ms excel This video we have demonstrate that the fast work or more productive work applicable any laptop user then if you are windows user or MAC user.  As you know with the help of =Sum() function we could add the total But here with help of keyboard short cuts fraction of sec you will get the result Try this ExcelHack and share your feedback in below comment.