Tip #1 - Adjust Pivot Table Settings

Select the gear icon to change the fields and areas section view. I prefer to view these side-by-side instead of the default stacked view.

If you have a lot of fields you can also sort them in alphabetical order ("Sort A to Z") instead of the default which is in Data Source Order.

Tip #2 - Active Vs. All

"Active" tab shows the list of table names that are part of your current Pivot Table. "All" includes all tables in your model.

If you'd like to add tables to the "Active" tab without adding fields to your existing Pivot Table, you can right-mouse click on a table name in the "All" tab and select "Show in Active Tab".

Tip #3 - Use the Search Box

Find fields faster by typing the name in the search box.

BONUS TIPS

Power Pivot Tab disappeared!

In case your Power Pivot Tab disappears, you can activate it from File / Options / Add-ins / Manage / COM Add-ins / GO and place a check mark beside "Microsoft Power Pivot for Excel".

Change Default Pivot Table Layout

If you have Office 365 or Excel 2019 & higher, you can choose a default layout for your Pivot Table from File / Options / Data / Make Changes to the Default Pivot Tables.

This is covered in more detail in lecture: Adjust Default PivotTable Options in Section 3.