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

eLearning

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

Consultancy

Find out moreFind out more

Inductions | Migrations
New Processes | Best Practice

Systems Training

Find out moreFind out more
ALX Training / Excel / Excel – Data Cleansing

Excel – Data Cleansing

Audience

For individuals who need to clean & reorganise their data, remove errors and other inconsistencies. This session is for Excel users who need to split and re-join text, quickly change the layout of a spreadsheet and want to understand how macros can be used to speed up repetitive tasks.

Outcomes

Able to clean an Excel spreadsheet using both the data tools and by writing various text and date formulas

Course Content

Split text within a single cell into multiple cells,
Combine text from across multiple columns into a single column
Extract the first, middle or last part of cell contents to another location.
Identify, highlight and remove duplicates
Apply Flashfill to repeat patterns of data
Transpose data
Use all the data validation tools to prevent inputting errors
Find data types using the Go To command box
Record a very basic reformatting macro
Insert customised headers and footers

Duration

3 hours with lots of hands-on practical exercises

Includes

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

Price

£435 Maximum 8 delegates
£54 per additional delegate

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

Contact

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

    Or talk to us directly...

    +44  1534 873785
    +44  7797 774676
    [email protected]

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