Simple Excel Formula Today – Learn Tricks The easiest formula is the excel formula TODAY. Today’s date, just typing TODAY () in the cell, will be visible in that cell. Now you must be thinking what is special about this? Today’s date can be typed sooner than the formula. So in today’s article, we will … Read more
Use unseen MS Excel function – Make data entry form in few steps Excel Function – Data Entry Form Introduction – Excel starts with data entry. Data entry is a very time consuming process. The data entry form is a good way to make data entry simple and fill in accurate fields. But to create … Read more
Excel Formula Now – Show Current Date & Time in one Cell This simple formula is used to perform current date and time shows In the cell where the current date and time is required, type =NOW() Whatever time the computer has, it will show in the same cellWhenever you do any activity in the … Read more
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
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
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
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
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
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
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