Intermediate Google Sheets
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Comience El Curso Gratis4 horas12 vídeos48 ejercicios
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?Pruebe DataCamp para empresas
Preferido por estudiantes en miles de empresas
Descripción del 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.Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Google Sheets
Ir a la pista- 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
Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Google Sheets
Ir a la pistarequisitos previos
Data Analysis in Google SheetsRichie Cotton
Ver MásData Evangelist at DataCamp
¿Qué tienen que decir otros alumnos?
¡Únete a 14 millones de estudiantes y empieza Intermediate Google Sheets hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.