Microsoft Excel Pivot Tables - Full Course

Learning objectives
Determine when it is necessary to click Defer Layout Update in the area of the field.
Recall the easiest way to create a PivotTable from external data that cannot be imported directly as an Excel table.
Explain the configuration that takes up the least width on the screen while keeping the Fields List area visible.
Identify the mistakes users often make when creating filters.
Explore the function of slicers.
Review the use of data bars with a Pivot Table.
Name the first step in viewing all the conditional rules applied to a PivotTable.
Recognize the appropriate way to save a macro.