Tamizh Tech Tutorial

  Tamizh Tech Tutorial Word Frequency in Excel           In this tutorial, you will learn and find how to count words in excel. Follow the steps below Step 1: Extract the input words using unique function =unique (input range) Step 2: Apply the builtin formula named countif (range, condition) for the obtained unique words using unique() function from step 1 Display the result. Example - Word Count in Excel 1. Input 2. Extract the unique words using unique() =UNIQUE ( H11:H26 ) 3. Result =COUNTIF ( H11:H26 , I11 ) The function above is used to display the word frequency based on the condition. Tamizh Tech Tutorial

  Tamizh Tech Tutorial 4 Tips to Merge Cells in Excel                 Excel Tutorial In this tutorial, you will learn 4 excel tips to merge cells in excel with example. Excel Tips - 4 Tips to Combine Cells in Excel  Using Concatenate(cell 1, cell 2, ...celll n) function Using Concat(cell 1, cell 2, ...cell n) function Using & Operator Using TextJoin(delimiter, ignore_empty, cell 1, cell 2,  cell n) 1. Using Concatenate(cell 1, cell 2, ...cell n) It is a predefined excel function  This function is used to merge /join multiple cells into single cells. Syntax =concatenate(cell 1, cell 2, cell 3, … cell n) Where, cell 1, cell 2, cell 3, … cell n are list of input cells. 2. Using Concat(cell 1, cell 2, ...cell n) It is a latest predefined excel function  Like Concatenate() function, this function is used to merge /join multiple cells into single cells. Note It is available in office 2019 or higher versions and office 365 online Syntax =concat(cell 1, cell 2, cell 3, … cell n) Where

  Tamizh Tech Tutorial Linux Tutorial - Directory Related Commands                  (15 Examples) Linux Commands In this tutorial, you will find the 15 essential directory related commands in the linux / unix. 1. mkdir command This command is used to create a new directory in the linux terminal It takes only one argument which is the name of the directory name Usages Directory creation Sub directory creation with help of -p option Syntax  mkdir directoryname Where, directoryname is a user defined name. Example Sub-directories creation With the help of option -p , we can create multiple sub-directories under a directory. Syntax  mkdir -p existing_directoryname/sd mkdir -p existing_directoryname/{sd1, sd2, sd3, sd4, …sdn} Where, -p indicates parents (parent directory) existing_directoryname is a name of existing directory name sd is a name of sub-directory sd1, sd2,sd3,...sd4 are names of newly created sub directories under the parent directory. Example 2. rmdir command This command