Introduction to Google Sheets
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
Kurs Kostenlos Starten2 Stunden7 Videos26 Übungen28.672 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
Google Sheets stands out as one of the premier data analytics tools, empowering millions of users worldwide to extract valuable insights from diverse datasets. Whether you're a professional seeking to enhance your analytical skills or a novice eager to dive into the world of data, our comprehensive online course is tailored for you.
Mastering Spreadsheet Fundamentals
Delve into the core of spreadsheet functionality as you embark on a journey to grasp the fundamentals of Google Sheets. Through hands-on exercises, you'll gain proficiency in working with tabular data and executing intricate calculations. This course goes beyond the basics, equipping you with the skills to create your own formulas, ensuring you have the tools to manipulate and analyze data effectively. Explore the art of referencing cells, fostering a deep understanding of how to interconnect data points and breathe life into your spreadsheets.
Become a Formula Maestro and Spreadsheet Architect
Elevate your spreadsheet prowess by becoming a formula maestro and a spreadsheet architect. Uncover the secrets of crafting complex formulas that can tackle real-world data challenges. Learn how to design spreadsheets that not only organize information seamlessly but also communicate insights effectively. Whether you're looking to streamline work processes or make data-driven decisions, this course provides you with the knowledge and skills to transform Google Sheets into a powerful tool in your professional toolkit.
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
Google Sheets Grundlagen
Gehe zu Track- 1
Cells and Formulas
KostenlosYou’ll begin by learning how to use spreadsheets to extract insights from your data. In this chapter, you'll learn how to write formulas, perform calculations in spreadsheets, use comparison operators, and format cells.
Navigating Google Sheets50 xpImporting data into Google Sheets50 xpChanging cell contents100 xpCell ranges100 xpCell mathematics!50 xpFormulas100 xpExponents and parentheses100 xpPercentages100 xpData types and formatting50 xpWorking with text and numbers100 xpWorking with currencies and dates100 xpComparison operators and logicals100 xp - 2
Cell References
In this chapter, you'll learn about one of the most powerful concepts in spreadsheets: cell references. Using geographical and demographical data from the ten most populous countries, you'll utilize cell references to make your spreadsheets reactive to changes and learn useful shortcuts to start applying calculations at scale.
Introduction to cell references50 xpUsing cell references100 xpCircular references50 xpCopying references100 xpCalculations with cell references50 xpMathematical operators and references100 xpPercentages and references100 xpComparison operators and references100 xpAbsolute references50 xpUsing absolute references100 xpAbsolute references: fixing rows100 xpAbsolute references: fixing columns100 xpReferences everywhere!100 xpCongratulations!50 xp
Trainierst du 2 oder mehr?
Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.In den folgenden Tracks
Google Sheets Grundlagen
Gehe zu TrackMitwirkende
James Chapman
Mehr AnzeigenCurriculum Manager, DataCamp
Was sagen andere Lernende?
Melden Sie sich an 15 Millionen Lernende und starten Sie Introduction to 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.