Spreadsheet Fundamentals by DataCamp

This course will give you a deeper understanding about some of the core functions in Google Sheets. There are a number of predefined functions that we will be covering, such as SUM(), VLOOKUP ()`.., and AVERAGE ()`,,. These methods can be used to analyze school grades, track company performance statistics, track monthly revenues, and view real geographical information about countries around world.

This course will expand your Google Sheets vocabulary. This course will teach you how to use Google Sheets to manipulate logical and numerical data. Learn how to calculate summary statistics, and what error and missing types you can expect. Data sets will be provided on 100m sprint world records, asteroid close encounters and benefit claim.

Large amounts of data can be difficult and time-consuming to manage in spreadsheets. Would you like a quick and efficient way to organize and analyze all your data? Pivot Tables are the solution! This course will teach you how to quickly and efficiently organize thousands of datapoints using Google Sheets. We'll be looking at the average rainfall of several US cities as well as the Top 10 Fortune Global 500. We will also review some films that were released between 2010 and 2016. These examples will show you how to sort, filter, and subtotal your data. By the end of this course, you will be able to create custom pivot tables using any size data!

A picture can convey a thousand words but only if it is the right one. This course will show you how to use Google Sheets for data visualization. You will learn how to create simple chart types, such as histograms, scatter charts and bar charts. Also, you'll learn how to create more complicated types like sparkline or candlestick. How to prepare data, how to use Data Validation and VLookup formulas, and how to target specific data when charting. Conditional Formatting allows you to apply a particular format to a cell or range of cells based on specific criteria. You will also learn how to create dashboards that display data and plots together. Data from the Olympics, shark attacks, and Marine Technology from ASX will also be used.