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 Study.com.

Summary:

Earning College Credit

Did you know… We have over 160 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.