Pular para o conteúdo principal

# Data Analysis in Google Sheets

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

Comece O Curso Gratuitamente
3 Horas11 Videos34 Exercicios
12.961 AprendizesDeclaração de Realização

## Crie sua conta gratuita

ou

Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.
Treinar 2 ou mais pessoas?Experimente o DataCamp For Business

## Descrição do Curso

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.
Para Empresas

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.

Ir para a trilha
1. 1

### Exploring Data

Grátis

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.

Reproduzir Capítulo Agora
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.

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!

Para Empresas

### GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

### Nas seguintes faixas

Ir para a trilha

Kickstarter GamesMoons of the Solar SystemHighest Grossing FilmsManufacturing CostsEmployee ExpensesEducational Programs

James Chapman

Curriculum Manager, DataCamp

Veja Mais