Office 2013 Digital Classroom

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