Great Microsoft Excel Tips for everyone!
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
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
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
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
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
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
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