Data Analysis in Excel

Join us for this hands-on training where you will learn about how to use Excel for cleaning and analyzing data. This session is intended for beginner spreadsheet users who want to learn how to go from raw data to calculating key insights.

What will I learn?

You will learn how to:

• Understand the data analysis process

• How to clean and prepare data

• How to combine data from two or more tables using VLOOKUP()

• How to use aggregate and conditional functions

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 gain confidence in working with data in Excel. We recommend that you have taken this course before attending:

• Data Analysis in Excel

Resources

• Spotify Data

• Spotify Data Solution

• Slides

Jen Bricker

Head of Instructor Success, DataCamp