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

To get the most out of this book

You will need the Pro version of Microsoft Office 2019 to run the code for all the applications covered in this book, as well as access to a OneDrive account if you would like to take advantage of the online sharing and collaboration features of the suite.

Software/hardware covered in the book

OS requirements

Microsoft Office Professional 2019 or the following individual applications Windows 10 or macOS
Microsoft Word 2019 Windows 10 or macOS
Microsoft PowerPoint 2019 Windows 10 or macOS
Microsoft Excel 2019 Windows 10 or macOS
Microsoft Access 2019 Windows 10 or macOS
Microsoft Outlook 2019 Windows 10 or macOS

Alternatively, you can get Office 365 with the relevant apps as listed in the preceding table.

Download the example code files

You can download the example code files for this book from your account at www.packt.com. If you purchased this book elsewhere, you can visit www.packtpub.com/support and register to have the files emailed directly to you.

You can download the code files by following these steps:

  1. Log in or register at www.packt.com.
  2. Select the Support tab.
  3. Click on Code Downloads.
  4. Enter the name of the book in the Search box and follow the onscreen instructions.

Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:

  • WinRAR/7-Zip for Windows
  • Zipeg/iZip/UnRarX for Mac
  • 7-Zip/PeaZip for Linux

The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/Learn-Microsoft-Office-2019. In case there's an update to the code, it will be updated on the existing GitHub repository.

We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!

Code in Action

Download the color images

Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "Open the workbook called SSGRegions.xlsx."

Bold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "The Function Arguments dialog box will appear where the user is able to enter values as cell references to construct the formula."

Warnings or important notes appear like this.
Tips and tricks appear like this.