When you are working with data in Excel, you may often find yourself needing to combine the results of two or more separate cell formulas into a single cell. This process is called concatenation. In...
Tag: formatting
Hello Excellers, welcome to another blog Excel post in my #ExcelTips 2021 series. Today let's look at why Excel Is changing the last digit of a number to zero. That's correct Excel changes the last...
Hi Excellers and welcome to another #Excel #FormulaFriday blog post in my 2020 series. Today let's look at how useful the PROPER Excel function. This little formula does what it...
Combine Conditional Formatting With An Excel Formula – Identifying Duplicate Values
Hello Excellers, welcome back to another blog in the #formulafriday series. Today let's look at how to combine conditional formatting with an Excel formula. What are we going to achieve...
Hello, Excellers. Today's blog post is a coffee break quick Excel tip for you. So, I was recently asked how to make Excel worksheet tabs stand out by changing their tab colour. In particular,...
To use a Pivot Table we usually need transactional data or a flat data table containing rows and columns of data, that is not summarised already. In my example below, the data already looks...