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
- Exploring the Interface and Formatting Elements
- Creating Lists and Advanced Table Construction
- Creating Professional Documents
- Versions, Restrictions, and Comparisons
- The PowerPoint Interface and Presentation Options
- Format Slides, Tables, Charts and Graphic Elements
- Photo Albums, Sections, and Show Tools
- Format, Manipulate and Present Data Visually
- Applying Formula and Functions
- Analyzing and Organizing Data
- Exporting, Optimizing and the Browser View
- Sharing and Protecting Files
- Database Organization and Setting Relationships
- Building Forms and Report Design
- Constructing Queries to Analyze Data
- Creating and Attaching Item Content
- Managing Mail and Contacts
- Calendar Objects, Tasks, Notes and Journal Entries
Linda Foulkes is an L&D trainer at Knights plc. She is also a Microsoft Office Master Trainer, Microsoft Certified Educator, and Microsoft Innovative Expert Educator and Trainer with over 25 years of experience. In 2015, Linda represented South Africa at the Microsoft Global Forum in Redmond. She has certified and coached students who competed at the Microsoft Office Specialist Championships in Texas. She has published five training manuals and courseware for the Microsoft Office Specialist Certification and the ICDL Foundation SA. She has presented at conferences and webinars for SchoolNet SA, hosted TeachMeets and MicrosoftMeets, and developed e-learning paths for the Microsoft Office suite of programs, owing to her interest in e-learning.
