Book Image

Learn Microsoft Office 2019

By : Linda Foulkes
Book Image

Learn Microsoft Office 2019

By: Linda Foulkes

Overview of this book

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.
Table of Contents (26 chapters)
1
Section 1: Word
6
Section 2: PowerPoint
10
Section 3: Excel
14
Section 4: Common Tasks
17
Section 5: Access
21
Section 6: Outlook

Summary

You have certainly learned an abundance of skills throughout this chapter. Now, you can confidently use the Excel 2019 interface, having a thorough knowledge of all parts of the work area, and are able to set customization options and fine-tune the QAT and the ribbon. You are able to input data and understand the various formatting options with regard to rows, columns, cells, worksheets, and workbooks.

Importing and exporting data should now be a simple task, and manipulating data using sort and filter capabilities will be a skill to take to new heights. You have also learned all about printing and the options available to set up a worksheet or workbook for the printing process, and should now be able to create and format professional-looking charts.

In the next chapter, you will learn all about the heart of the Excel 2019 application. You will learn to create basic formulas...