Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 6: Working with Data

ex06.psd

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther