Pivot Tables – how to utilise Excel better

What is a Pivot Table..? A Pivot Table is a powerful tool used to calculate, summarise and analyse data that lets you see comparisons, patterns and trends in your data – a pivot table helps you utilise Excel better. It will take a large amount of information and then...

Excel filters, freeze panes & sort

Are you someone who struggles with spreadsheets? Are they too big and very data heavy with data scattered all over them? There are many ways you can make these easier on the eye and also make the data you need to find more visible using simple basic features that are...

Conditional Formatting

Conditional Formatting This is simply formatting that automatically adjusts depending on the contents of the cells in a worksheet. Typical uses are to highlight important trends in your data i.e. a rise in a stock price, a sudden spurt in colleague/employee expenses...

How to make spreadsheets look more professional

There are many ways you can achieve a more professional look with your spreadsheets. Simple formatting such as creating borders can make the data range easier on the eye. You can choose whether you want to add a border to the whole range or you can just select certain...