New Perspectives Microsoft® 365® & Office® Advanced, First Edition

Jennifer T. Campbell has written and co-authored several other leading technology texts, including TECHNOLOGY FOR SUCCESS; DISCOVERING COMPUTERS: DIGITAL TECHNOLOGY, DATA, AND DEVICES; DISCOVERING THE INTERNET; WEB DESIGN: INTRODUCTORY; MICROSOFT EXPRESSION WEB INTRODUCTORY CONCEPTS AND TECHNIQUES; COMPUTER LITERACY BASICS: MICROSOFT OFFICE 2007 COMPANION; and MICROSOFT OFFICE QUICK REFERENCE POCKET GUIDE. For over 25 years, she has served integral roles in computer educational publishing as an editor, author and marketing manager. She holds a Bachelor of Arts in English from The College of William and Mary. A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his Master of Science in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling. Ms. Ann Shaffer is the author of NEW PERSPECTIVES ON MICROSOFT® WORD 365 and has contributed to many other Cengage publications. She has more than 30 years of experience as a developmental editor and co-author of books, journal articles and multimedia in a variety of fields, including computer science, mathematics, history, engineering and social sciences. She holds a master’s degree in English from the University of Wisconsin-Madison.

WORD MODULES.
8. Customizing Word and Automating Your Work.
9. Creating Online Forms Using Advanced Table Techniques.
10. Managing Long Documents.
EXCEL MODULES.
9. Exploring Financial Tools and Functions: Analyzing a Business Plan.
10. Managing Data with Business Intelligence Tools.
11. Exploring PivotTable Design: Summarizing Sales and Revenue Data.
12. Developing an Excel Application: Creating a Data Entry App.
ACCESS MODULES.
9. Using Action Queries and Advanced Table Relationships.
10. Automating Tasks with Macros.
11. Using and Writing Visual Basic for Applications Code.
12. Managing and Securing a Database.
Appendix A: Relational Databases and Database Design.
POWERPOINT MODULES.
5. Integrating PowerPoint with Other Programs: Creating a Presentation for Resident Advisors.
6. Customizing Presentations and the PowerPoint Environment: Creating a Presentation for a Youth Center Upcycling Challenge.
Concepts Module: Planning, Developing, and Giving a Presentation: Preparing a Presentation for an Investment Company.