Excel Lesson 6: Working with Data

In this lesson, you will learn how to manage lists of information in Excel. You’ll begin by learning the proper way to arrange a list. Then you will learn how to sort records, apply filters to view selected records, and search a list. You will also learn how to remove duplicate entries from a list and how to extract records.
What you’ll learn in this lesson:
- • Entering data in a list
- • Sorting data
- • Using filters
- • Removing duplicates
- • Extracting data
Starting up
You will work with files from the Excel06lessons folder. Make sure you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.
Working with lists
With Excel, you can easily manage data in a list. After information is organized into a list format, you can find and extract data that meets certain criteria. You can also sort information in a list to put into a specific order, and you can extract, summarize, and compare data.
Database terms
A list, also known as a database, is information that contains similar sets of data, such as a phone directory. Information in a list is organized by categories or fields. Each column in a list contains a heading or field name that determines the type of information entered in that column. You enter ...