Ch 7: Filter and Sort a Table in Excel

About This Chapter

This collection of video lessons on Excel will show you how to filter and sort data and records. Follow the tips from our experts to master the skills for organizing tables.

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

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

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? 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.