## How to Use Transpose and Concatenate Together in Excel

We have covered the TRANSPOSE function earlier. This is an Excel formula that copies the text that is either horizontal or vertical and…

Posted On

## How to Return Multiple Values in One Cell in Excel

We often find ourselves in a situation where we want to have a different view of existing data. As you probably know, Excel…

Posted On

## How to Multiply Percentages in Excel

Excel is probably the best common tool to use when it comes to mathematical operations. In dealing with them, it is all about…

Posted On

## How to Use Countif with Dates in Excel

COUNTIF is a very useful Excel function that counts the number of times cells that have some common parameter appear in a range….

Posted On

## Calculate Percentage Difference Between Two Numbers in Excel

Excel is probably the most widely used tool for calculations and reporting. It is very useful for calculating and visually presenting numbers, their…

Posted On

## How to Change Month from Text to Number in Excel

Excel has many helpful tips and tricks that people are usually not aware of. One of them is to convert the name of…

Posted On

## How to Return Value in Excel If Cell Is Blank

With Excel, we can manipulate numbers and data in any way possible. There are often cases when we have blank spaces in our…

Posted On

## How to Use Index Match in Multiple Sheets in Excel

INDEX and MATCH are two functions that are most often used together. They are far superior that the VLOOKUP function that is maybe…

Posted On

## How to Apply Percentage Formula in Multiple Cells in Excel

Excel is, like all computer programs, perfect for performing various arithmetic and mathematical functions. One of these functions is to calculate a percentage…

Posted On

## How to Concatenate Date in Excel

More often than not, we can find ourselves in a situation where we need to merge our text in different cells into one…

Posted On