Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?. If you ever have tried to correct this then you know you could try to adjust the formatting of the cell. But, that just ends up looking like the screenshot below right?. Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]
Quick Way To Remove Blanks -Excel Data Tidy Up.

Hello, Excellers. Welcome to another Excel Tips post in my 2021 series. In this blog post, I will share with you how to quickly remove blanks or spaces from your data set. This super quick method in Excel is great for data tidy up. The Paste Special function is used. So, let's get some data tidy up done. Here is a sample data set to use. Some blanks still remain from a previous data tidy up step. These probably have been left from a previous step in the process of data tidy … [Read more...]
Remove Duplicates With Power Query.
by Barbara

Hello Excellers. Today I will share with you a great Excel tip. How to remove really quickly duplicate data records using Power Query. Power Query (previously called Get & Transform) in Excel 2016 is a really easy way to manage your data, and removing duplicate records is one of those easy tasks. See a sample set of Excel data in the screen grab below. Let's take a look at how easy it is to use Power Query to resolve the duplicate rows of data by following the steps … [Read more...]
How To Use The Quick Analysis Tool In Excel.
by Barbara

From Excel 2013 onwards, the quick Analysis Tool makes it really easy to analyse your data quickly and easily. It contains a variety of Excel tools. The tool can be used with data from a range of cells or an Excel data table. How To Access The Quick Analysis Tool. So, it is really easy to get started with the Quick Analysis tool. Once you select a range of cells or an Excel data table, the tool appears at the bottom right of your data set. A range of analysis tools is now available to … [Read more...]
How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel
by Barbara

Most Excel users would be used to working with the concept of displaying negative numbers in a worksheet with a preceding - sign in front of the number, something a bit like this below, where I have an example of monthly sales and the diference month on month of those sales figures. The negative differences are easy to see. So, how about making the positive numbers just as identifiable with a + sign in front of the numbers. It is really easy in Excel to create these formats using the … [Read more...]