Video Lesson: Advanced Pivot Tables – Round 2

Advanced Pivot Tables Round 2

This lesson picks up right where the last Pivot Table lesson left off.

In this tutorial, you will learn:

  • How to use multiple levels of data within row or column labels.
  • Expand / collapse all functionality through right-click (Expand / collapse entire field)
  • Advanced filtering options including: right-click, row label, column label, and report filters. Includes multiple simultaneous filters, and using search/filter functionality within each data level.
  • ‘Defer Layout Update’ option which allows for changing fields without pivot table automatically updating.
  • Fields Section / Areas Section Stacked vs. Other Pivot Field List Formats.

Make sure to download the Advanced Pivot Tables – Round 2 workbook to follow along with the lesson!

If you’re following along with the Lesson Guide, next up is Auto-Filter and Advanced Data Filtering

Excel Video Lesson: Advanced VLOOKUP Examples

Advanced Vlookup Examples

The VLOOKUP function is one of the most frequently used functions in all of Excel.  In this video lesson I go over some advanced usages of the VLOOKUP function including:

– In-depth overview of the VLOOKUP syntax:

= VLOOKUP ( lookup_value, table_array, col_index_num, range_lookup ).

– Examples of how to set up intelligent formulas which pull information based on other cells rather than typed in (aka hard-coded) values.

– How to set up an intelligent order query which pulls a full row of information about different orders using one formula that gets copied and pasted.

Download the Advanced VLOOKUP Examples workbook to follow along with the video.