Learn Microsoft Office 2019: A comprehensive guide to getting started with Word, PowerPoint, Excel, Access, and Outlook

Publisher\'s note: This edition is based on MS Office 2019 and does not make use of the most recent features in MS Office 2021. A new second edition, updated for MS Office 2021 including new topics and the latest productivity feature enhancements for Office web and desktop has now been published.

Key Features

• Explore MS Office to enhance productivity and boost your professional development
• Get up and running with the new and improved features in Microsoft Office 2019
• Discover how to overcome common challenges when working with Office 2019 applications

Book Description

Learn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook. With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples.

You'll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge. You'll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features. Later chapters will focus on Access 2019, assisting you in everything from organizing a database to constructing advanced queries. You'll then get up to speed with Outlook, covering how to create and manage tasks, as well as how to handle your mail and contacts effortlessly. Finally, you'll find solutions to commonly encountered issues and best practices for streamlining various workplace tasks.

By the end of this book, you'll have learned the essentials of Office business apps and be ready to work with them to boost your productivity.

What you will learn

• Use PowerPoint 2019 effectively to create engaging presentations
• Gain working knowledge of Excel formulas and functions
• Collaborate using Word 2019 tools, and create and format tables and professional documents
• Organize emails, calendars, meetings, contacts, and tasks with Outlook 2019
• Store information for reference, reporting, and analysis using Access 2019
• Discover new functionalities such as Translator, Read Aloud, Scalable Vector Graphics (SVG), and data analysis tools that are useful for working professionals

Who this book is for

Whether you're just getting started or have used Microsoft Office before and are looking to develop your MS Office skills further, this book will help you to make the most of the different Office applications. Familiarity with the Office 2019 suite will be useful, but not mandatory.

Table of Contents

1. Exploring the Interface and Formatting Elements
2. Creating Lists and Advanced Table Construction
3. Creating Professional Documents
4. Versions, Restrictions, and Comparisons
5. The PowerPoint Interface and Presentation Options
6. Format Slides, Tables, Charts and Graphic Elements
7. Photo Albums, Sections, and Show Tools
8. Format, Manipulate and Present Data Visually
9. Applying Formula and Functions
10. Analyzing and Organizing Data
11. Exporting, Optimizing and the Browser View
12. Sharing and Protecting Files
13. Database Organization and Setting Relationships
14. Building Forms and Report Design
15. Constructing Queries to Analyze Data
16. Creating and Attaching Item Content
17. Managing Mail and Contacts
18. Calendar Objects, Tasks, Notes and Journal Entries

Linda Foulkes is a Senior Learning & Development Trainer at Knights. She is also a Microsoft Office Master Trainer, Certified Educator, and Microsoft Innovative Expert Educator with an educational and corporate background spanning 25 years. Linda is the author of our previous edition book, Learn Microsoft Office 2019. As well as being certified as an IT trainer, Linda represented South Africa at the Microsoft Global Forum in Redmond in 2015. She has certified students to compete at the Microsoft Office Specialist Championships in Texas, presented at conferences, and hosted Webinars, TeachMeets & MicrosoftMeets. She has a keen interest in e-learning and has developed e-learning paths and content for the Microsoft Office suite of programs.