Microsoft Office Inside Out (Office 2021 and Microsoft 365)

✍ Scribed by Joe Habraken

• Publisher: Microsoft Press
• Year: 2021
• Tongue: English
• Leaves: 1138
• Edition: 1
• Category: Library

✦ Synopsis

Conquer Office apps in Microsoft 365 -- from the inside out!

Dive into Microsoft Office and really put its productivity tools and 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, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, OneNote, and Teams. 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 tools to present more effectively, both in person and online
• Systematically improve email productivity and security with Outlook
• Manage appointments and tasks, and quickly plan meetings

✦ Table of Contents

Title Page
Copyright Page
Pearson’s Commitment to Diversity, Equity, and Inclusion
Dedication Page
Contents at a Glance
Table of Contents
Acknowledgments
About the Author
Introduction
Who this book is for
Assumptions about you
How this book is organized
Errata, updates & book support
Part I: Getting started with the Microsoft 365 apps
Chapter 1. Getting oriented to the Microsoft 365 applications
Introducing Microsoft 365
New features and tools in Microsoft 365
The 365 suite applications
The different versions of the 365 app suite
Hardware and software requirements for 365
Installing Microsoft 365
Getting Help in the 365 applications
Chapter 2. Navigating and customizing the 365 interface
Getting familiar with the 365 interface
Navigating the 365 applications
Customizing an application interface
Configuring application options
Using the Trust Center
Chapter 3. Managing and sharing 365 files
Understanding 365 file formats
Configuring save file options
Creating and managing files
Searching for 365 files
Protecting a 365 file
Preparing a file for sharing
Chapter 4. Using and creating graphics
The 365 options for graphics and pictures
Working with your digital pictures
Using shapes and the 365 drawing tools
Using the screenshot tool
Using WordArt
Chapter 5. Using the 365 Online apps
What the Online apps can do
Where the Online apps live
Saving Online application files to the cloud
Using the Word Online app
Using Excel Online
Using PowerPoint Online
Part II: Word
Chapter 6. Essential Word features
Introducing Word
Options for creating a new Word document
Using templates
Navigating a Word document
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 and charts
Changing the document display
Using the Editor
Working with Quick Parts
Configuring AutoCorrect
Understanding styles
Chapter 8. Working with tables, columns, and sections
Options for adding a table
Formatting tables
Sorting table data
Using formulas in tables
Adding columns to a document
Understanding sections
Chapter 9. Managing mailings and forms
Options for mail-related documents
Creating an envelope
Creating a label or labels
Understanding mass mailings
Performing a mail merge
Understanding Word fields
Building a form with form controls
Chapter 10. Creating special documents
Options for large documents
Creating a table of contents
Working with captions and tables of figures
Generating an index
Working with citations and bibliographies
Tracking document changes
Building a better “big” document
Creating a master document
Part III: Excel
Chapter 11. Essential Excel features
Introducing Excel
Navigating the Excel workspace
Creating workbooks and worksheets
Managing Excel workbooks
Entering data in a worksheet
Copying, moving, and deleting cell contents
Editing cell content
Viewing worksheets
Printing worksheets
Chapter 12. Worksheet formatting and management
Formatting text entries
Formatting values
Adding comments and notes 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
Understanding Excel charts
Creating charts
Modifying a chart
Working with chart elements
Creating a combination chart
Chapter 15. Using Excel tables and pivot tables
Excel and databases
Defining a table range
Creating a table using styles
Using the Table Design Tools
Sorting table data
Filtering table data
Using the data form
Creating outlines and subtotals
Working with external data
Connecting to other data sources
Working with pivot tables
Chapter 16. Validating and analyzing worksheet data
Taking advantage of data validation
Performing a what-if analysis
Using Goal Seek, Solver, and Forecast Sheet
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
Working with text boxes and formatting
Arranging text in tables
Working with themes
Using headers and footers
Understanding masters
Altering and creating master slides
Creating layout masters
Using slide sections
Chapter 19. Better slides with pictures, objects, and SmartArt
Using graphics to enhance slides
Inserting a picture
Adding stock images to slides
Creating a photo album
Working with shapes
Inserting icons
Using SmartArt graphics
Adding charts to slides
Working with slide objects
Adding hyperlinks to slides
Using PowerPoint Designer
Chapter 20. Enhancing slides with animation, transitions, and multimedia
Animations versus transitions
Assigning animation to a slide object
Advanced animation techniques
Managing slide animations
Adding transitions to slides
Adding sound to a slide
Editing sound options
Adding video to a slide
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 coach
Using the presenter view
Using hidden slides
Creating a custom slide show
Creating a self-running presentation
Creating an interactive presentation
Working with the notes and handout masters
Printing presentations, notes, and handouts
Exporting a presentation
Sharing your presentation
Part V: Outlook
Chapter 22. Outlook configuration and essential features
Introducing Outlook
Outlook and email accounts
Configuring Outlook at first start
Adding email accounts to Outlook
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 Outlook window
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
Navigating the calendar
Scheduling an appointment
Searching the calendar
Sharing calendars
Setting calendar options
Working with 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. Securing and maintaining Outlook
Security overview
Configuring Outlook security settings
Encrypting email and using digital signatures
The perils of HTML email
Dealing with message attachments
Coping with junk email
Creating email rules
Managing rules
Archiving Outlook items
Configuring an autoreply message
Part VI: Publisher
Chapter 27. Essential Publisher features
Introducing Publisher
Planning your publication
Working with publication templates
Creating a new publication
Creating a business information set
Working with text
Inserting illustrations
Using building blocks
Printing publications
Chapter 28. Advanced Publisher features
Adding pages to a publication
Configuring page settings
Changing the current template
Working with master pages
Using tables in publications
Manipulating publication objects
Merging data into a publication
Fine-tuning your publications
Part VII: Appendixes
Appendix A. Microsoft 365 application integration
Sharing application data
Understanding object linking and embedding
Linking objects
Updating and breaking links
Embedding objects
Editing embedded objects
Sharing data with Outlook using actions
Appendix B. Microsoft 365 macros
Macros and Office
Understanding macros
Creating a macro
Running macros
Editing recorded macros
Digitally signing macros
Index
Code Snippets