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 12: Useful Statistical and Mathematical Functions

Office 2021 includes a range of mathematical and statistical functions, some of which are considered important foundational skills to build more complex formulas.

We will build on prior skills to work with Math & Trig 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.

In addition, we will investigate the MEDIAN, COUNTBLANK, and AVERAGEIFS statistical functions in this chapter, from which you can experiment and apply to existing or new scenarios when working with workbook data.

The following topics are covered in this chapter: