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

New Year, New Services 2020

Do you find yourself saying yes to any of these:- • I work with people who struggle with IT tasks• I have a family member or clients that would benefit from some basic IT training• I have clients / customers that could do with some simple money management / budgeting...

Excel filters, freeze panes & sort

Are you someone who struggles with spreadsheets? Are they too big and very content-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...

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