Google Sheets Fundamentals

This track uses Spreadsheets/Google Sheets. You'll start by understanding the core functionality of spreadsheets and exploring how to use predefined functions to analyze data.

This Track will benefit a variety of different jobs including data analysts, business analysts, and other professionals who need to work with data and spreadsheets.

This Track will help you understand the core concepts of data analysis and spreadsheets, and learn how to analyze and visualize data efficiently and effectively. You'll discover how to use pivot tables to work with large quantities of data more efficiently and learn how to create different types of charts, including bar charts, histograms, scatter charts, sparkline, and candlestick charts. This will give you the necessary skills and knowledge to use spreadsheets and data analysis effectively in your career.

This Track will usually take 17 hours to complete as it consists of several courses that significantly upskill users. However, tracks are self-paced so users can spend as little or as long time as they like working through the exercises and courses.

Skill track focus on learning a specific skill, such as spreadsheets or programming. The courses are structured to upskill and refine learners' knowledge in a certain domain. A career track, on the other hand, focuses on developing a holistic skill set to help learners transition to new roles in the industry. These tracks are usually broader and more comprehensive.

This Track covers the fundamental skills necessary to analyze data in spreadsheets. You'll learn about data types, manipulation of numeric and logical data, missing data, and error types. You'll also learn how to use pivot tables to work with large quantities of data more efficiently and discover how to create different types of charts.

In this Track you will learn how to use Google Sheets and how to properly analyze data and use functions. Additionally, you'll learn how to use pivot tables to work with large quantities of data more efficiently and discover how to create different types of charts, including bar charts, histograms, scatter charts, sparkline, and candlestick charts, and how to use data validation and VLookup formulas.