Spreadsheets

Join millions of people using Google Sheets and Microsoft Excel on a daily basis and learn the fundamental skills necessary to analyze data in spreadsheets! The skills you learn in these courses will empower you to join tables, summarize data, and answer your data analysis and data science questions.

Become a spreadsheet master. Learn the core skills you need to analyze data using Google Sheets and Microsoft Excel.

Spreadsheet Fundamentals

This chapter introduces a very useful feature in Google Sheets: predefined functions. You'll use these functions to solve complex problems without having to worry about specific calculations. We’ll cover a lot of predefined functions,  including functions for numbers, functions for strings, and functions for dates.

Predefined functions

In the last chapter of the course, you'll master more advanced functions like IF() and VLOOKUP(). Conditional and lookup functions won’t seem so scary after you completed this chapter.

Conditional functions and lookups

This course will dig deeper into some of the core functionality of Google Sheets. There's a whole bunch of predefined functions we'll cover, like `SUM()` and `AVERAGE()`, and `VLOOKUP()`. We'll apply these techniques to do some analysis on your grades in school, look at performance statistics within a company, track monthly sales, and look at some real geographical information about the countries of the world.

Learn how to analyze data with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().

Data Analysis in Spreadsheets

Programming

In which you learn to interrogate cells to determine the data type of their contents, and to convert between data types.

What's in a cell?

In which you learn to apply log and square root transformations to numbers, round them up and down, and generate random numbers.

Working with numbers

In which you learn how to work with logical data consisting of TRUE and FALSE values, and how to handle missing values and errors.

Logic  & Errors

In which you learn about cell addresses, advanced matching, sorting and filtering, and simple imputation.

Positional Matching

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. As you go, you'll explore datasets on 100m sprint world records, asteroid close encounters, benefit claims, and butterflies.

Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

Intermediate Spreadsheets

This chapter will discuss what a pivot table is, how it works, and will lead you through the steps of creating and setting up your first pivot table.

Introduction to Pivot Tables for Google Sheets

This chapter discuss how a pivot table works, and how it deals with the underlying data.

Behind the Scenes of the Pivot Table

This chapter will discuss more advanced options that will help you to get the most of your pivot tables.

Advanced Options

This chapter will walk you through modifying data in a pivot table, and troubleshooting various issues you may encounter.

 Editing Data and Troubleshooting

Working with large quantities of data in spreadsheets can be difficult and time-consuming. Have you ever wished there was a quick and efficient way to organize and evaluate your data within seconds? Pivot Tables are your answer! In this course we will explore the world of Pivot Tables within Google Sheets, and learn how to quickly organize thousands of datapoints with just a few clicks of the mouse. We will analyze the Average rainfall across multiple US cities, the Top 10 of the Fortune Global 500, and a selection of Films released between 2010 and 2016. You will learn techniques such as sorting, subtotaling, and filtering your data using these real world examples. By the end of the course, you will be able to create your own custom pivot tables with datasets of any size!

Explore the world of Pivot Tables within Google Sheets, and learn how to quickly organize thousands of data points with just a few clicks of the mouse.

Pivot Tables in Spreadsheets

Data Manipulation

Learn about business intelligence and dashboards for analyzing information in todays data-driven world.  Create a basic dashboard and master setting up your data to get the most out of it.

Business Intelligence and Using Dashboards

Create and format a column chart to showcase data and learn a few smart tricks along the way.  Look at using named ranges to refer to cells in your worksheet, making them user-friendly and easy to work with.

Efficient Column Charts

A dashboard is like a control panel.  Look at ways to allow a user to use this control panel to get different results from your dashboard.

Dashboard Controls

A picture paints a thousand words.  Look at what types of charts to use in what situation to showcase your data.

Other Charts for Your Dashboard

Learn how to use rules based on criteria you set to format certain cells on your dashboard. See the formatting change as the values in the cells change.

Conditional Formatting

A picture can tell a thousand words - but only if you use the right picture! This course teaches you the fundamentals of data visualization with Google Sheets. You'll learn how to create common chart types like bar charts, histograms, and scatter charts, as well as more advanced types, such as sparkline and candlestick charts. You will look at how to prepare your data and use Data Validation and VLookup formulas to target specific data to chart. You'll learn how to use Conditional Formatting to apply a format to a cell or a range of cells based on certain criteria, and finally, how to create a dashboard showing plots and data together. Along the way, you'll use data from the Olympics, sharks attacks, and Marine Technology from the ASX.

Learn the fundamentals of data visualization using spreadsheets. 

Learning Experience

Business Features

Academics

Spreadsheet Fundamentals

Create Your Free Account

Loved by learners at thousands of companies

Instructors

Loved by learners at thousands of companies

Instructors

Join over .css-w0wpus-TrackShowPage{color:#03ef62;}8,500,000 learners and start Spreadsheet Fundamentals today!

Create Your Free Account

Join over 8,500,000 learners and start Spreadsheet Fundamentals today!