Microsoft Excel
Paste Transposed in Excel and Keep Formula References! (Two Great Ways to Achieve that!)
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...
Microsoft Excel
Find and Filter unique Values in Excel (Only 4 Simple Steps!)
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...
Microsoft Excel
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...
Microsoft Excel
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...
Microsoft Excel
How to Find and Remove Duplicates in Excel! (2 Easy Tricks!)
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...
Microsoft Excel
Excel formulas are not working (8 Common Mistakes and Solutions)
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...
Microsoft Excel
Excel Formulas are not working, not updating & calculating (Quick and Easy fixes!)
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...
Microsoft Excel
Flip Columns in Excel - 2 Extremely Quick and Easy Methods!
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...
Microsoft Excel
How to Remove Background from Pictures Without Specialized Software? EASY!
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...
AutoCAD Tips