Learn how to delete row and column in excel You can use keyboard shortcut keys to delete rows or columns in Excel, or even delete them with the mouse. To delete a row, select the row you want to delete in Excel. Right-click on the row with the numbers on the left side of the … Read more
Learn How to Insert empty rows in the Data Table In this tutorial, we will learn to insert a blank row under each data row in the data table. We will insert a blank row under each name in the table below. For this, enter the serial number in the last blank column of the … Read more
Here comes the Xlookup function. Now say goodbye to the Vlookup function. The most popular function of Excel is called Vlookup Function in Excel. A few months ago Microsoft launched a new function Xlookup Function.Now it has been added in the update to Office 365. In this article, let’s learn how to Apply XLOOKUP Function … Read more
Easy way to print settings in Microsoft Excel If there is any big or small data in Excel, setting up the print is very difficult initially. Taking today we will learn to print in some simple way. Page break preview Page break preview option is the easiest and best for Excel Print setting. This allows … Read more
Use of SUMIF Function If you have some positive numbers and negative numbers in the list, then with SUMIF function we can sum only positive or only negative numbers. You can only easily do 2 steps.1. Selecting Range2. Apply more than and less than conditions. = SUMIF(Range,Condtion)Let’s understand from an example. 1. Sum of Positive … Read more
Vlookup Formula in MS Excel What is Vlookup ? Vlookup formula is the option of vertical Lookup to get information from the table.There is a lot of data in a big table, and if we have to extract some information, we can easily see the information by applying Vlookup. How can vlookup be used? Not only information, … Read more
New Upcoming MS Excel Formula & Function Microsoft is adding 6 new advanced MS Excel functions. However, now these functions will be available in Office Insiders and Office 365 after a few months.By using these new functions, we will be able to easily manage the data automatically.Know which work will make it easier! Microsoft is … Read more
Excel function for data entry – Data validation & Error Alert What is data validation and drop down list? What is the use of data validation? In Excel also, like software, we can put a drop down list in data entry. Drop down list has many advantages. like …. If different data entry operators fill … 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
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