New Perspectives Microsoft® Office 365 & Office 2019 Advanced

Dr. Mark Shellman is an instructor and the Chair of the Information Technology Department at Gaston College in Dallas, North Carolina. Dr. Mark, as his students refer to him, prides himself on being student-centered and loves learning himself. His favorite subjects in the information technology realm include databases and programming languages. Dr. Mark has been teaching information technology for more than thirty years and has co-authored several texts in the New Perspectives Series on Microsoft® Access databases. 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. Katherine T. Pinard has more than 25 years of experience writing and editing books about computer concepts, applications, and technology. She has co-authored or contributed to more than 20 successful books and has edited or managed more than 60 titles. She is MOS certified in Word and PowerPoint.

Word 8: Customizing Word and Automating Your Work.
Word 9: Creating Online Forms Using Advanced Table Techniques.
Word 10: Managing Long Documents.
Excel 9: Exploring Financial Tools and Functions.
Excel 10: Analyzing Data with Business Intelligence Tools.
Excel 11: Exploring PivotTable Design.
Excel 12: Developing an Excel Application.
Excel Appendix A: Customizing Your Workspace Text and Graphics. (Digital Only).
Excel Appendix B: Introducing Power BI (Digital Only).
Excel Appendix C: Collaborating with Your Team. (Digital Only).
Access 9: Using Action Queries and Advanced Table Relationships.
Access 10: Automating Tasks with Macros.
Access 11: Using and Writing Visual Basic for Applications Code.
Access 12: Managing and Securing a Database.
Access Appendix A: Relational Database and Database Design (Digital Only).
PPT 5: Integrating PowerPoint with Other Programs.
PPT 6: Customizing Presentations and the PowerPoint Environment.
Index.