Intermediate Google Sheets
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Kurs Kostenlos Starten4 Stunden12 Videos48 Übungen50.796 LernendeLeistungsnachweis
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.Trainierst du 2 oder mehr?
Versuchen DataCamp for BusinessBeliebt bei Lernenden in Tausenden Unternehmen
Kursbeschreibung
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.Für Unternehmen
Trainierst du 2 oder mehr?
Erhalten Sie für Ihr Team Zugriff auf die vollständige DataCamp-Bibliothek mit zentralisierten Berichten, Zuweisungen, Projekten und mehrIn den folgenden Tracks
Google Sheets Grundlagen
Gehe zu Track- 1
What's in a cell?
KostenlosIn 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
Für Unternehmen
Trainierst du 2 oder mehr?
Erhalten Sie für Ihr Team Zugriff auf die vollständige DataCamp-Bibliothek mit zentralisierten Berichten, Zuweisungen, Projekten und mehrIn den folgenden Tracks
Google Sheets Grundlagen
Gehe zu TrackVoraussetzungen
Data Analysis in Google SheetsRichie Cotton
Mehr AnzeigenData Evangelist at DataCamp
Was sagen andere Lernende?
Melden Sie sich an 14 Millionen Lernende und starten Sie Intermediate Google Sheets Heute!
Kostenloses Konto erstellen
oder
Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.