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

Summary

You have now learned valuable skills for visualizing and analyzing data in this chapter, using powerful tools such as PivotTable to create slicers and timelines, and you can now create dashboards and PivotCharts and customize your PivotTable reports. You are now able to put your date and time functions into practice as you are equipped with all the relevant functions applicable to each of these function categories.

In the next chapter, we will build on prior skills to work with math and trigonometry and statistical functions using Excel 2021 and introduce some additional functions to the mix. We will explore how to generate random numbers using RANDBETWEEN and RAND functions. In addition, we will work through examples of PRODUCT functions, including the SUMPRODUCT, MROUND, FLOOR, TRUNC, AGGREGATE, and CONVERT functions.

We will investigate the MEDIAN, COUNTBLANK, and AVERAGEIFS statistical functions in the next chapter, with which you can experiment and apply to existing...