Learn Microsoft Office 2021: Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams, 2nd Edition

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