Recent Posts
Getting Fnkey with the Function key
Working with a colleague recently I noticed when locking formulas in Excel he was using the Function…
Double Vision
See two tabs of the same file at the same time! A must learn tip!
Tidying up Data
Quick links and tips for tidying up your data when in a pickle
Magical power of Text-to-Columns
A secret function of Text-To-Columns you don’t want to miss!
LEFT, MID, RIGHT
Simple yet invaluable formulas to have in your kit!
TRIM, CLEAN or SUBSTITUE
Get out of a sticky situation with some cleaning and trimming…
What are all the $ signs for?
Master why and when to use $ in your formula with F4 – this is where the magic happens!
Recent Comments