Here are seven ways how to find or remove duplicates in Excel that are helpful to do other necessary actions with data. For example, filtering, deleting, or fixing duplicates. Sometimes duplicates exist if there is something missing that makes records unique.
You can show numbers in thousands in Excel as K by using format code or additional calculations. It makes it easier to read large numbers in a table or chart. In the same way, you can display numbers in millions in Excel as M. If you can use calculations, you can divide numbers by 1000…
If you have a line chart with a lot of series, it is time-consuming to format all of them separately. Here are a couple of approaches to quickly change the weight for all series in an Excel line chart or do another formatting. For example, change all series colors at once or change dash type.
Stripchart in Excel is a great way to compare data points between multiple categories. It might be with or without additional jitter. Jitter in Excel chart helps to see overlapping data points more clearly. Here is how to create one step by step.
By default, you can not add text labels on Excel scatter chart axis, but here is a workaround that allows you to do that. You can change Excel scatter chart horizontal or vertical axis labels using a dummy series. Here is how to do that in a few simple steps.
If you feel inspired by the Gartner magic quadrant chart or there are other reasons, here is how to create a magic quadrant chart in Excel. Imitation of already existing visualization is a great way to learn new things with a definite goal in mind. You might have your metrics, but the main principle is…
It is a good idea to add conditional formatting to Excel PivotTable. PivotTable is a great tool to create flexible data summaries and conditional formatting. Flexible approach to get necessary accents. Here are 3 easy steps to add conditional formatting to Excel PivotTable and a few things to keep in mind.
If you have a data set with certain characteristics, you might want to take a chance and create a line chart with gradient color in Excel. Sometimes by coincidence, you can tell a better story. For example, if something is suddenly changing over time. Otherwise, color gradients are a rarely used formatting in Excel charts.