Learn Office XP Brief

John Preston is an associate professor at Eastern Michigan University in the College of Technology, where he teaches microcomputer application courses at both the undergraduate and graduate levels. He has been teaching, writing, and designing computer training courses since the advent of PCs, and he has authored and co-authored over 40 books on Microsoft Word, Excel, Access, and PowerPoint. He is a series editor for the Learn 97, Learn 2000, and Learn XP books. Two books on Microsoft Access he co-authored with Robert Ferrett have been translated into Greek and Chinese. He has received grants from the Detroit Edison Institute and the Department of Energy to develop Web sites for energy education and alternative fuels, and has also developed one of the first Internet-based microcomputer applications courses at an accredited university. He has a B.S. in physics, mathematics, and education from the University of Michigan, and an M.S. in physics education from Eastern Michigan University. His doctoral studies are in instructional technology at Wayne State University. Sally Preston is president of Preston & Associates, which provides software consulting and training. She teaches computing in a variety of settings, which provides her with ample opportunity to observe how people learn, what works best, and what challenges are present when learning a new software program. This diverse experience provides a complimentary set of information, which is blended into the Learn series books. Sally has been a co-author on the Learn series since its inception. In addition, she has authored books for the Essentials and Microsoft Office User Specialist (MOUS) Essentials series. Sally has an MBA from Eastern Michigan University and graduated magna cum laude. When Sally is away from her computer, she is often found planting flowers in her garden. Robert L. Ferrett is the director of the Center for Instructional Computing at Eastern Michigan University, where he provides computer training and support to faculty. He has authored or co-authored more than 40 books on Access, PowerPoint, Excel, Publisher, WordPerfect, and Word, and he was the editor of the 1994 ACM SIGUCCS Conference Proceedings. He has been designing, developing, and delivering computer workshops for nearly two decades, and is a series editor for the Learn 97, Learn 2000, and Learn XP books. He has a B.A. in psychology, an M.S. in geography, and an M.S. in interdisciplinary technology from Eastern Michigan University. His doctoral studies are in instructional technology at Wayne State University. As a sidelight, Bob teaches a four-week Computers and Genealogy class and has written books on genealogy and local history.

INTRODUCTION TO OFFICE 2002.

Lesson 1: Working with Windows and Managing Files.
Lesson 2: Common Elements in Office 2002.
Lesson 3: Working on the Web.
WORD 2002.

Lesson 1: Creating a Simple Document.
Lesson 2: Editing a Document.
Lesson 3: Formatting Text.
Lesson 4: Formatting a Document.
Lesson 5: Working with Tables.
EXCEL 2002.

Lesson 1: Learning the Basics of Excel.
Lesson 2: Formatting the Worksheet.
Lesson 3: Using Formulas.
Lesson 4: Understanding Numbers Using a Chart.
Lesson 5: Integrating Excel with Word and the Internet.
ACCESS 2002.

Lesson 1: Getting Started with Access.
Lesson 2: Creating a Customized Database.
Lesson 3: Modifying the Structure of a Database.
Lesson 4: Retrieving Information from Your Database.
Lesson 5: Integrating Access with Other Applications.
POWERPOINT 2002.

Lesson 1: Learning the Basics of PowerPoint.
Lesson 2: Working with Graphic, Audio and Video Elements.
Lesson 3: Sorting and Animating Slides.
Lesson 4: Integrating PowerPoint with Office and the Internet.