| Learn proficiency in validating data, creating and modifying list ranges, sorting database data, using database functions, using the Advanced Filter and Automatic Subtotal features, creating and modifying PivotTables and PivotCharts, formatting and adjusting PivotTables, auditing worksheets, performing what-if analyses, and working with scenarios |