Office 2019 All-in-One For Dummies

Peter Weverka

• Publisher: For Dummies
• Year: 2018
• Print ISBN: 9781119513278
• eBook ISBN: 9781119513308
• Edition: 1
• Topic: Computer Science
• Subtopic: Desktop Applications
• Index: Computer Science

One practical book that's ten books in one: Learn everything you need to know about Microsoft Office with one comprehensive guide on your bookshelf

To know your way around all the applications within Microsoft Office would require you to be part mathematician, part storyteller, and part graphic designer--with some scheduling wizard and database architect sprinkled in. If these talents don't come naturally to you in equal measure, don't panic-- Office 2019 All-in-One For Dummies can help.

This hefty but easily accessible tome opens with Book 1, an overview of the Office suite of applications and tips for handling text and becoming more efficient. From there, you'll find a book on each of the suite's major applications:

• Word: Learn the basics of word processing with Word, plus lay out text and pages; use Word's styles and proofing tools; construct tables, reports, and scholarly papers; and become familiar with manipulating documents.
• Excel: In addition to refining your worksheets so they're easier to understand, you can also master formulas, functions, and data analysis.
• PowerPoint: Find out how to make your presentations come alive with text, graphics, backgrounds, audio, and video. This book also contains a chapter with guidance and tips for delivering presentations--in person or virtually.
• Outlook: From helping you to manage your contacts, inbox, calendar, and tasks, Outlook can organize your days and keep you working productively.
• Access: Not everyone needs to build and maintain databases, but if that's part of your job, this book has all the hands-on information you need to get going: Build a database table, enter data, sort and query data, and filter data into report format.
• Publisher: The Publisher book is a quick-and-dirty introduction into desktop publishing, helping you to design a publication using built-in color schemes, templates, fonts, and finishing touches like borders and backgrounds.

The last three books cover material that applies to all the applications. Book 8 shows you how to create charts, handle graphics and photos, and draw lines and shapes. Book 9 provides a quick primer on customizing the Ribbon, the Quick Access toolbar, and the Status bar, and guidance on distributing your work (via printing, emailing, converting to PDF, and more). Finally, Book 10 wraps up with how to use OneDrive, especially for file sharing and online collaboration.

If you need to make sense of Office and don't have time to waste, Office 2019 All-in-One For Dummies is the reference you'll want to keep close by!

Book 1

Common Office Tasks

Contents at a Glance

1. Chapter 1: Office Nuts and Bolts
   1. A Survey of Office Applications
   2. All about Office 365
   3. Finding Your Way Around the Office Interface
   4. Saving Your Files
   5. Navigating the Save As and Open Windows
   6. Opening and Closing Files
   7. Reading and Recording File Properties
   8. Locking a File with a Password
   9. Trusting (or not Trusting) Microsoft with Your “Content”
2. Chapter 2: Wrestling with the Text
   1. Manipulating the Text
   2. Speaking, not Typing, the Words
   3. Changing the Look of Text
   4. Quick Ways to Handle Case, or Capitalization
   5. Entering Symbols and Foreign Characters
   6. Creating Hyperlinks
3. Chapter 3: Speed Techniques Worth Knowing About
   1. Undoing and Repeating Commands
   2. Zooming In, Zooming Out
   3. Viewing a File Through More Than One Window
   4. Correcting Typos on the Fly
   5. Entering Text Quickly with the AutoCorrect Command

Chapter 1

Office Nuts and Bolts

IN THIS CHAPTER

Introducing the Office applications

Exploring the Office interface

Opening, saving, and closing an Office file

Clamping a password on a file

Chapter 1 is where you get your feet wet with Office 2019. Walk right to the shore and sink your toes in the water. Don’t worry; I won’t push you from behind.

In this chapter, you meet the Office applications and discover speed techniques for opening files. I show you around the Ribbon, Quick Access toolbar, and other Office landmarks. I also show you how to open files, save files, and clamp a password on a file.

A Survey of Office Applications

Office 2019, sometimes called the Microsoft Office Suite, is a collection of computer applications. Why is it called Office? I think because the people who invented it wanted to make software for completing tasks that need doing in a typical office. When you hear someone talk about “Office” or “Office software,” they’re talking about several different applications. Table 1-1 describes the Office applications.

TABLE 1-1 Office Applications

Application	Description
Word	A word processor for writing letters, reports, and so on. A Word file is called a document (see Book 2).
Excel	A number cruncher for performing numerical analyses. An Excel file is called a workbook (see Book 3).
PowerPoint	A means of creating slide presentations to give in front of audiences. A PowerPoint file is called a presentation, or sometimes a slide show (see Book 4).
Outlook	A personal information manager, scheduler, and emailer (see Book 5).
Access	A database management application (see Book 6).
Publisher	A means of creating desktop-publishing files — pamphlets, notices, newsletters, and the like (see Book 7).

Windows 10 must be installed on your computer to run Office 2019 applications. The applications don’t run on computers running earlier versions of the Windows operating system.

Microsoft offers many different versions of Office 2019, some aimed at home users and some at business users. Not all versions of Office 2019 have Outlook, Access, and Publisher. Visit this web page to compare and contrast the different versions of Office:

https://products.office.com

Follow these steps to find out which Office 2019 applications are installed on your computer:

1. Open any Office 2019 application.
2. Click the File tab.
   This tab is located in the upper-left corner of the screen. The Backstage window opens after you click the File tab.
3. Select the Account category.
   As shown in Figure 1-1, the Account window opens. Under “This Product Contains” is an icon for each Office application that is installed on your computer.
4. Click the Back button when you finish gazing at the Account window.
   The Back button, a left-pointing arrow, is located in the upper-left corner of the Account window.

FIGURE 1-1: The Account window tells you which Office applications are installed.

If you’re new to Office, don’t be daunted by the prospect of having to study so many different applications. The applications have much in common, with the same commands showing up throughout. For example, the method of choosing fonts is the same in Word, Outlook, PowerPoint, Excel, Access, and Publisher. Master one Office program and you’re well on your way to mastering the next.

All about Office 365

Office 365 is the name of Microsoft’s online services division. To run Office 2019 software on your computer, you need an Office 365 account or a standalone version of the Office 2019 software.

As of this writing, Microsoft offers these Office 365 subscriptions:

• Home edition: For households, you can install Office on five computers. The cost is $99.99 per year or $9.99 per month.
• Personal edition: For an individual, you can install Office on one computer. The cost is $69.99 per year or $6.99 per month
• Business edition: For businesses, prices vary from $8.25 per user per month to $12.50 per user per month.

An Office 365 Home subscription entitles you to these goodies:

• The opportunity to install Office 2019 on five computers.
• The opportunity to install Word, Excel, and PowerPoint on five iPads and/or Windows tablets.
• Automatic updates to the Office software on your computer. As long as your subscription is paid up, Microsoft updates the Office software...

Table of contents

• Cover
• Table of Contents
• Introduction
• Book 1: Common Office Tasks
• Book 2: Word 2019
• Book 3: Excel 2019
• Book 4: PowerPoint 2019
• Book 5: Outlook 2019
• Book 6: Access 2019
• Book 7: Publisher 2019
• Book 8: Working with Charts and Graphics
• Book 9: Office 2019: One Step Beyond
• Book 10: File Sharing and Collaborating
• Index
• About the Author
• Connect with Dummies
• End User License Agreement