Live training

Pivot Tables in Excel

Join us for this live, hands-on training where you will learn how to analyze survey data using pivot tables and charts in Microsoft Excel. You'll learn how to go from raw data to efficient data analysis as well as how to create dynamic visualizations. This session will run for 2.5 hours, allowing you time to really immerse yourself in the subject, and includes short breaks and opportunities to ask the expert questions throughout the training.

Tuesday 4 August, 3 PM EDT, 8 PM BST
Register Now
Spreadsheet

What will I learn?

You will learn how to:
  • Prepare raw data for use in analysis using data tables.
  • Create pivot tables and adjust the inputs to reflect the type analysis you want to perform.
  • Use pivot charts to visualize pivot tables.

What should I prepare?

Learners should have access to Excel or Google Sheets. The session will be based in Excel.

Who should attend?

This course is open to all DataCamp Premium learners, looking to go beyond simple analysis based on formulas to more efficient analysis using pivot tables. We recommend that you have taken the following course before attending:

  • Pivot Tables in Spreadsheets
  • Data Analysis in Excel

Presenter Bio

Jen Bricker Headshot

Jen Bricker

Head of Career Services

Jen leads the Career Services team mentoring learners during their job search. Previously, she led the Instructor Success team hiring hundreds of data scientists, working with them to build DataCamp content. Prior to DataCamp, she worked in non-profit management as well as data analytics adult education. Her career has always centered around her two main passions - people and data!
Follow on LinkedIn