Blog

Want some regular tips & tricks to help you master your software?

Pop back regularly for articles to help.

joannabradley90

Jul 25, 20232 min read

Help! My VLOOKUP won't work.

Here are some common problems to consider. They may be the reasons why your VLOOKUP isn't working: 1. Data is not formatted as the same...

15 views

Joanne @ Paramount

Mar 21, 20233 min read

What is a Pivot Table?

The beauty of pivot tables are that they allow you to summarise and analyse data at a high level, quickly and easily. Whether you want to...

38 views

Joanne @ Paramount

Sep 8, 20221 min read

Useful Formulae for your Excel Spreadsheets

We often get asked ‘is there a list somewhere of formulas?’. Well, the answer is that if you check the FX button at the start of the...

53 views

Joanne @ Paramount

Jul 19, 20222 min read

Why should I use Pivot Tables?

The time has come for us to share our love of pivot tables and why you should feel the same! We often say that pivot tables are one of...

35 views

Joanne @ Paramount

Jun 30, 20222 min read

Let's Talk About Excel Conditional Formatting

We often hear people saying they use conditional formatting already, but usually they have only used the rules which apply to number...

18 views

Joanne @ Paramount

Mar 2, 20221 min read

ATTENTION: Messy Data Ahead!

You know the thing. Your colleagues aren’t quite as anal as you are about putting Capital Letters (!) and spaces in the same places as...

18 views