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...