In this Basic Excel Tutorial it's all about consolidation of data.
The consolidate function let's you easily (really easily!) group data and do math functions with them. To do this, remove duplicates is a great start! So let's take a look at those two together!
Excel: From Basics to Expert is a series that teaches you all you need to know about Microsoft Excel in short and applicable videos, you can follow along.
Subscribe for more videos around Microsoft 365, Excel and other applications for work and your productivity.