Introduction to Google Sheets
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.
Commencer Le Cours Gratuitement2 heures7 vidéos26 exercices28 672 apprenantsDéclaration de réalisation
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.Formation de 2 personnes ou plus ?
Essayer DataCamp for BusinessApprécié par les apprenants de milliers d'entreprises
Description du cours
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.
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
Principes de base de Google Sheets
Aller à la piste- 1
Cells and Formulas
GratuitYou’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
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
Principes de base de Google Sheets
Aller à la pistecollaborateurs
James Chapman
Voir PlusCurriculum Manager, DataCamp
Qu’est-ce que les autres apprenants ont à dire ?
Inscrivez-vous 15 millions d’apprenants et commencer Introduction to Google Sheets Aujourd’hui!
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.