Table of Contents

Office 1. Introduction to Microsoft Office 2016 Features
Excel Introduction to Microsoft Excel 2016 1. Creating a Worksheet and Charting Data 2. Using Functions, Creating Tables, and Managing Large Workbooks. 3. Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools 4. Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets 5. Managing Large Workbooks and Using Advanced Sorting and Filtering 6. Creating Charts, Diagrams, and Templates 7. Creating PivotTables and PivotCharts 8. Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas 9. Using Macros and Visual Basic for Applications 10. External Data, Database Functions, and Side-by-Side Tables 11. Collaborating with Others and Preparing a Workbook for Distribution

About the Author

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois  University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

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.

Debra Geoghan is currently an associate professor of computer and information science at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has earned certifications from Microsoft, CompTIA, Apple, and others. Deb has taught at the college level since 1996 and also spent 11 years in the high school classroom. She holds a B.S. in Secondary Science Education from Temple University and an M.A. in Computer Science Education from Arcadia University. Throughout her teaching career, Deb has worked with other educators to integrate technology across the curriculum. At BCCC, she serves on many technology committees, presents technology workshops for BCCC faculty, and runs a summer workshop for 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”.

Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College. She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.