Earners of the Microsoft Excel 2019 (Advanced) have gained the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.