Posts

Showing posts with the label combine

Concatenate Text and & Operator Function

Image
Concatenate in Excel combine text columns | Excel using the #CONCATENATE function and "&" operator Combine Two or More columns in One Use of Concatenate  Join Text in Ms Excel .MIS work or daily regime especially in MNC’s / KPO / BPO where we have maximum use of #MsExcel you may have situation right where you get the raw dump or csv file from stakeholders and need to published in appropriate format or in school/ Colleges / Universities you have the list of student which are holding there first name last name or employee details with First and Last name in SQL with Join query we can easily do that however in excel Concatenate is the essential function which will help you to save your time and combine n numbers of column in one . Take look at this video and share your thoughts if any difficulty to understand ... Open for the feedback as always #ExcelFunction #TipsAndTricks  As Education is our Right so we offer this service free of cost Do subscribe us for more Learnings an

Consolidate data in multiple worksheets – Excel

Image
 Learn #MsExcel with us if you are unsure how to #Consolidate the XLS file then watch #MsExcelTutorial free of cost. learning is always necessary  If you have the queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  How do I create a consolidated sheet in Excel? How do you delete consolidate in Excel? Where is consolidate in Excel? Consolidate data in multiple worksheets – Excel In this tutorial we have shown 3 tabs where you can consolidate file in it however if you want you can consolidate the sheets as well whichever location they are available to make you understand we create this basic level tutorial  . Thanks for watching this video and if you are new on this YouTube then please subscribe our channel  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 –