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 Paste transposed in Excel and Keep Formula References! (Two great ways to achieve that!)
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 Find and Filter unique Values in Excel (Only 4 Simple Steps!)
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 AND/OR That (A 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 IF This Then That? (Quick Excel Tip!)
Duplicate information might be useful sometimes, but in most of the cases, it makes understanding of our data hard and not usable. Here we will take a look at how to easily spot Duplicate Data and Delete it from our Spreadsheet! Highlight Duplicate Cells First, we are going to look at How to Highlight Duplicate … Read more Find and Remove Duplicates in Excel! (2 Extremely easy tricks!)
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 Formula is not working … Read more Excel formulas are not working (8 Common Mistakes and Solutions)
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 Excel Formulas are not working, not updating & calculating (Quick and Easy fixes!)
Many times I myself faced this problem – Flip column data in Excel. It was extremely painful and inefficient to fill all the cells again by hand, that’s why I was so happy when I learned those two tricks! Flip data upside down using Sort command! This method requires us to create “help” column besides … Read more Flip Columns in Excel – 2 Extremely Quick and Easy Methods!
Photo editing Removing background from pictures is really common task. This is not something only bloggers have to do, there are lots and lots of times you will need to remove background from a picture. For example if you are creating Presentations, writing articles, creating videos, selling stuff online and much more! It is really … Read more How to Remove Background from Pictures Without Specialized Software? EASY!
The task? Have you ever tried to copy AutoCAD text objects to Excel? Usually when you copy an object from AutoCAD and copy it to excel it looks like a picture. If we double click on that picture AutoCAD automatically launches and opens fragment of our drawing which we have copied as a new .dwg … Read more Copy AutoCAD Text to Excel! A piece of Cake!