Skip to main content

Data Analysis in Spreadsheets

Learn to use spreadsheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.

Start Course for Free
3 Hours11 Videos34 Exercises
7,888 Learners

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Course Description

Learn how to clear and analyze data in spreadsheets, discover how to use built-in functions to sort and filter data, and use the VLOOKUP function to combine data from different tables. The skills taught in the course can be applied to various industries, such as finance and marketing.

Perform Data Analysis in Spreadsheets

Spreadsheets are the world's most popular data analytics tool. Companies and institutions worldwide use it to transform mountains of raw data into clear insights. Strong spreadsheet skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks.

Clean and Analyze Real-World Data

The course begins by exploring how spreadsheets handle data. You’ll learn to summarize your data using statistics and manipulate it using handy built-in functions to sort, filter, and even extract unique values.

You'll explore the data behind the moons of the Solar System, clean and prepare data on the highest-grossing films, and analyze employee expenses, manufacturing costs, and educational programs to see how your new skills can be applied across industries.

Learn How to Use VLOOKUP

Later chapters in this course will teach you how to analyze your data, including using conditional functions, creating logical expressions, and performing conditional aggregation. You’ll also learn to use ‘the most important function in spreadsheets,’ VLOOKUP, to combine data from different tables before testing your understanding in hands-on exercises.

These spreadsheets skills, functions, and time-saving shortcuts can be applied to any industry, whether you’re looking to move to a career in data analysis, or looking to improve your skills in marketing, finance, HR, logistics, and more.
  1. 1

    Exploring Data

    Free

    Learn how data analyst skills in spreadsheets can help you draw clearer insights from data. In this chapter, you'll learn how built-in functions can streamline your spreadsheet workflows and improve the readability of your formulas. You'll learn data exploration techniques, such as calculating summary statistics and manipulations like sorting and filtering.

    Play Chapter Now
    Built-in functions
    50 xp
    The data analysis way!
    50 xp
    Rounding values
    100 xp
    Summary statistics
    50 xp
    Measures of center
    100 xp
    Counting cells
    100 xp
    Sorting and filtering
    50 xp
    How big are Jupiter's moons?
    100 xp
    Bringing order to the universe!
    100 xp
  2. 2

    Cleaning and Preparing Data

    It is often said that data professionals spend 80% of their time cleaning data and only 20% analyzing it. In this chapter, you'll learn useful functions for cleaning text and DateTime data, two of the trickiest data types to clean. You'll extract date and time components, calculate intervals, and perform a host of common text manipulations on a dataset of the highest-grossing films.

    Play Chapter Now
    Extracting date and time components
    50 xp
    Extracting years and months
    100 xp
    Extracting weekday components
    100 xp
    Calculating date intervals
    50 xp
    How long has it been?
    100 xp
    Intervals between observations
    100 xp
    Cleaning text data
    50 xp
    Changing cases
    100 xp
    Combining text data
    100 xp
    Manipulating text data
    50 xp
    Counting characters
    100 xp
    Extracting characters
    100 xp
    Substituting characters
    100 xp
  3. 3

    Analyzing Data

    In this chapter, you'll learn to draw insights from your data. You'll perform complex calculations using conditional functions, logical expressions, and conditional aggregation functions. You'll also learn and apply the most important spreadsheet function: VLOOKUP!

    Play Chapter Now
    Conditional functions and logic
    50 xp
    Logical expressions
    100 xp
    Calculating product costs
    100 xp
    Evaluting employee performance
    100 xp
    Conditional aggregations
    50 xp
    Analyzing expenses with conditional aggregation
    100 xp
    Number of reports by person and type
    100 xp
    Total expenditure by person and type
    100 xp
    VLOOKUP
    50 xp
    Unsorted lookups
    100 xp
    Sorted lookups
    100 xp
    Congratulations!
    50 xp

In the following tracks

Spreadsheet Fundamentals

Datasets

Kickstarter GamesMoons of the Solar SystemHighest Grossing FilmsManufacturing CostsEmployee ExpensesEducational Programs

Collaborators

Collaborator's avatar
Amy Peterson

Prerequisites

Introduction to Spreadsheets
James Chapman HeadshotJames Chapman

Curriculum Manager, DataCamp

James is a Curriculum Manager at DataCamp. He has a Master's degree in Physics and Astronomy from Durham University, where he specialized in quasar detection and tutored Math and English. He joined DataCamp as a learner in 2018, and the data skills learned on DataCamp were quickly integrated into his scientific projects. In his spare time, he enjoys restoring retro toys and electronics.

Follow James on LinkedIn
See More

What do other learners have to say?

    FAQs

    Join over 12 million learners and start Data Analysis in Spreadsheets today!

    Create Your Free Account

    GoogleLinkedInFacebook

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.