After completing these steps, Excel will generate a basic Pivot Table based on your selections, ready for further customization. Excel Pivot Tables Beginner to Pro Guide Watch this video on YouTube.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. Pivot tables in Excel allow ...