Pivot Tables are extremely useful in Excel. This Advanced Excel video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics. The lesson goes over some additional Pivot Table options and features including: - Drill-down functionality which creates a summary sheet of any Pivot Table amount selected.