Data Cleansing with Excel
Choose the Training Option That Works Best for You
We offer two convenient delivery methods to suit your needs:
In-House Training: Perfect for organisations with four or more participants offering a cost-effective and flexible option. Training is delivered at your location and tailored to your needs. Contact us today to learn more or request a quote.
Public Training: Ideal for individuals or smaller teams (typically one or two learners) our public training sessions are scheduled regularly and open for registration. Register online today to secure your place!
Data Cleansing and Manipulation with Excel
This practical course is designed for professionals, analysts, and Excel users who want to enhance their data cleaning and manipulation skills using MS Excel enabling more accurate analysis and informed decision-making.
What will I learn?
In this one-day session, you will learn how to clean, transform, validate, and prepare data for analysis using Excel's built-in tools and functions:
- Identify and correct common data quality issues in Excel datasets.
- Clean and standardize text, date, and numeric data using Excel tools and functions.
- Remove duplicates and manage missing or inconsistent data effectively.
- Apply data validation techniques to improve data accuracy and consistency.
- Transform raw data into a structured, analysis-ready format for reporting and decision-making.
Through hands-on exercises, you'll gain practical experience in cleansing and transforming real-world datasets for better decision-making.
By the end of the course, you will have an understanding of the following topic areas:
|
Basic Data Cleansing Missing values Duplicate records Inconsistent formatting Blank rows and columns Sort and Filter Conditional Formatting Go To Special Find and Replace
Advanced Data Cleansing TRIM, CLEAN LEFT, RIGHT, MID, SUBSTITUTE IFERROR & ISERROR Text to Columns, Flash Fill CONCATENATE / TEXTJOIN |
Data Validation & Quality Control Data Validation Error Alerts Input Messages Formula Auditing
Introduction to Power Query Editor Data Profiling Remove Rows/Columns Find/Replace Data Types Duplicates Split columns
|
Is it for me?
If you wish to develop your skills in cleaning, organizing, and transforming data efficiently, then this course is for you. If you frequently deal with messy data or need to present insights clearly, then yes—this course is perfect for you!
Basic MS Excel knowledge is a prerequisite for this course.
Those wishing to progress to learn more about Data Visualisation should look at our Introduction to Power BI - Data Visualisation training course.
Those wishing to progress to learn more about Data Transformation and Modelling should look at our Power BI Intermediate training course.
.png)
.jpg)
Whether you're looking to develop a single team or roll out training organisation-wide we’ll work with you to ensure the programme/course(s) deliver maximum impact.
Interested? Contact us today to discuss in-house options.
-
LouiseLouise is an IT professional with over 22 years' experience in IT and telecommunications. During her career she has worked in IT consultancy, project management and as an in-house trainer.
Louise is an Associate with AKU Training and provides specialist IT training in Belfast including MS Excel, MS Word, MS Access, MS Project and marketing through Twitter and LinkedIn training.
Louise also runs her own IT consultancy in Belfast through which she operates as an IT consultant, mentor and IT trainer. She is an Accredited Microsoft Master Instructor and an accredited ECDL and Advanced ECDL Tester. She has worked as an Associate Lecturer with the Open University and a part-time lecturer with Castlereagh College and EDIFHE.
-
Data Cleansing with Excel - 16th September 2026
Date: 16 September 2026Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
-
Data Cleansing with Excel - 20th January 2027
Date: 20 January 2027Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
-
Data Cleansing with Excel - 30th September 2027
Date: 30 September 2027Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
Please note that the cancellation policy for our public training courses is as follows:
NON-ACCREDITED TRAINING
More than 3 weeks prior to the course start date - No cancellation fee payable.
Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.
ACCREDITED TRAINING
More than 6 weeks prior to the course start date - No cancellation fee payable.
Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.
Substitute delegates will be accepted at any time at no cost.
Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.
Download a copy of our standard Terms and Conditions for course bookings.
