GO! with Microsoft Office 2013 Volume 2

Shelley Gaskin, Series Editor, is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor’s degree in Business Administration from Robert Morris College (Pennsylvania), a master’s degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector, and has also written and edited numerous computer application textbooks. Carol L. Martin is recently retired from the faculty at Harrisburg (Pennsylvania) Area Community College. She holds a bachelor’s degree in Secondary Education—Mathematics from Millersville (Pennsylvania) University and a master’s degree in Training and Development from Pennsylvania State University. For over 40 years, she has instructed public school students and educators in the use of various computer applications. She has written and edited a variety of textbooks dealing with Microsoft Office applications and has co-authored several training manuals for use in Pennsylvania Department of Education in-service courses. Debra Geoghan is a professor in the Science, Technology, Engineering, and Mathematics (STEM) Department at Bucks County Community College in Pennsylvania where she is coordinator of the Computer Science area. Deb teaches computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She holds a B.S. in Secondary Science Education from Temple University and an M.A. in Computer Science Education from Arcadia University, and has earned certifications from Microsoft, CompTIA, and Apple. Deb has taught at the college level since 1996 and also spent 11 years in the high school classroom. Throughout her teaching career Deb has worked with educators to integrate technology across the curriculum. At Bucks she serves on many technology committees, presents technology workshops for faculty, and runs a summer workshop for local K-12 teachers interested in using technology in their classrooms. Deb is an avid user of technology, which has earned her the nickname “gadget lady.” Nancy Graviett is a professor in the Business and Computer Science department at St. Charles Community College in Cottleville, Missouri, where she is the program coordinator for the Business Administrative Systems program and teaches within the program. Nancy is also very active with distance learning and teaches in face-to-face, hybrid, and online formats. She holds a master’s degree from University of Missouri. Nancy holds Microsoft® Certified Application Specialist certification in multiple applications and provides training both on and off campus. In her free time, Nancy enjoys quilting and spending time with family and friends. Suzanne Marks is a faculty member in Business Technology Systems at Bellevue Community College, Bellevue, Washington. She holds a bachelor’s degree in Business Education from Washington State University, and was project manager for the first IT Skills Standards in the United States.

Brief Contents
GO! Walk-Through

Office
Chapter 1 Introduction to Microsoft Office 2013 Features 1

Word
Chapter 4 Using Styles and Creating Multilevel Lists and Charts 49
Chapter 5 Using Advanced Table Features 97
Chapter 6 Building Documents from Reusable Content and Using Markup Tools 147

Excel
Chapter 4 Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets 201
Chapter 5 Managing Large Workbooks and Using Advanced Sorting and Filtering 261
Chapter 6 Creating Charts, Diagrams, and Templates 321

Access
Chapter 4 Enhancing Tables 375
Chapter 5 Enhancing Queries 437
Chapter 6 Customizing Forms and Reports 497

PowerPoint
Chapter 4 Creating Templates and Reviewing, Publishing, Comparing, Combining, and Protecting Presentations 555
Chapter 5 Applying Advanced Graphic Techniques and Inserting Audio and Video  15
Chapter 6 Delivering a Presentation  671
Glossary  G-1
Index