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)...
Tag: excel tutorials
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...
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 is a powerful tool for data analysis and presentation. With its built-in formulas and functions, you can create complex reports and graphs with just a few clicks. However, even the most...
How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel
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...
Excel Charting Tip- How To Create A Sales Funnel Or Pipeline Chart
Sales Funnel or Pipeline charts are increasingly used in Business Intelligence packages and are part of data visualisation on dashboards on a regular basis by most businesses. Even though...