Overview
This course is designed for anyone who works with messy Excel files and wants to transform them into clean, professional, analysis-ready datasets. Inside companies, one of the biggest problems is not building reports themselves, but dealing with raw data full of errors, duplicates, inconsistent formats, blank cells, and messy text that make reports inaccurate and difficult to trust.
In this course, you will learn how to think professionally when working with raw data, how to identify issues before they affect dashboards and business decisions, and how to prepare data the right way before using it in Pivot Tables, Power BI, or any advanced reporting tool.
You will learn how to remove duplicates, clean text, fix extra spaces, standardize names and dates, split and combine text fields, and use essential tools like TRIM, CLEAN, SUBSTITUTE, Text to Columns, Remove Duplicates, and Data Validation.
The goal is not only to clean data but also to make it analysis-ready. You will learn how to build a complete data-cleaning workflow and checklist that can save hours of manual work and improve the quality of your reports.
The course is fully practical and based on real business scenarios and real company files. By the end of the course, you will start looking at messy data differently and know exactly how to turn it into structured, reliable, business-ready information.
In this course, you will learn how to think professionally when working with raw data, how to identify issues before they affect dashboards and business decisions, and how to prepare data the right way before using it in Pivot Tables, Power BI, or any advanced reporting tool.
You will learn how to remove duplicates, clean text, fix extra spaces, standardize names and dates, split and combine text fields, and use essential tools like TRIM, CLEAN, SUBSTITUTE, Text to Columns, Remove Duplicates, and Data Validation.
The goal is not only to clean data but also to make it analysis-ready. You will learn how to build a complete data-cleaning workflow and checklist that can save hours of manual work and improve the quality of your reports.
The course is fully practical and based on real business scenarios and real company files. By the end of the course, you will start looking at messy data differently and know exactly how to turn it into structured, reliable, business-ready information.
What you'll learn
✓
Clean duplicate records
✓
Remove spaces and common errors
✓
Use TRIM, CLEAN, and SUBSTITUTE
✓
Use Text to Columns
✓
Standardize data formatting
✓
Use Remove Duplicates and Data Validation
✓
Prepare data before Pivot Tables and Power BI
✓
Build analysis-ready datasets
Course Content
🎬 32 Lessons
⏱️ 2h 20m
Understanding Real Data Problems Inside Companies
Why Company Data Is Usually Messy
3:00
The Most Common Data Problems That Ruin Analysis
3:00
How Bad Data Impacts Reports and Decisions
3:00
Understanding Different Data Types
3:00
Cleaning Text and Extra Spaces
Removing Extra Spaces with TRIM
4:00
Cleaning Hidden Characters with CLEAN
4:00
Replacing Text with SUBSTITUTE
4:00
Using UPPER, LOWER, and PROPER
4:00
Standardizing Data and Formats
Standardizing Numbers and Date Formats
4:00
Converting Text to Numbers and Vice Versa
4:00
Standardizing Customer and Employee Names
4:00
Formatting Tables for Analysis
4:00
Splitting and Combining Text Data
Splitting Data with Text to Columns
5:00
Extracting Text with LEFT, RIGHT, and MID
5:00
Combining Text with CONCAT and TEXTJOIN
5:00
Preparing Full Names and Email Addresses
5:00
Removing Duplicates and Errors
Removing Duplicate Rows with Remove Duplicates
5:00
Finding Duplicate Values with Conditional Formatting
5:00
Handling Blank and Missing Cells
5:00
Handling Errors Like #N/A and #VALUE
5:00
Using Data Validation Professionally
Preventing Errors with Data Validation
4:00
Creating Professional Drop-Down Lists
4:00
Setting Allowed Input Limits
4:00
Showing Custom Warning Messages
4:00
Preparing Data for Analysis
Turning Raw Data into a Clean Table
5:00
Preparing Data Before Pivot Tables
5:00
Preparing Data Before Power BI
5:00
Creating a Data Cleaning Checklist
5:00
Final Cleaning Project
Cleaning a Sales File Full of Errors
5:00
Cleaning Employee and Customer Data
5:00
Standardizing Formats and Connecting Data
5:00
Final Project Walkthrough
5:00
Who should Enroll
Employees working with messy files
Data analysts
Reporting staff
Business owners
Anyone dealing with raw Excel data
Instructor
Ashraf Elsheikh
Founder & CEO of Elite Training & Consulting
Ashraf Elsheikh is the Founder & CEO of Elite Training & Consulting with more than 20 years of experience in training employees inside companies on Excel, Data Analysis, Power BI, Power Query, and AI. Over the years, he has helped professionals improve the way they think about reports, dashboards, business workflows, and decision-making using data.
5
Courses
125
Learners
Profile Page
Frequently Asked Questions
Is this course suitable if my data is messy and unorganized?
Yes, this course is designed specifically for people who work with messy files full of errors, duplicates, and dirty data.
Will I learn how to clean data before Power BI?
Yes, the course covers preparing data before using it in Pivot Tables and Power BI.
Will I learn Remove Duplicates and Text to Columns?
Yes, you will learn Remove Duplicates, Text to Columns, Data Validation, and other important cleaning tools.
Is the course practical?
The course is fully practical and based on real business datasets.
Will I receive a certificate?
Yes, you will receive a certificate after completing all required lessons.
Can I watch the course more than once?
Yes, you get lifetime access and can watch the lessons anytime.
