Chapter 9: New Features, Filters, and Cleaning Data
In the previous edition of this book, we concentrated on all the basic skills concerning data entry, including being able to distinguish between spreadsheet elements, as well as the various output options. In this chapter, you will learn about essential updates for, and the new features of, Excel 2021. You will learn all about Advanced Filter and the new FILTER function, as well as more about conditional formatting rules. We will focus on cleaning data and learning how to import, clean, join, and separate data while learning about some of the new features of Excel 2021 along the way, such as the UNIQUE function.
In this chapter, we will cover the following topics:
- New features to enhance ...
Get Learn Microsoft Office 2021 - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
