Intermediate Google Sheets
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Comece O Curso Gratuitamente4 horas12 vídeos48 exercícios50.979 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?
Tentar DataCamp for BusinessAmado por alunos de milhares de empresas
Descrição do Curso
This course will expand your Google Sheets vocabulary. You'll dive deeper into data types, practice manipulating numeric and logical data, explore missing data and error types, and calculate some summary statistics.
Advanced Data Types and Manipulation
In the first part of the course, we focus on understanding and manipulating various data types in Google Sheets. You'll gain proficiency in handling numeric and logical data, crucial for effective data analysis. This section is designed to build your skills in data manipulation, teaching you techniques to manage and transform data efficiently. Whether you're dealing with large datasets or complex data structures, these skills are essential for making the most out of your data in Google Sheets.Dealing with Missing Data and Errors
A common challenge in data analysis is dealing with missing data and error types. This course guides you through the intricacies of identifying and managing missing data, as well as understanding and resolving various error types that can occur in Google Sheets. You'll learn how to clean your data, ensuring its accuracy and reliability. This is a critical skill for anyone looking to conduct thorough and error-free data analysis.Practical Application with Real Datasets
Throughout the course, you'll apply what you've learned using real-world datasets. These include records of 100m sprint world records, asteroid close encounters, benefit claims, and data on butterflies. By exploring these diverse datasets, you'll learn how to calculate summary statistics and gain insights from real data. This hands-on experience not only reinforces your learning but also prepares you to tackle a wide range of data analysis tasks with confidence.Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
Fundamentos do Planilhas Google
Ir para a trilha- 1
What's in a cell?
GratuitoIn which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.
Data types for data science50 xpWhat IS*() the data type?100 xpChecking rarer data types100 xpFinding missing data100 xpDteectnig bdaly tpyed dtaa100 xpConvert or die!50 xpMaking numbers while the sun shines100 xpHow the 104% live100 xpConverting logical values to numbers100 xpPreaching to the CONVERT()ed100 xp - 2
Working with numbers
In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.
Common data transformations50 xpLogarithmic transformations100 xpExponential transformations100 xpSquare root transformations100 xpRounding and formatting numbers50 xpRound and round100 xpFrom floor to ceiling100 xpRounding negative numbers100 xpGenerating random numbers50 xpGenerating uniform random numbers100 xpGenerating random numbers from other distributions100 xp - 3
Logic & Errors
In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.
Logical operations50 xpLogical operations are hard... NOT!100 xpAND now for something completely different100 xpYea OR nay100 xpFlow control50 xpIF only100 xpLots of IFS100 xpSWITCH it on!100 xpBlanks, missing values, & errors50 xpBlankety blank100 xpGoing missing100 xpErrors and omissions100 xpWhat's the problem?50 xp - 4
Positional Matching
In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.
Cell addresses50 xpWorking with cell addresses100 xpFrom addresses to values100 xpFinding nearby cells with offsets100 xpLocal addresses100 xpLookups & matching50 xpA VLOOKUP refresher100 xpSorted!100 xpMatching values100 xpBringing it all together50 xpAdvanced filtering100 xpConditional summary statistics100 xpSimple imputation100 xpCongratulations!50 xp
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
Fundamentos do Planilhas Google
Ir para a trilhapré-requisitos
Data Analysis in Google SheetsRichie Cotton
Ver MaisData Evangelist at DataCamp
O que os outros alunos têm a dizer?
Junte-se a mais de 15 milhões de alunos e comece Intermediate Google Sheets hoje mesmo!
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.