Learn Microsoft Office 2021 - Second Edition

Learn Microsoft Office 2021 - Second Edition

by Linda Foulkes
Released July 2022
Publisher(s): Packt Publishing
ISBN: 9781803239736

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

Take your Microsoft Office skills to the next level by mastering the exciting new features and enhancements in Microsoft Office 2021, including communicating, collaborating, and presenting using Teams

Key Features

  • Get a progressive walkthrough of the new desktop and web apps with real-world examples
  • Enrich your skillset by learning new productivity feature enhancements for Office web and desktop
  • Discover how to use Microsoft Teams to communicate, collaborate, and present during meetings

Book Description

This second edition book covers the new and exciting features of Microsoft Office 2021 for desktop and web apps, helping you broaden the skills from the previous edition. Using real-world experiences, this book will guide you through practical examples that set off your thought process to boost productivity.

To build new skills in each application, the book ensures that you gain a thorough understanding of new functions, such as PivotTables, Dashboards, and data manipulation methods in Excel.

You'll explore PowerPoint tools such as Presenter Coach, Presenter View, the record tool, and setting reading order to mention a few. You'll also manipulate slide elements using Auto Fix, draw features, insert video captions, explore playback options, and rehearse presentations using the body language Presenter Coach feature. The book demystifies the Transform feature and shows you how to dictate directly in Word. You'll even be able to work with Styles by refining the layout and multiple tables of contents. Finally, you'll focus on making the best use of Outlook enhancements and working remotely using Teams.

By the end of this book, you'll have understood the features of each app inside out and enhanced your existing skills using new techniques to make your professional life more efficient.

What you will learn

  • Uncover OneDrive features and Word enhancements such as dictation, co-authoring, embedding, styles, referencing, and media tools
  • Manage Word document layouts, online forms, recording document automation, and track, compare, and combine
  • Create engaging PowerPoint presentations using Presenter Coach, Auto Fix, Record, and drawing tools
  • Explore Excel functions such as XLOOKUP, LET, XMATCH IFS, arrays and IFERROR, and VLOOKUP
  • Work with database and COUNTIF functions, Advanced Filter, clean data, and PivotTables and Dashboards
  • Explore Outlook enhancements

Who this book is for

If you work with Microsoft Office applications but are yet to discover the complete range of features, this second edition is tailored to broaden your skillset with new features and functionalities. It would be of value for those working in any industry and for students moving into the workplace or preparing for Microsoft Office certification. The book uses real-world practical workplace examples to help you get ready to apply your skills and make the most of the recent features of Microsoft Office.

Although not a prerequisite, a solid understanding of the Microsoft Office applications will be beneficial.

Table of contents

  1. Learn Microsoft Office 2021
  2. Second Edition
  3. Contributors
  4. About the author
  5. About the reviewer
  6. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
    4. Download the example code files
    5. Download the color images
    6. Conventions used
    7. Get in touch
    8. Share Your Thoughts
  7. Part 1: Learning Word 2021
  8. Chapter 1: Exploring the New Interface and Managing OneDrive
    1. Technical requirements
    2. Exploring standalone versus online 365 apps
    3. Highlighting the new interface features
      1. Overall look and feel
      2. The title bar
      3. Customizing the QAT
      4. Using Microsoft search
      5. Checking a document using the Accessibility feature
      6. Applying dark mode (enhanced)
      7. Exploring Focus mode
      8. Using the immersive reader
    4. Managing OneDrive
      1. Saving documents to OneDrive
      2. Syncing a document to OneDrive
      3. Understanding OneDrive icons
      4. Troubleshooting sync errors
    5. Saving and renaming files in Office 365
      1. Saving documents in Office 2021
      2. Renaming documents in Office 2021
    6. Summary 
  9. Chapter 2: Dictation, Co-authoring, and Embedding
    1. Technical requirements
    2. Investigating the new transform feature
    3. Dictation enhancements within Word
      1. Activating Dictate
      2. Setting options when recording
      3. Using dictation commands
      4. Transcribing meetings
      5. Refining writing using the Editor tool
    4. Commenting and co-authoring
      1. Commenting using the new contextual view
      2. Sharing a document with others
      3. Adding comments to a shared document
    5. Embedding and converting using Word 2021
      1. Embedding videos into Word
      2. Embedding forms into Word
      3. Converting Word documents into PowerPoint slides
    6. Summary
  10. Chapter 3: Styles, Referencing, and Media
    1. Technical requirements
    2. Managing the styles environment
      1. Viewing a document in the Draft view
      2. Adding the Style pane
      3. Making sure styles are not updated
    3. Referencing features using Word 2021
      1. Working with multiple ToCs
      2. The Table of Contents feature in Word for the web
      3. Creating cross-references
    4. Creating media and drawing elements
      1. Stock Images
      2. Coloring using Hex values
      3. Applying sketched style outlines
    5. Summary
  11. Chapter 4: Managing Professional Documents
    1. Technical requirements
    2. Modifying page layouts
      1. Inserting and modifying section breaks
      2. Headers and footers
    3. Constructing online forms
      1. Preparing the form layout
      2. Working with the Developer tab
      3. Investigating content controls
      4. Adding and modifying legacy form controls
      5. Protecting a form
      6. Using Microsoft Forms
    4. Recording document automation
      1. Creating Quick Parts
      2. Generating Quick Parts
      3. Editing Quick Part entries
      4. Creating macros
      5. Running and editing macros
    5. Comparing and combining documents
    6. Summary
  12. Part 2: Learning PowerPoint 2021
  13. Chapter 5: The PowerPoint Interface and Presentation Options
    1. Technical requirements
    2. An introduction and new features
      1. Stock Images
      2. Transparency
      3. Linking to a slide
      4. Recording using Ink Replay
      5. Immersive Reader
      6. Using Presenter Coach (Speaker Coach)
      7. Using presentation templates
      8. Setting up slides and working with files
      9. Embedding fonts
    3. Saving and collaborating presentations
      1. Saving presentations in different formats
      2. Collaborating on presentations
    4. Setting print options and layouts
      1. Adjusting print settings
    5. Using view and zoom options
      1. Presentation views using the ribbon
      2. Using the status bar commands
      3. Setting presentation zoom options
      4. Switching between multiple presentations
    6. Summary
  14. Chapter 6: Formatting Slides, Charts, and Graphic Elements
    1. Technical requirements
    2. Setting up slides and applying layouts
      1. Adding new slides
      2. Duplicating selected slides
      3. Deleting multiple slides simultaneously
      4. Copying non-contiguous slides to other presentations
      5. Inserting an outline
      6. Inserting an agenda
      7. Reusing presentation slides
      8. Applying slide layouts
      9. Changing slide layouts
    3. Working with text, shapes, and objects
      1. Inserting and formatting lists
      2. Adding headers and footers to slides
      3. Formatting textboxes
      4. Arranging objects
      5. Rotating objects
      6. Using the Selection pane
      7. Grouping objects
      8. Resizing objects
      9. Resetting objects
    4. Modifying charts
    5. Applying and modifying themes
    6. Inserting audio and video
      1. Inserting a video clip
      2. Applying styles to video content
      3. Applying a style to an audio clip
      4. Adjusting the playback options
      5. Inserting captions
    7. Summary
  15. Chapter 7: Photo Albums, Sections, and Show Tools
    1. Technical requirements
    2. Creating and modifying photo albums
    3. Working with presentation sections
      1. Formatting sections
    4. Applying animations and transitions
      1. Using Animation Pane
      2. Setting up advanced animations
      3. Setting animation timing
      4. Working with transitions
    5. Using hyperlinks, actions, and comments
      1. Adding actions
      2. Using Zoom
      3. Inking feature
    6. Exploring slide show options and custom shows
      1. Setting up a slide show
      2. Playing narrations
      3. Setting up the Presenter View
      4. Setting up timings
      5. Showing media controls
      6. Creating a custom slide show
      7. Setting the reading order
      8. Rehearsing with Presenter Coach
      9. Recording a presentation
    7. Using master slides and hiding slides
      1. Creating master slides
      2. Hiding slides
    8. Summary
  16. Chapter 8: Mastering Best Practices with Presentations
    1. Technical requirements
    2. Principles of presentation design
      1. Importance of design and presentation skills
      2. Identifying tools to enhance presentation design
      3. Accessing the Pickit for PowerPoint add-in
      4. PowerPoint Designer
      5. Displaying web content
      6. Presentation planning
      7. Basic design principles
      8. White space and the rule of thirds
    3. Using clear messages and persuading audiences
      1. Conveying content to an audience
      2. Getting to know an audience
    4. Visual impact and useful techniques
      1. Considering the brain
      2. Learning about visual and verbal passages
      3. Law of proximity
      4. Investigating the impact of images and sound
      5. Applying guides to slides
      6. Aligning and grouping objects
      7. Color psychology and the brain
      8. Using the color wheel and other tools
      9. Considering style in PowerPoint design
      10. Using the Gestalt principles when designing slides
    5. Summary
  17. Part 3: Learning Excel 2021
  18. Chapter 9: New Features, Filters, and Cleaning Data
    1. Technical requirements
    2. New features to enhance proficiency
      1. Unhiding multiple sheets
      2. Troubleshooting tip
      3. Collaborating using Sheet View
      4. Speak Cells
      5. Adding the Camera tool
      6. Flash Fill
      7. Generating maps
      8. Importing data from a PDF
      9. Updating Excel on the web
    3. Filtering using Advanced Filter
      1. Defining criteria
      2. Applying Advanced Filter
      3. Using operators to refine filters
      4. Extracting using wildcard characters
      5. Extracting using the FILTER function
    4. Conditional formatting functions
      1. Setting up a validation rule
      2. Setting up a conditional formatting rule
      3. Using Icon Sets
    5. Importing, cleaning, joining, and separating data
      1. Importing datasets
      2. Cleaning data
      3. Joining data
      4. Separating data
    6. Summary
  19. Chapter 10: Exploring New and Useful Workflow Functions
    1. Technical requirements
    2. Learning about dynamic arrays
      1. Constructing an array formula to calculate a total
      2. Using the array and IF function combined
      3. Evaluating array formulas
    3. Investigating new functions
      1. New dynamic array functions
      2. Building IFS functions
      3. Building on VLOOKUP
      4. Exploring XLOOKUP
      5. Exploring XMATCH
      6. Investigating the LET function
    4. Exploring database functions
      1. Learning database function syntax
      2. Using DGET to return a single value
      3. Constructing DAVERAGE
      4. Using the AND/OR criteria
    5. Using the COUNTIFS statistical function
      1. Recapping the COUNTIF function
      2. Learning the COUNTIFS statistical function
    6. Summary
  20. Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards
    1. Technical requirements
    2. Working with dates
      1. Understanding how dates are interpreted
      2. Exploring date functions
    3. Working with time
      1. Displaying hours as time
      2. Using Paste Special to convert hours into time
      3. Separating time from date/time
      4. Converting text to a time format
      5. Adding time
    4. Enhancing PivotTables
      1. Adding PivotTable fields
    5. Creating dashboards
      1. Using slicers and timelines
      2. Inserting a timeline
      3. Setting up report connections
      4. Changing the design theme
      5. Sharing your dashboard with others
    6. Additional PivotTable customizations
      1. Splitting data into separate worksheets
      2. Changing value field settings
      3. Counting employees
      4. Amending column headings
      5. Moving PivotTable reports
      6. Constructing the GETPIVOTDATA function
    7. Summary
  21. Chapter 12: Useful Statistical and Mathematical Functions
    1. Technical requirements
    2. Exploring mathematical functions
      1. Generating random numbers
      2. Learning about the RANDBETWEEN function
      3. Working with PRODUCT functions
      4. Rounding with MROUND
      5. Rounding with the FLOOR function
      6. Returning integers
      7. Working out how to use AGGREGATE
      8. Converting measurements with CONVERT
    3. Exploring statistical functions
      1. Finding the middle ground
      2. Counting empty cells
      3. Averaging using one condition
      4. Averaging using more than one condition
    4. Summary
  22. Part 4: Outlook 2021 and Useful Communication Tools
  23. Chapter 13: Creating and Attaching Item Content
    1. Technical requirements
    2. Investigating the Outlook environment
      1. Accessing the Mini toolbar
      2. Using the To-Do Bar
      3. Using the Message pane to display folder items
      4. The Navigation Pane
      5. The Peek bar
    3. Previewing Outlook items
      1. Previewing emails in the Message pane
      2. Using the Reading Pane
    4. Manipulating Outlook program options
      1. Using the Focused inbox option
      2. Investigating mail options
      3. Turning off email notifications
      4. Manipulating item tags
    5. Working with views, filtering, and printing
      1. Changing the view type
      2. Using the Focused Inbox option
      3. Using the Reminders Window
      4. Applying search and filter tools
      5. Printing Outlook items
    6. Creating and sending email messages
      1. Specifying a message theme
      2. Showing/hiding the From and Bcc fields
      3. Configuring message delivery options
      4. Configuring voting and tracking options
      5. Sending a message to a contact group
      6. Moving, copying, and deleting email messages
      7. Replying to and forwarding email messages
    7. Creating and managing Quick Steps
    8. Attaching item content
      1. Attaching an Outlook item
      2. Attaching external files
    9. Summary
  24. Chapter 14: Managing Mail and Contacts
    1. Technical requirements
    2. Cleaning up your mailbox and managing rules
      1. Cleaning up the mailbox
      2. Creating and managing rules
    3. Managing junk mail and automatic message content
      1. Allowing a specific message (not junk)
      2. Filtering junk mail with Never Block Sender
      3. Viewing the Safe Senders list
      4. Blocking senders
      5. Managing signatures
    4. Creating contact information and groups
      1. Modifying a default business card
      2. Forwarding a contact
      3. Creating and manipulating contact groups
    5. Summary
  25. Chapter 15: Calendar Objects, Tasks, Notes, and Journal Entries
    1. Technical requirements
    2. Working with the calendar, appointments, meetings, and events
      1. Difference between meetings, events, and appointments
      2. Creating and manipulating appointments or meetings
    3. Modifying meeting requests and manipulating the calendar pane
      1. Setting the response options
      2. Updating a meeting request
      3. Canceling a meeting or invitation
      4. Proposing a new time for a meeting
      5. Viewing the tracking status of a meeting
      6. Editing a meeting series
      7. Using the @ mention feature
      8. Manipulating the calendar pane
      9. Creating a calendar group
    4. Creating and managing tasks
      1. Creating tasks
      2. Managing the task details
      3. Sending a status report
      4. Assigning a task to another Outlook contact
      5. Marking a task as complete
      6. Accepting or declining a task assignment
    5. Creating and manipulating notes and journal entries
      1. Creating a note
      2. Changing the current view
      3. Categorizing notes
      4. Working with journal entries
      5. Tracking Outlook items and files
    6. Setting out-of-office options
    7. Summary
  26. Chapter 16: Creating and Managing Online Meetings
    1. Technical requirements
    2. Adding remote meetings to Outlook
      1. Learning about Teams and Zoom meeting add-ins
      2. Troubleshooting the Teams Meeting icon
      3. Joining and leaving meetings
      4. Customizing meeting options
    3. Creating and managing Channels
      1. Creating Channels
      2. Managing Channels
      3. Setting Teams and Channel notifications
      4. All about Teams Chats
    4. Summary
  27. Chapter 17: Presenting and Collaborating Online
    1. Technical requirements
    2. Differences between OneDrive and SharePoint
    3. Apps within Channels
    4. Presenting during online meetings
      1. Presenting PowerPoint options
      2. Presenting using PowerPoint Live
      3. Exploring Presenter Modes
      4. Functionality in Teams Meetings
    5. Collaborating and file sharing
      1. Uploading files to channels
      2. Working with New Sheet View
      3. Working with versions
    6. Summary
    7. Why subscribe?
  28. Other Books You May Enjoy
    1. Packt is searching for authors like you
    2. Share Your Thoughts

Product information

  • Title: Learn Microsoft Office 2021 - Second Edition
  • Author(s): Linda Foulkes
  • Release date: July 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781803239736