Book description
Conquer Microsoft Office 2019–from the inside out!
Dive into Microsoft Office 2019–and really put its productivity toolsand services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Office's most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Office 2019 and Office 365, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, online Office apps, and more. Discover how experts tackle today's key tasks–and challenge yourself to new levels of mastery.
- Create amazing content faster with Office's new features, tools, and shortcuts
- Share, collaborate with, and secure Office files in the cloud
- Organize, edit, and format complex documents with Microsoft Word
- Build tables of contents, captions, indexes, and footnotes that automatically update
- Efficiently enter and manage data in Excel workbooks, and format it for easy understanding
- Build flexible, reliable Excel workbooks with formulas and functions
- Integrate data from external sources, including web tables, text files, and more
- Transform data into insight with Excel charts, Sparklines, and PivotTables
- Quickly create presentations with PowerPoint themes, Reuse Slides, and Libraries
- Build more impactful slides with advanced formatting, SmartArt, animation, transitions, and multimedia
- Use PowerPoint 2019 tools to present more effectively, both in person and online
- Systematically improve email productivity and security with Outlook 2019
- Manage appointments and tasks, and quickly plan meetings
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Dedication Page
- Contents at a Glance
- Table of Contents
- Acknowledgments
- About the Author
- Introduction
- Part I Getting started with the Office applications
-
Part II Word
-
Chapter 6 Essential Word features
- Introducing Word
- Options for creating a new Word document
- Using templates
- Navigating a Word document
- Moving around a document with the keyboard
- Understanding document formatting
- Working with fonts and text formatting
- Working with paragraph formatting
- Page layout: margins and page options
- Printing documents
-
Chapter 7 Enhancing Word documents
- Creating better documents
- Creating bulleted and numbered lists
- Working with borders and shading
- Formatting with themes
- Creating headers and footers
- Inserting pictures, clip art, and charts
- Changing the document display
- Using the review tools
- Working with Quick Parts
- Configuring AutoCorrect
- Understanding styles
- Chapter 8 Working with tables, columns, and sections
- Chapter 9 Managing mailings and forms
- Chapter 10 Creating special documents
-
Chapter 6 Essential Word features
-
Part III Excel
- Chapter 11 Essential Excel features
-
Chapter 12 Worksheet formatting and management
- Formatting text entries
- Formatting values
- Adding comments to cells
- Using themes
- Formatting cells using borders and color
- Using cell styles and the Format Painter
- Using conditional formatting
- Manipulating cells and cell content
- Working with columns and rows
- Working with worksheets
- Naming ranges
- Adding images and graphics to worksheets
-
Chapter 13 Getting the most from formulas and functions
- Performing calculations in Excel worksheets
- Relative versus absolute referencing
- Creating and editing formulas
- Working with Excel functions
- Entering a function in a cell
- Using range names in formulas and functions
- Referencing cells or ranges on other worksheets
- Copying and moving formulas and functions
- Choosing the right function
- Proofing your formulas and functions
- Chapter 14 Enhancing worksheets with charts
- Chapter 15 Using Excel tables and pivot tables
- Chapter 16 Validating and analyzing worksheet data
-
Part IV PowerPoint
-
Chapter 17 Essential PowerPoint features
- PowerPoint
- Options for creating a new presentation
- Creating a template
- Inserting new slides
- Modifying a slide’s layout
- Working with slides in different views
- Opening a new presentation window
- Rearranging and deleting slides
- Modifying bulleted lists
- Using numbered lists
- Viewing a presentation during editing
- Chapter 18 Advanced presentation formatting, themes, and masters
- Chapter 19 Better slides with clip art, pictures, and SmartArt
- Chapter 20 Enhancing slides with animation, transitions, and multimedia
-
Chapter 21 Delivering a presentation and creating support materials
- Planning your presentation
- Checking the presentation for spelling and grammar errors
- Running through a completed presentation
- Using the presenter view
- Using hidden slides
- Creating a custom slide show
- Creating a self-running presentation
- Creating an interactive presentation
- Presenting a slideshow online
- Working with the notes and handout masters
- Printing presentations, notes, and handouts
- Exporting a presentation
- Sharing your presentation
-
Chapter 17 Essential PowerPoint features
-
Part V Outlook
-
Chapter 22 Outlook configuration and essential features
- Introducing Outlook
- Outlook and email accounts
- Configuring Outlook at first start
- Understanding Outlook profiles
- Understanding Outlook data files
- Importing and exporting data
- Navigating the Outlook workspace
- Working with views in Outlook
- Categorizing Outlook items
- Searching for Outlook items
- Printing Outlook items
-
Chapter 23 Managing email in Outlook
- Working in the Mail folder
- Creating an email message
- Using the Outlook Address Book
- Setting message options
- Attaching files and items to a message
- Using themes and email stationery
- Adding a signature
- Sending mail
- Recalling a message
- Working with received email
- Managing email
- Managing email accounts
- Setting Outlook mail options
- Chapter 24 Using the calendar for appointments and tasks
-
Chapter 25 Working with contacts and planning meetings
- Navigating the Contacts list
- Creating a new contact
- Editing contact information
- Searching the Contacts folder
- Organizing contacts with groups
- Forwarding and sharing contacts
- Communicating with contacts
- Contact actions
- Printing contact information
- Setting contact options
- Scheduling meetings
- Responding to meeting requests
- Chapter 26 Using the Journal and notes
- Chapter 27 Securing and maintaining Outlook
-
Chapter 22 Outlook configuration and essential features
- Part VI Publisher
- Part VII Appendixes
- Index
- Code Snippets
Product information
- Title: Microsoft Office 2019 Inside Out, First Edition
- Author(s):
- Release date: November 2018
- Publisher(s): Microsoft Press
- ISBN: 9781509306282
You might also like
book
Microsoft Office 2019 Step by Step, First Edition
This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you …
book
Microsoft Word 2019 Step by Step, First Edition
The quick way to learn Microsoft Word 2019 and Word for Office 365!This is learning made …
video
Microsoft Word 2019
Microsoft Word remains one of the most popular business tools and rightly so. Businesses around the …
book
Microsoft Office Inside Out (Office 2021 and Microsoft 365)
Conquer Office apps in Microsoft 365 -- from the inside out! Dive into Microsoft Office and …