Paste Transposed in Excel and Keep Formula References! (Two Great Ways to Achieve that!)

Transpose formulas in excel

In Excel, the paste as transpose is extremely useful for transposing a column to a row or vice versa. But if there are formulas in the cells, the reference will change and mess up our desired values. In this post, we will show you, two easy methods on how to paste as transpose and keep … Read more

Find and Filter unique Values in Excel (Only 4 Simple Steps!)

Filter unique values in Excel!

We discussed how to Find and Remove Duplicates in Excel! What if we are not sure if the data won’t be needed later on. This is why a good rule of thumb will be to first Filter and Highlight the Duplicate data and Remove it when we are sure this is the result we want. … Read more

If This AND/OR That (A Quick Excel Tip)

We’ve already discussed the use of IF function in Microsoft Excel. Today we will dive a little bit deeper. AND Function in EXCEL! What If we want to check if more than one conditions are TRUE? In this case, we will use AND function. Best way to describe the way AND works is to show … Read more

IF This Then That? (Quick Excel Tip!)

We all know how useful Microsoft Excel can be. And one of the most used and easy to remember functions is IF. Many of us are not software developers, but in school or college have used function IF in one form or another, maybe in Pascal or C++. The same function can be found in … Read more

How to Find and Remove Duplicates in Excel! (2 Easy Tricks!)

Learn how to Find And Delete Duplicate cells in Excel

Duplicate information might be useful sometimes, but in most of the cases, it makes the understanding of our data hard and not usable. Here we will take a look at how to easily spot Duplicate Data and Remove it from our Excel Spreadsheet! Highlight Duplicate Cells First, we are going to look at How to … Read more

Excel formulas are not working (8 Common Mistakes and Solutions)

8 common mistakes when using excel formulas

The biggest nightmare that we as professionals who use Microsoft Excel may have is not to be able to use Formulas in our spreadsheets. We have already discussed why Excel Formulas are not working, not updating & calculating or showing formula instead of the result. Today we will look at why a Formula is not … Read more

Excel Formulas are not working, not updating & calculating (Quick and Easy fixes!)

Excel formulas not updating

When we talk about Microsoft Excel the first things that come to mind are Excel’s formulas and functions. Can you imagine a case when formulas stop working? Well if you are here maybe you have asked questions like: Why formula is not updating its value automatically? Is my Excel or PC broken? How to make … Read more