Ms Excel TOP10 Tricks
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 means.
#Vlookup – Vlookup and #Hlookup checkout the similar value in other sheet or table and fetch the return value check out the video to know more. if you want us to cover #Hlookup as well then feel free to comment in #Youtube channel discovertalent143
#Filter – Its fetch the particular tables #sheet unique value
#Advance filter – as we have already covered the advance filter in ms excel hence checkout the URL https://youtu.be/hQT6YLIfIbQ
#Dropdownlist - while creating a #Forms in ms excel this is the top most function you looking for
#Edatefunction – this function will help you to add specific month in the given date how it works ? watchout our video . search us on google #DiscoverTalentPresents
#RemoveDuplicates – Large spreadsheets we can see there are multiple duplicates values checking out each individual its tedious task hence the best option is #RemoveDuplicatesinExcel how it works ? checkout our video series .
#Autofitcolumnwidth- This option you can see in the #MsOutlook as well but here in excel small difference to know more watchout our video .
#FlashFill #AutoFill - 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 .
in depth #Analysis we have create a separate video series on this to know more check out this URL https://youtu.be/Lvtq3T3G41M
#PasteSpecial . – Last but not the least PasteSpecial function to avoid much length of video we have only covered two option #Values and #Transpose if you want us to cover other option as well feel free to comment in youtube ( disovertalent143 ) channel so in upcoming series we will cover the pastespecial function.
In upcoming series 2 we are covering top most function so urge you to subscribe this channel and turn of the notification bell where you can get the notification in our upcoming video #DiscoverTalentPresents search this on google to stay updated.
Feel free to Like | Share | Comment – Recommend this channel with your friends too and get a chance to earn #Rewards.
You might have the queries like
What is the formula to remove duplicates in Excel?
How do I remove duplicates in Excel 2019?
Flash Fill in Excel 2019, 2016 and 2013 with examples
Flash fill short cut
What is Goal Seek function in Excel?
How do you automate Goal Seek in Excel?
How to use text to columns in excel?
Difference between flash fill vs Text to Column
What is flash fill?
How do you text a column?
How to Use Text-to-Columns in Excel
What is text to column in Excel?
Does excel remove duplicates keep first?
How to show drop down list in excel?
How do I create a drop down list in Excel 2018?
What is the small square in the lower right corner of a cell called?
How do you use flash fill?
How do I enable Flash fill in Excel?
How do I add text to an entire column in Excel?
How to use concatenate function
Why can't I Paste Special Values in Excel?
How to merge to cells in one cell ?
How do you use Paste Special in Excel?
How do you use Goal Seek?
PS :- People who subscribed #DiscoverTalent143 those only get the practise material . .
This function will help you to make your work smartly in your #DailyRegime #Office , #School #Colleges etc. #MIS #Reports
Just type - #DiscoverTalentPresents on the Google and be found.
We are also available on the –
#Pinterest https://www.pinterest.com/pin/6591440
#Instagram: #DiscoverTalent143
#Tumblr: - https://discover-talent-presents.tumblr.com..
#Youtube – https://www.youtube.com/DiscoverTalent143
#Facebook: - https://www.Facebook.com/DiscoverTalent143
#LinkedIN: - https://www.linkedin.com/in/discovertalent143
#Blogger : https://discovertalentpresents.blogspot.com/
Please share this video with you friends