## 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

## Excel Formulas CONCATENATE Bring the text of multiple cells into one cell with Paste Special

CONCATENATE Excel Formula A simple formula to bring the text of multiple cells into a single cell Usage of Excel Formula CONCATENATE            If any of our information is in 2 or more cells separately, then we can put all the text in one cell just by applying the  CONCATENATE Excel formula. … Read more

## Video Tutorial Freeze Panes Excel Function Lock row while scrolling large Data

Video Tutorial Freeze Panes Excel Function Lock row while scrolling large Data Freeze Panes

## Learn Basic Data Sorting in MS Excel Data sort by Date Oldest to Newest & Newest to oldest

Data Shorting By Date Usage of Data Sorting –  Data sort by Value Content     In the Excel Sheet we can arrange Data by Different Order. 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 Oldest to … 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

## MS Excel Function Freeze Panes for Freeze Column & Row While Scrolling Large Data of Excel Sheet

Freeze Panes Function Freeze Panes Usage – Freeze panes to Lock   rows and Columns.   Keep lock headings or columns of name or code wile scrolling another data of worksheet.                      In the Large data of Excel file Row or Column data not showing in computer screen. When … Read more