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

Setting the printing options

This section will show you how to select basic printing options for a document, specify pages to print, and set properties for a document prior to printing. There are numerous methods to achieve the same result in Word 2019. We will concentrate on the most productive methods when dealing with page setup.

Changing the page margins

  1. Click on the Layout tab.
  2. Click on the Margins icon located under the Page Setup group.
  1. Select a format from the available predefined options (the default is the Normal setting):
  1. Click on Custom Margins... at the bottom of the list to control the adjustment of the margins.
  2. Adjust the margins by typing a value into the placeholder or using the spin arrows to move up and down to increase or decrease the margins in centimeters.

Changing the page orientation

There are two types of page orientation—Landscape and Portrait. When you create a new document, the page orientation is set to Portrait by default. The Landscape option is often used to accommodate large tables in Word documents or Excel reports with numerous columns:

To change the orientation, follow these steps:

  1. Click on the Layout tab in Word 2019, or the Page Layout tab if using Excel 2019.
  2. Choose Orientation, then select the desired layout—either Portrait or Landscape:

Changing the paper size

It is a good idea to check the paper size and make adjustments before creating or printing a document. Not doing so could lead to a number of formatting complications or problems when printing the document on the desired printer. Most printers use an A4 (210mm x 297mm) paper size and not Letter, as we will cover shortly. If your document does not print properly, always check this option first!

To change the paper size, follow these steps:

  1. Click on the Layout tab. From the Page Setup group, click on the drop-down arrow below the Size text:
  1. Choose the desired paper size from the list provided. In this case, we will choose an A4-sized paper. If you do not see your desired paper size in the list, choose More Paper Sizes… from the bottom of the list to access the Page Setup dialog box.

Changing the print options

Before printing a document, you should check the Print Layout view to see whether the page layout, margins, and document content looks professional:

  1. Click on the File tab to access the Backstage view, then select Print from the options provided:
  1. The settings on the Print backstage are the same in all of the Office applications, with only a few changes depending on whether you are printing a document, presentation, workbook, or worksheet. These are explained in the chapters dedicated to each topic throughout this book.

Setting the collate and page options

Collating is the sequence that you want multiple copies of a document to be printed in. For instance, if a document consists of six pages and you would like two copies of the document, you may wish to print page 1 of the document six times, then page 2, and so on. Alternatively, you may want to print pages 1 through 6 and then 1 through 6 again:

Go to the Settings option to instruct the document to print on both sides of the paper. This option can be accessed by selecting the drop-down arrow next to the Print One Sided heading. Select Manually Print on Both Sides from the list provided. You can also set options through the specific printer that you choose by going to the printer's options or by using the Print settings list, which can be accessed by going to File | Print within Word 2019.

Depending on the type of printer that is connected, the options will differ slightly, such as offering you the choice of printing automatically on both sides of the paper or even using different terminology for this feature, such as duplex printing.

Printing background colors and images

You can apply themes or include images to the background of your Microsoft Word documents. When printing documents with themes and images, you might notice that the background color or image doesn't print with the other document content. To fix this, follow these steps:

  1. Go to File | Options.
  2. From the Options dialog box, click on the Display heading.
  3. Locate the Printing options heading and select Print background colors and images:
  1. Click on OK to save the changes.

Setting pages to print

Often, you will need to fit more than one page from a document onto a landscape or portrait page. This option is great for booklet-, manual-, or brochure-type layouts. To select the number of pages to be included per sheet, go to the Settings section located at the bottom of the Print Settings list:

Note that if you are using PowerPoint or Excel, the options will be slightly different.

Inserting page breaks

At times, headings (or the first line of a paragraph) end up at the end of a page. These headings or paragraphs might need to be forced to the top of the next page. If you need to leave space for a particular graphic or chart at the end of a page, you can force a break at the desired position in the document. You can insert a page break or a blank page at any point in a document by taking these steps:

  1. Position the mouse pointer on the text that you want to force onto the next page. Alternatively, you can position your mouse at the start of the location where you want the space to be inserted:
  1. Click on the Breaks icon in the Layout tab or select the Page Break option from the Insert tab:
There is another method of inserting a forced page break via a keyboard shortcut key:
  1. Place the mouse pointer at the desired position in the document where you want to include a break.
  2. While holding down the Ctrl key on your keyboard, press the Enter key.