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 says. It converts your text to it's 'proper' case. Essentially it will turn the first letter of each string to uppercase and following letters to lowercase. PROPER Function Syntax. =Proper(cell reference) OR =Proper("your text") Let's work through an example. See my sample data in the screen-shot below, "sales … [Read more...]
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 with that?. Well, we can easily identify duplicate values using the combination of these features. So let's take the problem that John has. He has two lists of guests to a retirement party. Another colleague of his has also been collating a list and John needs to identify duplicate names quickly and get one … [Read more...]
Change Colour Of Worksheet Tabs
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, this user wanted to colour code their regional sales areas with different colour worksheet tabs. You can see the requested result in the screenshot below. First of all to note is that the ability to change the colour of worksheet tabs was only introduced in Excel 2002 (Office XP). So if you … [Read more...]
Pivot The UnPivotable In Excel
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 summarized as it contains months across our data set which is always a giveaway! So what can we do about it, can we make this data 'pivotable'???. so we can carry out some analysis on it??? Sure we can, a neat trick is available....to take formatted summary data and transform it into transactional … [Read more...]
Break Your Pivot Table Filters Into Multiple Columns
Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used in my example below a standard Pivot Table with filters of Sales Person, Customer and Customer Type. Usually all of the filters are stacked on top of each other just like this.. Let's make it look a lot better!...well I think it looks a lot better when … [Read more...]
- 1
- 2
- 3
- …
- 6
- Next Page »
Recommended Excel Resources
