file Archives | Page 39 of 45

Percentages in a PivotTable

In a PivotTable, you can create fields that will show you the percentage change of the previous value. This is especially popular in…

If you want to hide or unhide rows or columns, either to fit them on a screen or print your worksheet on a…

To check whether a cell contains specific text, you can use the SEARCH function. This function will return the position of the first…

While working with Excel, you may have noticed that sometimes the letter E appears in the calculation. In some cases, after the letter…

When you work in Excel, there are situations when you want to either show zero in some cases or hide zero in others….

If you want to check whether the particular date is between two other dates, you can easily do it in Excel. In the…

Percentages can be added or subtracted in Excel like any other value. You just need to remember that 100% = 1, 50% =…

Using VLOOKUP between two worksheets is very similar to using VLOOKUP on the same worksheet. We are going to use two sheets (Sheet1…

SHEET and SHEETS are two new functions that appeared in Excel 2013 and are also present in Excel 2019 and Excel 365. The…

Let’s take a look at the following table. There are four columns, first and last name, address, and zip code. In the two…