Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Managing your address book with Excel
Equipment needed: Computer (desktop or laptop) running
Microsoft Excel 2010 or Microsoft Excel 2007 (see Introduction).
Skills needed: Ability to use a computer keyboard and mouse (or
trackball), and some experience with Word (see Chapter 1).
If you have a tattered old address book full of crossings out and amendments as
people have moved, or if your friends’ details are (dis)organised on scraps of
paper and old letters, then this project could change your life. In this chapter,
you’ll learn how to manage your address book using Excel, another program in
the Microsoft Ofﬁ ce suite. You’ll be able to update the details easily when
somebody moves, as well as ﬁ nd addresses and phone numbers more quickly. That will
make it easier to keep in touch with friends and family.
In this project, you’ll learn how to sort your address book, how to ﬁ nd information
in it easily and how to change the way it looks. If you prefer to keep your contacts
on paper, you’ll learn how to print it out so you can refer to it easily or tuck it into
Along the way, you’ll learn the basics of creating and navigating spreadsheets,
which will prepare you for the more advanced Excel projects in later chapters.
Many of the features of Excel are similar to Word, so I won’t bore you by repeating
them here. I’ll assume that you know how to start the program and what the