Concatenate vs & in Excel
When working with Excel, you probably noticed that there are two methods of joining strings. One of them is by using the ampersand…
When working with Excel, you probably noticed that there are two methods of joining strings. One of them is by using the ampersand…
In a PivotTable, you can group different types of values. I’ve written an article about grouping dates in PivotTables, so this one will…
In Excel, you can group and ungroup PivotTable dates in order to make data more readable. You can group dates by seconds, minutes,…
Sometimes, displaying a very precise number is not useful and you may want to round the value. But there may be cases when…
If you want a formula that inserts a text, instead of leaving blank cells, you can use the ISBLANK function. This function returns…
If you like a particular table formatting, but at the same time you want to treat data as a range, you can do…
If you have a list of percentage values and you want to get the average percentage of them, you can do it in…
Sorting PivotTable is useful, especially when you have to deal with large amounts of data. There are a few ways you can sort…
If you work with Excel, you probably tried to hide some rows or columns. It’s especially useful when you don’t need them at…
Calculating ranges is easy. But have you ever tried to calculate a range based on the number in a specific cell? In this…