Excel Function Transpose – Transfer column Vertical data to Row in Horizontal Form and Row’s Horizontal data to column in Vertical Form

Transfer data from column to row and row data to column with Transpose Excel Function What is Transpose Excel Function? The list that is in the column, we can copy and paste it in Horizontal form in Row. And Row’s Horizontal data can be transferred to Vertical Form in a list. How to use MS … Read more

Excel Functions Data Filter| Learn how to filter data of different categories and copy paste the filtered data into separate sheets.

MS Excel Data Filter Learn from the beginning  What is Filter? According to the information we can view any data separately, calculate or copy, paste it in a separate sheet. If we have a date wise cash receipt register and we want to see only the data of a specific date, then we can filter … Read more

Learn Basic Data Sorting in MS Excel Data sort by Alphabetical Order & Reverse Alphabetical Order A to Z & Z to A

Data Shorting By Text Usage of Data Sorting –  Data sort by Value Content     In the Excel Sheet we can arrange Data by Different Order. Column Text List short by A to Z Alphabetical order Or reverse. Numerical column Data short by Smallest to Largest or Largest to Smallest. Date can arrange by … Read more