After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
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.
Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Identify the correct spreadsheet navigation and cell-selection methods, including cell references and cell ranges.
- Recognize supported file types and identify appropriate import options for loading data into Google Sheets.
- Identify the correct use of formulas, arithmetic operators, percentage calculations, and comparison operators to perform numerical and Boolean evaluations.
- Differentiate between cell data types (plain text, number, date, currency) and identify appropriate formatting options such as decimal precision.
- Distinguish between relative and absolute cell references and identify when to apply each in calculations and copied formulas.
Prerequisites
There are no prerequisites for this course
Curriculum
Course outline
1
Cells and Formulas
You’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 XP
- Importing data into Google Sheets50 XP
- Changing cell contents100 XP
- Cell ranges100 XP
- Cell mathematics!50 XP
- Formulas100 XP
- Exponents and parentheses100 XP
- Percentages100 XP
- Data types and formatting50 XP
- Working with text and numbers100 XP
- Working with currencies and dates100 XP
- Comparison 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.
S
Introduction to Google Sheets
Course
Complete
