Book Image

Learn Microsoft Office 2021 - Second Edition

By : Linda Foulkes
Book Image

Learn Microsoft Office 2021 - Second Edition

By: Linda Foulkes

Overview of this book

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.
Table of Contents (23 chapters)
1
Part 1: Learning Word 2021
6
Part 2: Learning PowerPoint 2021
11
Part 3: Learning Excel 2021
16
Part 4: Outlook 2021 and Useful Communication Tools

Working with dates

In this topic, we will enhance our knowledge of date functions within Excel 2021.

Understanding how dates are interpreted

After typing a date into a worksheet cell, we will only see the formatting of that date (the cosmetic change). If Excel recognizes the date you have typed into a cell on the worksheet, it will automatically align the date to the right of the cell immediately, and apply the date format. To understand visually how a date is actually presented in the cell behind the formatting, we could remove the cell formatting. Let's look at an example.

If we type the number 1 into a cell and then format the cell to display the Short Date format, we will visually see the number 1 displayed as the date 01/01/1901 in the cell. 01/01/1901 is the actual starting date in Excel, and 31/12/9999 is the end, or last date, that Excel interprets. When we remove the formatting, by clearing the format (Home | Clear | Clear Formats), we will see the actual...