Make connections between multiple worksheets.
Perform data analysis.
Automating actions through the use of macros.
Analysis of data in tables and lists
-Creation, sorting and filtering data
Creating and formatting a dynamic table
Use of totals and subtotals
Formulas in dynamic tables