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.