Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Learn Microsoft Office 2021
Learn Microsoft Office 2021

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

eBook
€13.99 €20.99
Paperback
€25.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Learn Microsoft Office 2021

Chapter 1: Exploring the New Interface and Managing OneDrive

Welcome to the first chapter of Learn Microsoft Office 2021. This chapter will highlight the difference between the standalone and subscription versions of Office 2021. In our previous edition of this book, Learn Microsoft Office 2019, we provided an in-depth explanation of all the Office applications and covered the very basic to advanced skills. In this book, we will build on the skills that were presented in the first edition.

First, we will look at what Microsoft Office 2021 offers within the single-user license compared to that of the Microsoft 365 online version, then progress to upskill you on the new interface features. We will also become familiar with the importance of OneDrive when working with Office 2021, learn how to manage OneDrive, and learn how to save files in Office 365. Lastly, we'll point out any new formatting elements, as well as quick ways to control attributes and ways to speed up the document formatting process.

The following topics will be covered in this chapter:

  • Exploring standalone versus online 365 apps
  • Highlighting the new interface features
  • Managing OneDrive
  • Saving and renaming files in Office 365

The skills mentioned in this chapter will help build your confidence so that you can work on the later chapters in this book.

Note

Some of the interface features we will talk about span all the Microsoft Office suite applications and can be accessed and applied using the same method shown for Word 2021.

Technical requirements

To benefit from the contents of this book, you must be able to follow along with and work through the examples provided in each chapter. The examples for this chapter can be found at https://github.com/PacktPublishing/Learn-Microsoft-Office-2021-Second-Edition.

Exploring standalone versus online 365 apps

In this section, we will discuss the difference between the latest release of Office 2021 versions. Microsoft Office 2021 is offered as a one-time purchase, which grants you a lifetime license for the software.

The Microsoft 365 plans include online apps and can be purchased as subscription services (monthly or yearly) with regular updates to features. Apps that are included with Microsoft 365 can be shared to your devices, as well as within your family unit.

With the Office 2021 standalone desktop version, you are limited to one installation per user. You will need to purchase any further upgrades for the software when they're released. However, security updates will be pushed out to both platforms (standalone desktop and online apps).

Reference

More information regarding Microsoft 365 can be found here:

https://support.microsoft.com/en-us/office.

There are various purchase options for the desktop version of Office 2021 and your requirements will determine the best option. The following applications are always included as a standard:

  • Word 2021
  • Excel 2021
  • PowerPoint 2021

Other applications such as Access 2021, Outlook 2021, Publisher 2021, Teams, and OneNote 2019 form part of the offering, depending on the plan you choose:

Figure 1.1 – Microsoft Office 2021 plans

Figure 1.1 – Microsoft Office 2021 plans

The Microsoft 365 contribution (2021 apps) is divided into Home and Business plans, with a range of different options under each. Visit the following website for details: https://www.microsoft.com/en-gb/microsoft-365/buy/compare-all-microsoft-365-products-b?. Regarding the operating systems that Office 2021 requires, it can run on Windows 10 and 11 (as well as macOS).

In this chapter, we will refer to OneDrive and SharePoint. It is important to note the difference between these two online storage apps. OneDrive is a personal online storage and sharing tool that is provided, along with other apps, when you sign up for a Microsoft account. As a personal user with OneDrive, you can grant others access to files, known as file sharing. Note that some plans are free, while some must be paid. SharePoint is used to collaborate on files via a team within an organization. SharePoint offers a higher level of security and access to files is managed by the Admin team.

Let's move on to the next section, where we will look at what changes have been made to the Microsoft Office 2021 interface.

Highlighting the new interface features

In this section, you will learn how to recognize some of the new features that have been incorporated into the latest update of the desktop versions of the 2021 applications. You will also learn whether they are available within the Microsoft 365 apps.

Although most interface features and explanations are identical in some classic applications, any features that can be applied solely to an application will be addressed in the relevant chapter going forward. Let's browse the environment and learn about the different elements that make up Office 2021 applications.

Overall look and feel

Office 2021 has a much clearer interface, with tabs and groups being so much cleaner and crisper. The icons (buttons) are much less complex, with icon graphics represented using single lines. The edges seem softer and easier on the eye – you can locate features much quicker at a glance.

The following screenshot shows the Microsoft Word 2021 interface, as well as the Microsoft 365 – Word 2021 app interface:

Figure 1.2 – Difference between the desktop and online app versions

Figure 1.2 – Difference between the desktop and online app versions

Some features have been enhanced in the new version of Office 2021. Let's highlight a few of the cosmetic changes.

The title bar

As you may already know, the title bar is located at the very top of each program that's launched in the Windows app and macOS environment.

Microsoft Word 2021 includes an AutoSave button, which can be found on the left-hand side of the title bar, as well as an Editor button.

The area of the title bar that houses the AutoSave button is named the Quick Access Toolbar (QAT) and is where you can add any program manipulation icons. The AutoSave and Editor buttons have been added to the QAT by default:

Figure 1.3 – The title bar showing the QAT, which includes the AutoSave and Editor features

Figure 1.3 – The title bar showing the QAT, which includes the AutoSave and Editor features

The title bar also includes the file's description (filename), along with a drop-down list where you can see the version history of your document, move it to another location, and rename the description of the file.

By default, the AutoSave button is set to Off, and the filename drop-down list is deactivated unless the document is saved to the cloud. Normally, the online cloud service of choice would be OneDrive (or SharePoint).

Customizing the QAT

There are two ways to customize the QAT, as follows:

  1. Use the Customize Quick Access Toolbar drop-down menu located to the top left of the title bar:
Figure 1.4 – The QAT drop-down list

Figure 1.4 – The QAT drop-down list

Note

Icons that already display a checkmark to the left indicate that the icon is already an option on the QAT. You simply have to click on the name of the shortcut that you want to add to the QAT.

  1. Click on the File tab, then select Options. From the Word Options dialog box, choose Quick Access Toolbar. From the right-hand side of the dialog box, you will notice the features that are currently visible on the QAT. To add additional features to the QAT, simply double-click on the relevant feature on the left-hand side to add it. Click on OK to confirm this:
Figure 1.5 – The Word Options dialog box displaying the QAT customization options

Figure 1.5 – The Word Options dialog box displaying the QAT customization options

In the next section, we will learn how to use the new Search facility in Office 2021.

Using Microsoft search

Toward the center of the title bar of your Office 365 apps or standalone Office 2021 applications, you will notice the Search facility. This facility is available when you're using Word, Excel, PowerPoint, Outlook, and OneNote:

Figure 1.6 – New Search feature in Office 2021

Figure 1.6 – New Search feature in Office 2021

This tool is extremely useful as it lets you do the following:

  • Search for contacts (people) and locate text within the document
  • Search for common features without going through all the tabs
  • Locate documents you have used in the office environment
  • Look up definitions
  • Opens the task pane to the right-hand side of the application after entering search terms to locate information from the web, media, and help
  • Find relevant features after typing in search criteria:
Figure 1.7 – Using the Search facility to locate a feature

Figure 1.7 – Using the Search facility to locate a feature

The Accessibility feature lives on the status bar and watches you while you work on documents. We will discover this new feature in the next section.

Checking a document using the Accessibility feature

The Accessibility checker is included in Word, Excel, and PowerPoint 2021.

As we know, the status bar displays information about the current file we are working on and provides quick access to some tasks. The Accessibility checker is one of the default features along the status bar. The checker runs in the background while you work (by default) and offers you recommendations on various accessibility enhancements you can apply to a document:

Figure 1.8 – Status bar showing the new Accessibility feature

Figure 1.8 – Status bar showing the new Accessibility feature

If we click on the Accessibility: Investigate feature on the status bar, the Accessibility pane will open to the right of the document. This pane contains the Inspection Results area:

Figure 1.9 – The Accessibility checker in Word, PowerPoint, and Excel

Figure 1.9 – The Accessibility checker in Word, PowerPoint, and Excel

Applying dark mode (enhanced)

Changing the visual display of the Office Theme was available in the previous versions of Office, but the document's background remained white. This feature has now been enhanced to display the document's background in dark mode too. Some enjoy this feature as it is easy on the eye and provides less strain and improved light sensitivity. To access this feature, go to File | Options | General | Office Theme:

Figure 1.10 – Change the Office Theme to Black (dark mode)

Figure 1.10 – Change the Office Theme to Black (dark mode)

We can change the canvas's mode back to display the background of the Word document in white while the rest of the display is in dark mode:

  1. Click on the View tab.
  2. Select Switch Modes from the Dark Mode group. Note that the Switch Modes feature only appears as a button on the ribbon when the Office background is set to Black.
  3. As you can see, the document's background appears white while the rest of the window remains in dark mode:
Figure 1.11 – Switching modes

Figure 1.11 – Switching modes

While dark mode is activated, we can explore Focus mode.

Exploring Focus mode

Focus mode can be accessed through the View tab on the ribbon, or via the Focus button on the status bar. Focus mode hides all the unnecessary parts of the screen so that you concentrate on the document in question only.

While in Focus mode, move your cursor to the center top of the screen. Click on the three dots () to pull down the Word 2021 ribbon. Make sure you are on the View tab, then select a color from the Background button dropdown:

Figure 1.12 – Changing the background's color while in Focus mode

Figure 1.12 – Changing the background's color while in Focus mode

In the next section, we will look at the immersive reader. It is a brilliant tool with several benefits.

Using the immersive reader

The immersive reader is located under the View tab on the ribbon and contains several really useful tools, from reducing eye stress and removing distractions from a document, to reading the text out loud while you proofread your documents:

Figure 1.13 – Immersive reader contextual menu

Figure 1.13 – Immersive reader contextual menu

Once you activate the immersive reader in Word 2021 on desktop or on the online app, your screen will open in much the same view as Focus mode to begin with (explained previously), showing a less complex view of the document.

Let's see what the immersive reader has to offer.

Column width

The width of the margin to the left and the right can be adjusted to suit you in terms of comprehension and concentration. This is especially beneficial when you're working on a smaller screen:

Figure 1.14 – Immersive reader column width options

Figure 1.14 – Immersive reader column width options

As we mentioned previously, we can also set the page's color when using Focus mode. Let's learn how.

Page color

Selecting a page color here will create a softer reading experience for the reader and reduce strain on the eyes.

Line Focus

The third button on the immersive reader is the Line Focus dropdown. Dependent on the number of lines that are selected from the drop-down list, the reader will navigate through the document while reading only the number of lines that you've chosen to focus on:

Figure 1.15 – The Line Focus option showing three lines of the document at a time

Figure 1.15 – The Line Focus option showing three lines of the document at a time

Although Line Focus is a great tool to aid concentration, increasing the text's spacing (covered in the next section) can also make a big difference.

Text spacing

The fourth option on the Immersive reader contextual tab is the ability to set the text spacing. Using this option will expand the spacing between lines, characters, and words. Click the button once to expand, and then again to reduce the spacing.

Syllables

The syllables option allows you to focus more on pronouncing words as it adjusts words to include breaks, which helps you recognize words. This is a brilliant tool for children who wish to gain command of a language:

Figure 1.16 – A paragraph showing syllable breaks when using the immersive reader

Figure 1.16 – A paragraph showing syllable breaks when using the immersive reader

This tool can be used in conjunction with others in the immersive reader. Now, let's focus on the last option – the Read Aloud feature.

Read Aloud

This tool will highlight each word as it reads it back to you, one word at a time. Once you have activated the tool, use the buttons to the top-right-hand side of the window to rewind, play, forward, or set reading speed customizations. If you do not enjoy Microsoft David as the voice narrator, you can select Microsoft Zira or Microsoft Mark instead:

Figure 1.17 – The Read Aloud feature's playback buttons and settings

Figure 1.17 – The Read Aloud feature's playback buttons and settings

Once you get to grips with the Read Aloud feature, you may wish to experiment with the following shortcut keys:

Table 1.1 – Read Aloud shortcuts

Table 1.1 – Read Aloud shortcuts

Now that we have explored some of the new features within the Word 2021 environment, let's learn about OneDrive features and understand what is meant by the term OneDrive.

Managing OneDrive

OneDrive is the online file storage area that you can access once you have signed up for a Microsoft account. It provides you with a means to access services and devices and was previously known as Windows Live ID. You can use OneDrive if you have a Microsoft account or Microsoft 365 Work/School account access. OneDrive is free to use if you are happy to only have 5 GB of storage space. If not, you can choose from a range of paid plans.

OneDrive is important as the service allows you to add (save) documents directly from within the Microsoft Office 2021 applications to the online storage facility.

Many features within the new version of Office will only be activated once you've done this. Previously, we could upload files to OneDrive and/or save them directly to OneDrive. This feature is now integrated so that we can move files and see version history directly within the Office applications, instead of having to open OneDrive to achieve this.

Like many other plans, OneDrive offers Home and Business plan options. The differences between them relate to the amount of storage quota, your monthly or annual subscription, whether you need the storage free for personal use or Microsoft 365 apps, or whether you want business use with access to Office apps.

In the next section, we will learn how OneDrive is integrated into Word 2021.

Saving documents to OneDrive

As we mentioned previously, for the AutoSave feature to be enabled within Office 2021 applications, you need to ensure that your file is saved to OneDrive. One of the pros of using OneDrive as the preferred storage location for documents is that you will not lose any work as the document is updated constantly in the background. Having files stored in the OneDrive app also means that you can access them at any time on any device that's logged into the Office 365 service.

Follow these steps to save documents to OneDrive:

  1. Click the File tab.
  2. Choose Save As from the list on the left.
  3. If you are connected to OneDrive, you will see your accounts already listed here. We are already associated with OneDrive – Personal, as shown in the following screenshot:
Figure 1.18 – The Save As options in Word 2021 showing the connection to OneDrive – Personal

Figure 1.18 – The Save As options in Word 2021 showing the connection to OneDrive – Personal

  1. If the OneDrive connection is not readily available, click the Add a Place option:
Figure 1.19 – Available locations when saving documents

Figure 1.19 – Available locations when saving documents

  1. Finally, choose from either the OneDrive or OneDrive for Business option:
Figure 1.20 – Selecting OneDrive or OneDrive for Business as a document location

Figure 1.20 – Selecting OneDrive or OneDrive for Business as a document location

  1. After selecting the location, you may be asked to sign in to your OneDrive account if you have not already done so:
Figure 1.21 – Dialog box prompting you to sign in to OneDrive to sync files

Figure 1.21 – Dialog box prompting you to sign in to OneDrive to sync files

  1. Add or amend the File name: description, if necessary:
Figure 1.22 – Adding or amending the File name: description

Figure 1.22 – Adding or amending the File name: description

  1. Click the Save button to confirm your choice.

The document will now be saved to the cloud and the title bar will display Saved… just after the description of the file. Every couple of seconds, the filename area will refresh to display Saving…. This will happen when OneDrive updates (syncing) any amendments you've made to the cloud automatically:

Figure 1.23 – The title bar indicating when the document is updated and saved to the cloud

Figure 1.23 – The title bar indicating when the document is updated and saved to the cloud

Note

When a document is saved to an online location, as shown in the preceding screenshot, the Save button to the left of the QAT will display a double arrow to the bottom right of the button. Click that button to refresh the document with amendments from other authors.

Note that documents will not sync automatically to the cloud, nor from the cloud to your devices, unless the following is true:

  • Sync is activated on your device.
  • You have an active internet connection.
  • You have set up your OneDrive account and you are signed in.
  • A document is currently open and reporting a sync error.

Next, we will learn how to sync documents to OneDrive and learn about the various status icons in File Explorer for your OneDrive connections.

Syncing a document to OneDrive

When we create documents in Office 365, they are stored in OneDrive's online storage area. These documents are only available online if you're not synced to other devices. The same would happen to documents that have been created locally within Microsoft Word 2021, for instance. Although documents exist in the OneDrive location on the local computer's File Explorer area, they may not be available online until certain sync conditions have been met.

To sync documents to the cloud or from the cloud to a OneDrive-connected folder location, you will need to set up OneDrive and have sync active. To understand this better, let's look at a scenario.

The following screenshot shows an example of the contents of the Safer Solutions folder on OneDrive online:

Figure 1.24 – The contents of the Safer Solutions folder on OneDrive

Figure 1.24 – The contents of the Safer Solutions folder on OneDrive

Tip

The three blue stripes at the top left of the filename (as shown in the preceding screenshot) indicate that the file has recently been updated.

Now, let's go to the same OneDrive folder that exists in File Explorer on our local computer. Notice the Status column in the following screenshot. Not all the status icons are the same. The SS Event document's status indicates that it only exists online, although we can see the file in the OneDrive-connected folder locally. This means that we can see the file in OneDrive and that on opening the file from this area, it will only open in the browser.

The Marketing Burst 2021 document was saved locally and synced to OneDrive online (which means that the document can be accessed online and locally). We will discuss why the folder and document are pending sync here:

Figure 1.25 – OneDrive folder connection showing the status of documents

Figure 1.25 – OneDrive folder connection showing the status of documents

Next, we will discuss the different statuses so that you know how to manage your online and local environments better.

Understanding OneDrive icons

In the previous section, the OneDrive-connected folder on my local computer indicates that two of the folder items are pending sync. We can check the status of a document by placing our cursor over the status icon in the Status column (see the following screenshot). There are several status icons, so it is important to recognize the differences between them:

Figure 1.26 – Explorer showing the OneDrive sync pending status

Figure 1.26 – Explorer showing the OneDrive sync pending status

The following table outlines the most common status icons:

Figure 1.27 – OneDrive-connected folder status meanings

Figure 1.27 – OneDrive-connected folder status meanings

To ensure that a file/folder remains only on the local device, right-click on the file/folder in the OneDrive folder on the computer and select Always keep on this device. The status icon will display a green circle with a white checkmark:

Figure 1.28 – The Always keep on this device option after right-clicking a document

Figure 1.28 – The Always keep on this device option after right-clicking a document

There are several reasons why we may receive sync errors when working with the OneDrive folder locally. Let's learn how to troubleshoot such sync issues.

Troubleshooting sync errors

Once you have set up OneDrive on your computer, you can check its status by clicking the OneDrive icon to the right of the Windows taskbar. This icon will indicate whether you are online, offline, or if sync has been paused:

Figure 1.29 – The OneDrive taskbar's icons displaying paused, offline, and online

Figure 1.29 – The OneDrive taskbar's icons displaying paused, offline, and online

When you visit the OneDrive folder location within your File Explorer area, you will notice the sync status next to the document or folder. It is important to keep an eye on both these status areas so that you can ensure your documents are being synced, are accessible on all devices, and contain the latest amendments.

Depending on several factors, OneDrive could slow down your system considerably if you're syncing all the time. You can change this setting so that you only sync manually or pause syncing for a certain period.

To pause syncing

Follow these steps to learn how to pause syncing:

  1. Click the OneDrive icon on the Windows taskbar.
  2. Select Help & Settings.
  3. Click the Pause syncing drop-down arrow:
Figure 1.30 – OneDrive's Pause syncing option

Figure 1.30 – OneDrive's Pause syncing option

  1. Choose to pause for 2, 8, or 24 hours.
  2. The OneDrive icon on the taskbar will indicate that OneDrive is paused.

Now, let's learn how to specify which online folders are available on your computer.

Choosing folders

Folders from OneDrive's online storage can be made available on your local computer. If we use OneDrive as our primary storage area, we may need to make a few of these folders accessible locally:

  1. Click the OneDrive icon on the Windows taskbar.
  2. Select Help & Settings.
  3. Click Settings.
  4. Be sure to select the Account tab at the top of the dialog box that populates.
  5. Click the Choose folders button (sign in to OneDrive if required), then select the folders by clicking on them:
Figure 1.31 – The Account settings dialog box for OneDrive

Figure 1.31 – The Account settings dialog box for OneDrive

  1. Select OK to confirm this.

    Note

    OneDrive accounts can also be unlinked from your PC using the respective Unlink this PC option on the Account tab. Go to the Settings tab to choose options related to starting OneDrive and customizing notifications.

Saving and renaming files in Office 365

Files are automatically saved to the cloud when you're using Office 365 plans. The cloud platform that can be accessed through Office 365 is OneDrive, as we explained previously.

Saving documents in Office 2021

Saving a document when you're working in the Word 2021 online application is a simple process:

  1. Locate the document's description on the title bar of the application.
  2. Select the drop-down arrow to the right of the document's description.
  3. The File Name area, as well as the Location areas, can be amended here.
  4. After typing in the filename's description, click the OneDrive location to tell OneDrive to choose an online folder to save the document to.
  5. Notice that Save status and Version History are also part of this drop-down list:
Figure 1.32 – Office 365 – Clicking the drop-down list to the right of the filename to see the Version History and save options

Figure 1.32 – Office 365 – Clicking the drop-down list to the right of the filename to see the Version History and save options

Renaming documents in Office 2021

In this section, we will learn how to rename documents without having to use the Save As… command or navigate back to File Explorer to rename the document. It is now possible to rename a document directly within the Office 2021 environment, without creating a copy.

If a document has been saved using the specified OneDrive location, you can edit the filename directly within the title bar area of the application, as follows:

  1. Open a document that's been saved to your OneDrive location or create a new document and save it to OneDrive. We are using the Invoice.docx document for this demonstration.
  2. Click into the document filename area, located on the title bar:
Figure 1.33 – Renaming a document that's been saved to OneDrive

Figure 1.33 – Renaming a document that's been saved to OneDrive

  1. Rename the document by editing the filename directly.
  2. The document will be updated and renamed.

When we save documents to our local personal computer, we will not be able to rename the document directly within Word. Upon accessing the dropdown to the right of the filename on the title bar, we will see that the ability to edit the filename is grayed out. We would need to upload the document to OneDrive first.

Figure 1.34 – When the File name field is grayed out, we will need to use the Upload button to save our document to OneDrive first

Figure 1.34 – When the File name field is grayed out, we will need to use the Upload button to save our document to OneDrive first

With that, we hope you are confident in managing OneDrive and saving files using the desktop app of OneDrive, as well as using the various online plans for Office 365.

Summary 

In this chapter, we learned about the new interface features of Office 2021 and discussed the differences between the online and desktop plans. We explored the immersive reader tools such as Read Aloud and looked at ways to enhance the users' experience when proofreading documents on-screen and renaming documents. The final section concentrated on managing the OneDrive experience in the cloud and on the desktop. We also learned how to troubleshoot sync errors.

The next chapter will focus on more of the new features that Office 2021 offers, as well as the latest revisions that have been made to the Office 365 offering. We will concentrate on dictation, co-authoring, and embedding.

We will also focus on a few more features that are new to Office standalone and web applications. You will learn how to access the new Transform feature so that you can integrate amazing presentations with Microsoft Sway. Then, you will learn how to dictate directly within Word 2021, where we will discuss all the options around the new Dictate feature.

Commenting and working in real time with others is also discussed here. There, we will look at co-authoring and investigate modern commenting, embedding, and converting.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • 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

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.

Who is this book 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.

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
Estimated delivery fee Deliver to Portugal

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 29, 2022
Length: 654 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803239736
Vendor :
Microsoft
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Portugal

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Publication date : Jul 29, 2022
Length: 654 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803239736
Vendor :
Microsoft
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 65.97
Working Smarter with Microsoft Outlook
€19.99
Learn Microsoft Office 2021
€25.99
Exploring Microsoft Excel's Hidden Treasures
€19.99
Total 65.97 Stars icon
Banner background image

Table of Contents

22 Chapters
Part 1: Learning Word 2021 Chevron down icon Chevron up icon
Chapter 1: Exploring the New Interface and Managing OneDrive Chevron down icon Chevron up icon
Chapter 2: Dictation, Co-authoring, and Embedding Chevron down icon Chevron up icon
Chapter 3: Styles, Referencing, and Media Chevron down icon Chevron up icon
Chapter 4: Managing Professional Documents Chevron down icon Chevron up icon
Part 2: Learning PowerPoint 2021 Chevron down icon Chevron up icon
Chapter 5: The PowerPoint Interface and Presentation Options Chevron down icon Chevron up icon
Chapter 6: Formatting Slides, Charts, and Graphic Elements Chevron down icon Chevron up icon
Chapter 7: Photo Albums, Sections, and Show Tools Chevron down icon Chevron up icon
Chapter 8: Mastering Best Practices with Presentations Chevron down icon Chevron up icon
Part 3: Learning Excel 2021 Chevron down icon Chevron up icon
Chapter 9: New Features, Filters, and Cleaning Data Chevron down icon Chevron up icon
Chapter 10: Exploring New and Useful Workflow Functions Chevron down icon Chevron up icon
Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards Chevron down icon Chevron up icon
Chapter 12: Useful Statistical and Mathematical Functions Chevron down icon Chevron up icon
Part 4: Outlook 2021 and Useful Communication Tools Chevron down icon Chevron up icon
Chapter 13: Creating and Attaching Item Content Chevron down icon Chevron up icon
Chapter 14: Managing Mail and Contacts Chevron down icon Chevron up icon
Chapter 15: Calendar Objects, Tasks, Notes, and Journal Entries Chevron down icon Chevron up icon
Chapter 16: Creating and Managing Online Meetings Chevron down icon Chevron up icon
Chapter 17: Presenting and Collaborating Online Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6
(15 Ratings)
5 star 66.7%
4 star 26.7%
3 star 6.7%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Craig Jahnke Jan 26, 2023
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book was really well written and has a lot of good tips for being better with Microsoft Office.My PowerPoint skill were really lacking, but I learned a lot of useful tips for making presentations, templates, and adding visual and graphs to my presentation. I was fairly good at Excel, but picked up some useful tips on sharing information between sheets an notebooks. I have also had issues with pivot tables and functions that I was able to figure out.Overall a good book that will help you learn new things even if you know the basics of the products.
Amazon Verified review Amazon
Gulraj Sep 13, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I was on the lookout for a referance point while utilizing MS Office & I encountered this amazing creation by Linda Foulkes. Linda manages to provide an insight into features that aren't used regularly by many of us. The knowledge sharing on Excel will be very helpful for me with data management. Looking forward to learning more on Microsoft Excel and other tools with more books from Packt.
Amazon Verified review Amazon
Saifali Suleman Oct 30, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The book on MS Office acts as an excellent resource for knowing about the capabilities of Microsoft Office apps. I've learnt multiple fresh concepts & implementation strategies. Very helpful for daily usage.
Amazon Verified review Amazon
theshark34 Sep 20, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I can recommend this book to everyone, wheater being a pro or a newbie to Microsoft Office 2021.First Chapter is about OneDrive, very useful to know since OneDrive is a super powerful cloud solution for every workspace.Personally I loved the part about Excel. Im working with Excel every day and I was suprised that I learned something new: conditional formatting rules. Very great explained!
Amazon Verified review Amazon
Mahendra Lokhande Sep 09, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Reading & practicing a lot of cool stuff mentioned in the book. Excellent tips on Outlook management & Pivot Tables within Excel. Beneficial read !
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact [email protected] with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at [email protected] using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on [email protected] with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on [email protected] within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on [email protected] who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on [email protected] within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela