You're reading from Learn Microsoft Office 2021 Your one-stop guide to upskilling with new features of Word, PowerPoint, Excel, Outlook, and Teams

Product type Paperback

Published in Jul 2022

Publisher Packt

ISBN-13 9781803239736

Length 654 pages

Edition 2nd Edition

Tools

Excel

Concepts

Document Preparation

Author (1):

Linda Foulkes

View More author details

Table of Contents (23) Chapters

Preface

1. Part 1: Learning Word 2021

2. Chapter 1: Exploring the New Interface and Managing OneDrive FREE CHAPTER

3. Chapter 2: Dictation, Co-authoring, and Embedding

4. Chapter 3: Styles, Referencing, and Media

5. Chapter 4: Managing Professional Documents

6. Part 2: Learning PowerPoint 2021

7. Chapter 5: The PowerPoint Interface and Presentation Options

8. Chapter 6: Formatting Slides, Charts, and Graphic Elements

9. Chapter 7: Photo Albums, Sections, and Show Tools

10. Chapter 8: Mastering Best Practices with Presentations

11. Part 3: Learning Excel 2021

12. Chapter 9: New Features, Filters, and Cleaning Data

13. Chapter 10: Exploring New and Useful Workflow Functions

14. Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards

15. Chapter 12: Useful Statistical and Mathematical Functions

16. Part 4: Outlook 2021 and Useful Communication Tools

17. Chapter 13: Creating and Attaching Item Content

18. Chapter 14: Managing Mail and Contacts

19. Chapter 15: Calendar Objects, Tasks, Notes, and Journal Entries

20. Chapter 16: Creating and Managing Online Meetings

21. Chapter 17: Presenting and Collaborating Online

22. Other Books You May Enjoy

Chapter 11: Date-Time Functions and Enhancing PivotTable Dashboards

In this chapter, we will explore date functions and look at how to work with time. Here, we concentrate on DATEDIF(), YEARFRAC(), EDATE(), WORKDAY(), and many more functions to be more productive in the workplace. In addition, a large part of this chapter will explore a host of PivotTable customizations and a walk-through on creating dashboards. We will also learn to construct the GETPIVOTDATA function to reference cells in a PivotTable report.

The following topics are covered in this chapter: