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. Finally, Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. At the end, he goes over the basics of refreshing and updating a PivotTable.
Learn More- Seek Your Pathways
- Explore Academics
- Anthropology
- Communication
- Economics
- Journalism
- Landscape Architecture
- Legal Studies
- Managerial Economics
- Political Science
- Public Policy
- Resource Economics
- Social Thought & Political Economy (STPEC)
- Sociology
- Sustainable Community Development
- SBS Exploratory Track
- Minors, Certificates, and More
- SBS 4+1 Accelerated Masters Programs
- Explore Careers
- What are Career Communities?
- Advertising / Public Relations / Marketing
- Business / Entrepreneurship / Management / Consulting
- Health / Research / Education / Culture
- Environment / Natural Resources / Sustainability
- Finance / Investment / Real Estate / Insurance
- Government / Public Policy / International Relations
- Law / Legal Services / Criminology / Forensics
- Media / Journalism / Entertainment
- Non-Profit / Social Justice / Activism
- Technology / Data / Analytics
- Our Diverse Communities
- What Are Diverse Communities?
- SBS RISE: Remedying Inequity through Student Engagement
- Black, Indigenous & Students of Color
- First Generation Students
- International Students
- LGBTQIA+ Students
- Student Athletes
- Students with Disabilities
- Students with Financial Need
- Transfer Students
- Veterans
- Women in the Workforce
- Post-Grad Planning
- Who We Serve
- How do I?
- Complete Academic/Degree Tasks
- Apply for Scholarships and Awards
- Declare an SBS Major
- Meet with an Academic Advisor
- Meet with an Academic Dean
- Suggest New Courses
- Petition for Late Add
- Petition for Pass/Fail
- Withdraw from a Class/Petition for Late Withdrawal
- Petition for Course Credit Overload
- Release Academic Information (FERPA)
- Withdraw from the University
- Explore Majors, Experiential, and Professional Pathways
- Apply for Funding for Internships, Study Abroad, Research, and other High-impact Opportunities
- Assess My Skills and Interests
- Explore Majors
- Find an Undergraduate Research Opportunity
- Get Involved on Campus
- Learn about Different Career Paths
- Study Abroad
- Take Courses through the Five Colleges
- Domestic Exchange
- Get Career Ready
- Apply for Scholarships to Support Research or Internships
- Develop My Job Search Skills & Strategy
- Look for Internships and Jobs
- Meet with a Career Advisor
- Negotiate an Offer
- Network and Connect with Mentors
- Prepare a Resume and Cover Letter
- Prepare for/Navigate a Career Fair
- Prepare for an Interview
- Register an Internship for Credit
- Write a Personal Statement for Graduate School
- Complete Academic/Degree Tasks