Course Overview

Ranges and Data Cleanup gives you the skills to work confidently with data in Excel. You’ll learn to manage ranges, clean up messy information, and organize your spreadsheets for better results. Whether working with small tables or large datasets, these skills will help you save time and reduce errors.

You will practice selecting contiguous and non-contiguous ranges using clicks, drags, and helpful shortcuts. You’ll also learn how to insert or delete columns and rows, adjust column widths and row heights, and use the “Remove Duplicates” feature to tidy up your files. Advanced filtering methods help you apply multiple conditions, while outlining tools make it easy to collapse or expand sections for easier viewing.

The lessons also cover consolidating data from multiple sources into one clear summary, making your analysis faster and more accurate. By applying these techniques, you can present clear, well-organized, and easy-to-understand information.

With Ranges & Data Cleanup, you’ll have practical methods to improve productivity, keep your data accurate, and work more efficiently in Excel daily.

Learning Objectives:

In this course, you will learn how to:

  • Select and manage Excel data ranges effectively.
  • Use keyboard shortcuts for efficient data selection.
  • Insert and delete rows and columns confidently.
  • Adjust column widths and row heights accurately.
  • Apply 'Remove Duplicates' to clean up data.  
  • Implement advanced filtering for detailed analysis.
  • Utilize outlining tools for data management clarity.
  • Consolidate multiple datasets into one view.

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
9/12/2025
Duration
30 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • Yes
Downloadable Resources
  • Instructor Files
Completion Criteria
  • Visit all pages
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our
Privacy Notice.