Pivot Tables – how to utilise Excel better

What is a Pivot Table..? A Pivot Table is a powerful tool 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 it...

Online training – is it the future…?

The ways to learn have changed/evolved over recent years and as a result of the current situation this is likely to have a bigger effect – the options for learning, therefore, need to be increased. For people like me, aged 40+, we’ve been through a lot of...

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