Learn Microsoft Office 2021: Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams, 2nd Edition
- Length: 654 pages
- Edition: 2
- Language: English
- Publisher: Packt Publishing
- Publication Date: 2022-07-29
- ISBN-10: 1803239735
- ISBN-13: 9781803239736
- Sales Rank: #1272916 (See Top 100 Books)
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.
Learn Microsoft Office 2021 Second Edition Contributors About the author About the reviewer Preface Who this book is for What this book covers To get the most out of this book Download the example code files Download the color images Conventions used Get in touch Share Your Thoughts 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 Practices 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 Why subscribe? Other Books You May Enjoy Packt is searching for authors like you Share Your Thoughts
Donate to keep this site alive
How to download source code?
1. Go to: https://github.com/PacktPublishing
2. In the Find a repository… box, search the book title: Learn Microsoft Office 2021: Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams, 2nd Edition
, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.