Office 2019 All-in-One For Dummies – Peter Weverka – 1st Edition

Introductory Material
•What Makes This Book Different
•Foolish Assumptions
•Conventions Used in This Book
•Icons Used in This Book
•Beyond the Book
Book 1: Common Office Tasks
Chapter 1: Office Nuts and Bolts
•A Survey of Office Applications
•All about Office 365
•Finding Your Way Around the Office Interface
•Saving Your Files
•Navigating the Save As and Open Windows
•Opening and Closing Files
•Reading and Recording File Properties
•Locking a File with a Password
•Trusting Microsoft with Your “Content”
Chapter 2: Wrestling with the Text
•Manipulating the Text
•Speaking, not Typing
•Changing the Look of Text
•Handling Capitalization
•Entering Symbols and Foreign Characters
•Creating Hyperlinks
Chapter 3: Speed Techniques Worth Knowing About
•Undoing and Repeating Commands
•Zooming In/Out
•Viewing a File Through Multiple Windows
•AutoCorrect and Typo Fixes
Book 2: Word 2019
Chapter 1: Speed Techniques for Using Word
•Introducing the Word Screen
•Creating and Viewing Documents
•Selecting and Moving Through Text
•Inserting Files and Forms
Chapter 2: Laying Out Text and Pages
•Formatting Paragraphs and Sections
•Margins, Indents, Headers/Footers
•Lists, Tabs, and Hyphenation
Chapter 3: Word Styles
•Applying and Creating Styles
•Modifying Styles
•Templates
Chapter 4: Constructing the Perfect Table
•Creating and Formatting Tables
•Table Layouts, Alignment, and Formulas
Chapter 5: Proofing Tools
•Spelling and Grammar
•Find and Replace
•Thesaurus, Translation
Chapter 6: Desktop Publishing with Word
•Themes and Design Elements
•Inserting and Formatting Objects
•Text Boxes, Drop Caps, Watermarks, Columns
Chapter 7: Help with Office Chores
•Highlighting and Comments
•Tracking Changes
•Mail Merge for Letters, Labels, Envelopes
Chapter 8: Tools for Reports and Scholarly Papers
•Lists and Outlines
•Table of Contents, Index, Cross-References
•Footnotes, Endnotes, Bibliographies
Book 3: Excel 2019
Chapter 1: Up and Running with Excel
•Workbooks and Worksheets
•Entering and Validating Data
Chapter 2: Refining Your Worksheet
•Editing, Selecting, and Formatting Data
•Worksheet Protection
Chapter 3: Formulas and Functions
•Entering and Copying Formulas
•Using and Troubleshooting Functions
Chapter 4: Making a Worksheet Easier to Read
•Layout and Design
•Printing Preparation
Chapter 5: Advanced Data Analysis
•Sparklines, Conditional Formatting
•Goal Seek, Data Tables, PivotTables
Book 4: PowerPoint 2019
Chapter 1: Getting Started
•Creating and Navigating Presentations
•Slide Management and Photo Albums
Chapter 2: Fashioning a Look
•Themes and Backgrounds
•Slide Size and Master Slides
Chapter 3: Entering the Text
•Text Boxes and Lists
•Footers and Headers
Chapter 4: Livelier Presentations
•Tables, Transitions, Audio, Video
•Voice Narrations
Chapter 5: Delivering a Presentation
•Notes and Timings
•Remote Presentations
Book 5: Outlook 2019
Chapter 1: Outlook Basics
•Navigating Folders
•Categorizing and Cleaning Emails
Chapter 2: Maintaining the Contacts Folder
•Contact Management and Printing
Chapter 3: Handling Your Email
•Email Setup and Sending
•Organizing and Filtering Email
Chapter 4: Managing Your Time and Schedule
•Calendar, Appointments, Recurring Events
Chapter 5: Tasks, Reminders, and Notes
•Task Lists, Alerts, Personal Notes
Book 6: Access 2019
Chapter 1: Introducing Access
•What Is a Database?
•Objects and Navigation
Chapter 2: Building Database Tables
•Table Design, Field Properties
•Indexing and Relationships
Chapter 3: Entering the Data
•Datasheet and Form Views
•Search and Replace
Chapter 4: Sorting, Querying, and Filtering
•Filters and Basic Queries
•Six Query Types
Chapter 5: Presenting Data in a Report
•Creating, Viewing, and Editing Reports
Book 7: Publisher 2019
Chapter 1: Introducing Publisher
•Frames and Publications
•Layout and Design Tools
Chapter 2: Refining a Publication
•Text and Graphic Formatting
•Page Management
Chapter 3: Finishing Touches
•Decorating, Master Pages
•Design Checker and Commercial Printing
Book 8: Working with Charts and Graphics
Chapter 1: Creating a Chart
•Chart Types, Layouts, and Formatting
•Chart Templates and Troubleshooting
Chapter 2: SmartArt Diagrams
•Creating and Formatting Diagrams
Chapter 3: Graphics and Photos
•Inserting, Editing, Compressing Pictures
Chapter 4: Drawing and Manipulating Objects
•Lines, Shapes, Icons, WordArt
•Object Positioning and Styling
Book 9: Office 2019 – One Step Beyond
Chapter 1: Customizing an Office Program
•Ribbon, Toolbar, and Status Bar
•Themes and Shortcuts
Chapter 2: Distributing Your Work
•Printing, PDF, Email, Web Pages
Book 10: File Sharing and Collaborating
Chapter 1: OneDrive Basics
•Signing In and Managing Files
•Uploading, Downloading, Opening Files
Chapter 2: File Sharing
•Sharing Options and Permissions
•Index