This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also learn how to use text functions to manipulate non-numeric data. Prerequisite: Excel 2019 Basic or equivalent knowledge.