3 hour Excel & Word Sessions | Beginner to Advanced
£100pp (excl GST)

Open Courses

Book nowBook now

We can create content for Inductions,
Micro Learning modules and Training Videos


Find out moreFind out more

3 fully equipped rooms
£45 per hour | Daily rates available

Room Hire

Find out moreFind out more

Inductions | In-house systems
Support | Project Work


Find out moreFind out more

Inductions | Migrations
New Processes | Best Practice

Systems Training

Find out moreFind out more
ALX Training / Excel / Excel: Cleaning Data

Excel: Cleaning Data

The Need:

To review & clean an Excel spreadsheet
To take raw data and change how it is presented
To highlight & remove duplicates
To find hidden formulas, formats, errors & blank cells

You will learn how to:

Use text to columns & Flashfill to split data
Use Flashfill & CONCAT formulas to join data
Write TRIM, PROPER, LOWER & UPPER formulas
Find, highlight & remove blank cells & duplicates
Transpose data
Use Go To Special box
Write FIND, LEFT, LEN, RIGHT & MID formulas
Record a very basic reformatting macro to clean data


The course can be delivered online or face to face in our training centre or at your place of work. If you would like to have this class online, you will need access to two screens, a webcam, speakers & a microphone


You need to be familiar with content covered in The Essentials


All training spreadsheets for future practice
Full colour booklet to accompany the lesson


£479 for up to 6 delegates
£79.83 for each additional place

[contact-form-7 404 "Not Found"]


Fill out the form below to discover how ALX Training can help you:

    Or talk to us directly...

    +44  1534 873785

    Hilary House
    19 Hilary St
    St Helier, Jersey
    JE2 4SX