Is there an easy way to locate and highlight duplicates in a list in Excel?
If you just want to remove the duplicates, the easiest way is to use the Advanced Filter or the built-in Remove Duplicates feature on the Data ribbon, but what if you want to find the duplicates in the list, keep them and highlight them with a different colour? That almost sounds like a job for a professional Excel consultant, but there’s no need for that – you can easily do it yourself! I’ll show you one easy way and one super-easy way:
Why do Excel charts usually look so ugly? Ok, they look a lot better in newer versions of Excel than they did before, but you still need to make a few changes if you want them to look good enough for a presentation.
These are the 5 things you need to do to make your Excel chart look professional:
An Excel table with a lot of numbers in it can be difficult to read. Often, a lot of the numbers are zeros, and it is sometimes a good idea to hide them in order to make the important numbers more visible. Of course, you could write IF-formulas that return nothing if the result is zero, but usually the way I am going to show here is better and easier.
This is what my table looks like:
In a previous post we learned how to make an Excel drop-down menu in 3 minutes. In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell. It’s easy, and it only takes five minutes!
Step 1: Enter the data
It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings.
Even if you have never used Microsoft Excel before, it only takes 5 minutes to learn how to make a simple report. Once you have done the exercise below, you will be able to create your own sales reports, commission reports, or household budget.
In this post we will create a sales report in 5 steps. You will be amazed by how easy it is!
Let’s get started!