Microsoft Office Inside Out (Office 2021 and Microsoft 365)

Microsoft Office Inside Out (Office 2021 and Microsoft 365)

by Joe Habraken
Released December 2021
Publisher(s): Microsoft Press
ISBN: 9780137564255

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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

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

Product information

  • Title: Microsoft Office Inside Out (Office 2021 and Microsoft 365)
  • Author(s): Joe Habraken
  • Release date: December 2021
  • Publisher(s): Microsoft Press
  • ISBN: 9780137564255