Pass the PMP® Exam on Your First Try — Expert-Led Training
2,000+ Free Courses with Certificates: Coding, AI, SQL, and More
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn how to create and customize pivot tables from multiple Excel worksheets and workbooks in this 13-minute tutorial. Master the process of combining data from different sources using Power Query Editor, including importing data tables, appending queries, and transforming data. Follow along with downloadable sample workbooks to practice creating customized pivot tables, establishing data table relationships, and efficiently summarizing and analyzing data in various ways. Explore essential Excel data analysis techniques through step-by-step instructions, from launching the Power Query Editor to finalizing your pivot table setup.
Syllabus
Introduction
Overview of the data
Launch Power Query Editor
Import data tables
Append queries
Transform data
Make & customize pivot table
Relate data tables
Wrap up
Taught by
Kevin Stratvert