|
Published:
October 30, 2018

Office 2019 All-in-One For Dummies

Overview

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!

    Read More

    About The Author

    Peter Weverka is a veteran tech writer and long-time For Dummies author. Among his credits are Office 2016 All-in-One For Dummies and Windows 10 For Seniors For Dummies, both top sellers in their respective categories.

    Sample Chapters

    office 2019 all-in-one for dummies

    CHEAT SHEET

    Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.Speedy ways to open Office 2019 filesIn the interest of getting to work faster, Office 2019 (and Windows 10) offers these speed techniques for opening files: Backstage: Click the File tab in any Office application to open what Microsoft calls the backstage.

    HAVE THIS BOOK?

    Articles from
    the book

    For your pleasure and entertainment, here are six useful types of queries you can perform in Microsoft Access. Access 2019 offers a handful of other queries, but these are common queries. Those queries are pretty complicated. If you become adept at querying, however, you’re invited to look into the Help system in Access for advice about running the query types that aren’t explained here.
    Want to play interior decorator with Word, Excel, PowerPoint, Outlook, Access, and Publisher? Follow these steps to change the look of the Office 2019 application screens: In any Office application, go to the File tab and choose Account. The Account window opens. Choose an Office Background option. These options — Clouds, Spring, Underwater, and others — place a faint design motif in the upper-right corner of screens.
    Every Word document you create is fashioned from a template. The purpose of a template is to store styles for Word documents. In the act of creating a document in Word 2019, you choose a template, and the styles on the template become available to you when you work on your document.For example, when you select Blank Template in the New window or press Ctrl+N (see here for additional Word 2019 shortcuts), you create a document with the Blank Document template, a relatively simple template with few styles.
    The Quick Access toolbar is always there in the upper-left corner of Office applications. This toolbar offers the AutoSave, Save, Undo, and Redo buttons, as well as the Touch/Mouse Mode button if your computer has a touchscreen. Put your favorite buttons on the Quick Access toolbar to keep them within reach: Right-click a button and choose Add to Quick Access Toolbar on the shortcut menu.
    It happens. Everyone makes an error from time to time when entering Excel formulas in cells. Especially in an Excel 2019 worksheet in which formula results are calculated into other formulas, a single error in one formula can spread like a virus and cause miscalculations throughout a worksheet. To prevent that calamity, Excel offers several ways to correct errors in formulas.
    Excel does lots of super cool things. In order to see them in all their glory, you need to understand how to work with Excel formulas. A formula, you may recall from the sleepy hours you spent in math class, is a way to calculate numbers. For example, 2+3=5 is a formula. When you enter a formula in a cell, Excel computes the formula and displays its results in the cell.
    PowerPoint 2019 isn’t just a powerful tool for delivering presentations (although it definitely is that), it’s also a good way to deliver a spiel to a remote audience. How do you deliver your PowerPoint presentation from a separate location? Let’s count the ways that you can deliver a presentation without being there in person: Deliver your presentation in the form of a handout, a printed version of the presentation with thumbnail slides.
    Every picture can be a collaboration with Office 2019. You can do the following using Office 2019 tools to make a picture your own as well as the work of the original artist: Softening and sharpening: Mute or polish a picture. Changing the brightness and contrast: Adjust a picture’s tone. Recoloring: Give your picture a brand-new set of colors or gray shades.
    Unfortunately, entering the data in an Access database table is one of the most tedious activities known to humankind. And because the activity is so dull, people are prone to make mistakes when they enter data in an Access 2019 database table. One way to cut down on mistakes is to take advantage of the Field Properties settings on the General tab in the Design view window.
    Here you find a handful of neat table tricks to make your Word 2019 tables stand out in a crowd. Word 2019 has what you need to make unique content. Why should all tables look alike? Read on to discover how to make text in the header row stand on its ear, wrap text around a table, put a picture behind a table, draw diagonal border lines, draw on top of a table, and wrap text around a table.
    Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.Speedy ways to open Office 2019 filesIn the interest of getting to work faster, Office 2019 (and Windows 10) offers these speed techniques for opening files: Backstage: Click the File tab in any Office application to open what Microsoft calls the backstage.
    In this day of superhero pop culture, you need a handful of Office 2019 chart tricks to impress your friends and intimidate your enemies. Here, you discover how to make your Office 2019 charts roll over and play dead. You also find out how to decorate a chart with a picture, annotate a chart, display worksheet data alongside a chart, and create a combo chart all using tools in Office 2019.
    In the interest of serving you better with Office 2019, Microsoft wants to see your content. Content (Microsoft’s word, not mine) refers to the words, numbers, and other data in Office 2019 files. If Microsoft’s artificial intelligence (AI) software can read your content, the thinking goes, Microsoft can improve your Office experience.
    Getting rid of unneeded items in Outlook folders is essential for good mental health. All that clutter in your Outlook inbox can be distressing. This information explains two more techniques for organizing your Outlook 2019 email and removing detritus from folders — archiving and the Mailbox Cleanup command. Archiving the old stuff in your Outlook inbox In some cases, Outlook puts email messages, tasks, and appointments older than six months in the Archive folder, a special folder for items that Outlook thinks are stale and not worth keeping anymore.
    In the interest of getting to work faster, Office 2019 (and Windows 10) offers these speed techniques for opening files: Backstage: Click the File tab in any Office application to open what Microsoft calls the backstage. From there, you can quickly open files: On the Home window (go to the Home category), click the name of a file in the Recent list or Pinned list.
    Being an Access database designer isn’t nearly as glamorous as being a fashion designer, but it has its rewards. If you design your Access database carefully and correctly, it can be very useful to you and others. You can enter information accurately. When the time comes to draw information from the database, you get precisely the information you need.
    Outlook 2019 offers the Reminder message box to alert you when an appointment or event from the Outlook Calendar is about to take place, when a task deadline is looming, when an email message needs a reply, or when someone whose name is in your Contacts folder needs attention.The image below shows the Reminder message box.
    Consistency is everything in a PowerPoint design. Consistency of design is a sign of professionalism and care. When designing your PowerPoint presentation for consistent design, the fonts and font sizes on slides are consistent from one slide to the next, the placeholder text frames are in the same positions, and the text is aligned the same way across different slides.
    Outlook isn’t in character with the rest of the Office programs. It’s a little different in that what you see onscreen changes when you click a Navigation button on the bottom of the Outlook window. Click a Navigation button — Mail, Calendar, People, Tasks, Notes, Folders, or Shortcuts — and you go to a different Outlook window altogether.
    https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

    Frequently Asked Questions

    No items found.