Category: Tutorial

03
Jul
2021
Posted in Tips and Tricks Tutorial

LEFT, MID, RIGHT

Simple yet invaluable formulas to have in your kit!

05
Jun
2021
Posted in Tips and Tricks Tutorial

TRIM, CLEAN or SUBSTITUE

Get out of a sticky situation with some cleaning and trimming…

30
Dec
2020
Posted in Tips and Tricks Tutorial

What are all the $ signs for?

Master why and when to use $ in your formula with F4 – this is where the magic happens!

VLOOKUP typing
10
Dec
2020
Posted in Tutorial

VLOOKUP

Obtain data from a second dataset into your first one. A must learn formula!