About This Chapter
Filter and Sort a Table in Excel: Chapter Summary
Once you've inputted your data into an Excel table, you may need to reorganize the information or remove duplicate records. Use the lessons in this chapter to see how easy it is to filter and sort your data into the format that best suits your needs.
This chapter includes multiple short video lessons that are taught by engaging, experienced instructors. The videos include animations and examples to help you learn, and multiple-choice quizzes are available at the end of each section to test your understanding of key concepts.
Topics covered in this chapter include:
- Filtering records and data
- Sorting data
- Removing duplicate data
(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)
Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.
1. How to Filter Records and Data in Excel
When you need to find specific information in an Excel spreadsheet, the Filter tool is an easy way to get information fast. This lesson will discuss the Filter tool in Excel and explain how to use the tool to narrow down the data in your worksheet.
2. How to Sort Data in Excel
Need to organize your spreadsheet? Have you added more and more data and now it's getting out of control? Sorting is likely the answer to your problem. This lesson will guide you through the steps to using the Sort feature in Excel.
3. Removing Duplicate Data in Excel
As you continue to add more information to your Excel spreadsheets, you may not realize that you have duplicate data. This lesson will guide you through the steps to finding and removing duplicate data in Excel.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Insert Data in Cells and Ranges in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel
- Create a Chart in Excel