## 5 Important Excel Shortcut Keys That Make You An Expert In MS Excel Select, Insert or Delete Row or Column

Learn 5 MS Excel Shortcut Keys That make Excel work Fast Select, Insert or Delete Row or Column In this article, today we are going to learn Excel shortcuts keys to select and delete row or columns of MS Excel. Perhaps you know this excel shortcuts keys, but reading this article will teach you all … Read more

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

## 5 important facts that you should know about excel function – Search & Replace

Find & Replace – A function that will give you data search and replace What is the Find & Replace function and its uses? Excel Function Find – Whatever data is available in the excel sheet, and in any sheet, you can search the data from the data through the Search Excel function. As if … 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

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

## Free Birthday Planner Workbook Download Now

Features Selected Month Birth day List With Photo Search Birthday by Name Search Birthday By Date Up to 2200 Entry Simple User friendly Excel work book Click Here to Download

## 2 Useful Excel shortcut keys for Fast Data Entry | Auto Fill | Fill down, Fill Right

Useful Excel shortcut keys Learn in Details     We can manage data in less time using excel shortcut Keys. Sometimes we just ignore simple shortcuts. We will look at these shortcuts that will surely help you to handle excel. We will Learn following 2 Excel shortcut keys 1. Fill Down – Ctrl + D2. Fill … 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