Your cart is empty.
Keep shopping
Cleaning and Filtering Data in Excel 365
3 students
Cleaning and Filtering Data in Excel 365
Boost accuracy and efficiency by mastering data cleanup and filtering tools.
Created bySimon Sez IT
Last updated 9/2025
English
What you'll learn
- Select contiguous and non-contiguous data ranges using shortcuts.
- Insert and delete rows and columns with accuracy.
- Apply formatting changes to chosen ranges effectively.
- Remove duplicate entries to maintain clean data sets.
- Use filters to quickly sort and refine information.
- Apply advanced filter criteria for complex data analysis.
- Consolidate multiple worksheets into one unified dataset.
- Convert text-formatted numbers into usable numeric values.
- Remove unwanted spaces with the TRIM function.
- Replace specific text using the SUBSTITUTE function.
- Correct spelling errors with Excel’s built-in spell checker.
- Translate text into other languages within Excel.
Explore related topics
Course content
2 sections • 16 lectures • 35m total length
Requirements
- Have a basic understanding of navigating Excel (opening files, entering data, and saving work).
- Be comfortable using a computer.
- Have access to Microsoft Excel 365 installed on your device.
- No prior experience with data analysis or advanced Excel features is required.
Description
This course includes downloadable course instructor files to work with and follow along.
Cleaning and Filtering Data in Excel 365 gives you the skills to transform messy information into clear, accurate, and well-structured data. In this learning experience, you will discover how to work with ranges, clean up inconsistencies, and apply advanced tools that make your spreadsheets easier to manage and analyze.
You will start by practicing how to select, modify, and organize ranges of data, whether contiguous or non-contiguous, with quick mouse techniques and keyboard shortcuts. You will then learn how to insert, delete, and adjust rows and columns with precision, ensuring your worksheets remain neat and effective. From there, you will explore how to identify and remove duplicates, so your data remains accurate and efficient.
As you progress, you will apply advanced filtering to uncover patterns, outliers, and insights that standard filters may overlook. You will also work with data consolidation tools, combining information from multiple sources into one reliable view. In addition, you will gain essential text-cleaning skills, such as converting text-based numbers into real values, trimming unwanted spaces, substituting text, and correcting spelling errors. You will even learn how to translate content directly within Excel.
By the end, you will have practical, real-world strategies for cleaning and filtering data, saving time, and improving accuracy. With these skills, you will be able to confidently prepare data sets for analysis, reporting, or decision-making. This knowledge will not only boost your productivity but also make your spreadsheets more professional and impactful.
This course includes:
35 minutes of video tutorials
14 individual video lectures
Course instructor files to follow along
Certificate of completion
Who this course is for:
- Business professionals who regularly manage and analyze large datasets.
- Students and researchers who need accurate and well-organized data for projects or reports.
- Data entry specialists seeking to improve efficiency and reduce errors in spreadsheets.
- Administrative staff responsible for maintaining clean and structured records.
- Aspiring business analysts who want to build strong Excel data preparation skills.
- Anyone who wants to save time by cleaning and filtering information more effectively in Excel.