Microsoft Excel: Tips and Tricks with Tables and Pivot Tables

Sheldon Dueck trained us on Excel and the use of tables, which are among the most powerful tools in Excel. We worked through different Pivot Table layouts, how to search for data within a Pivot Table, and some practical examples of using a Pivot Table to create automated reports. We also discussed how tables can fit into our day to day activities as financial staff, and highlighted useful features within tables.

A copy of the workbook can be found here.