AccountingActuarial ScienceCorporate Innovation & EntrepreneurshipDivision of Undergraduate Students (DUS)FinanceManagementManagement Information SystemsMarketingPre-Major BusinessRisk ManagementSmeal Undergraduates and Smeal-Tracking StudentsSupply Chain & Information SystemsTechnical Skills for Business

Excel: PivotTables for Beginners

PivotTables don’t have to be scary! This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data. Dave begins by explaining two PivotTable basic building blocks: value fields and row fields. Then he shows you how to adjust a PivotTable by adding fields, filters, and formatting. Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. Plus, he goes over the basics of refreshing and updating a PivotTable. Finally, he’ll show you how to use AI in Excel to generate PivotTables automatically for you.

Learn More