How to use conditional formatting in Excel

Conditional formatting in Excel is one of my favourite features to use. I am a very visual person and would much rather look at colour charts or visual representations of data to give me a sense of what I’m looking at. Conditional formatting is the easiest way to achieve this result. I am always surprised […]

Create a custom number format to display phone numbers in Excel

Microsoft Excel provides various number formatting options which allows you to easily format numbers as currency, dates, percentages, time and even fractions. Occasionally you may run into a situation where the predefined number formats do not suit your needs for a range of data. This is where custom number formats can help you to create […]