Many ways to delete rows and columns in Excel | how to delete column in excel ?

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

Insert blank rows from Data Table in excel । Delete Blank Row in Excel

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

IF formula in excel | Example for Value Base Calculation | Tax Rebate Example | Set Maximum Value Limit |

Calculate according to the maximum range of values ​​from the Excel IF Formula. In this article, we are going to use IF Formula in a different way. If we use the IF condition to perform calculations within the maximum number limit. The article has already been written on another Example, you can learn by clicking … Read more

Sum of positive and negative Numbers from column | SUMIF Function |Excel Formula | Excel Function

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

“Mastering VLOOKUP: A Comprehensive Guide to Excel’s Most Useful Function”

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

Microsoft added in MS Excel 6 new dynamic functions that automatically spill results into multiple cells

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

4 Simple (But Important) Things To Learn About Excel Formula Today()

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

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

Picture Lookup Excel Function for Show Photo From Excel Database using Index and Match Formula according Code or Name

Picture Lookup in Excel Usage of Picture Lookup –       Picture Lookup Help to show Photo from the database according Name or Code. Find Picture from large database only one click. If you have large data of employee in excel with images. You want to see photo of particular selected Employee entering his … Read more

Video Tutorial Excel Searchable List using Vlookup Formula

Video Tutorial Searchable List Using Vlookup Formula Searchable List Using Formulas – IF, SEARCH, VLOOKUP, IFERROR We Can Search Result with Name or Code. Trace Customer Balance or Any Criteria. Find any result using any searching criteria.