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

Spreadsheet software is one of the most popular and powerful tools in data analysis. Millions of people use tools like Google Sheets or Microsoft Excel on a daily basis. Even the most experienced data scientists often started their careers with spreadsheets and still use it to test assumptions or to look at data for the first time. In this course, you will learn the basics of spreadsheets by working with rows, columns, addresses, and ranges. You will create your own formulas and learn how to use references.

Learn the basics of spreadsheets by working with rows, columns, addresses, and ranges. 

Discover the basics of spreadsheets by working with rows, columns, addresses, and ranges, then create your own formulas and learn how to use references.

Introduction to Spreadsheets

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.

Learn about Google Sheets by practicing manipulating numeric and logical data, exploring missing data and error types, and calculating summary statistics.

Intermediate Spreadsheets

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

Statistics is the science that deals with the collection, analysis, and interpretation of data. Having a solid foundation in statistics will help you effectively work with your data to test hypotheses and uncover insights that can help solve your problems. This course is designed to give you that foundation in statistics. Using Spreadsheets functions, you'll dive into averages, distributions, hypothesis testing, and conclude the course by applying your newfound knowledge in a case study. Along the way, you'll work with a variety of datasets ranging from eBay auctions to train ridership to historical presidential approval ratings. Enjoy!

Learn how to leverage statistical techniques using spreadsheets to more effectively work with and extract insights from your data.

Introduction to Statistics in Spreadsheets

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. 

Learn how to create different chart types, from bar charts, histograms, and scatter charts, to advanced sparkline and candlestick charts in Google Sheets.

Data Visualization in Spreadsheets

Spreadsheets are an essential tool for any marketing professional, but how does one keep these spreadsheets clean and accurate - especially when multiple parties contribute data? Data validation and regular expressions are powerful tools for marketing analysts, but having clean data is only half the battle. After we learn how to clean the data, we will visualize it by building charts! Throughout the course, we will explore a dataset that includes the kind of information you will encounter in the world of digital marketing. We will spot errors in metrics using data validation, use regular expressions to aggregate campaign metrics, build charts to analyze campaign performance, and use everything we've learned to build a dynamic dashboard!

Learn how to ensure clean data entry and build dynamic dashboards to display your marketing data.

Marketing Analytics in Spreadsheets

You rely on predictions every day: you might check the weather app before choosing your outfit or peek at the traffic before starting your commute. Perhaps you are responsible for setting your organization’s strategy in the future. Do you find yourself wondering how accurate predictions are, how you can see into the future, and why the weatherman always seems to be wrong? In our Error and Uncertainty course, you’ll make some predictions yourself, learn to distinguish real differences from random noise, and explore psychological crutches we use that interfere with our rational decision making. You will uncover patterns in Seattle crime data, predict students’ final grades, prevent Nashville traffic accidents, and determine whether a bakery’s menu needs to change. Join us! We’re certain you’ll enjoy learning about error and uncertainty.

Learn to distinguish real differences from random noise, and explore psychological crutches we use that interfere with our rational decision making.

Error and uncertainty in spreadsheets

Error and Uncertainty in Spreadsheets

Spreadsheets often suffer from having too much data. If you want to tell the underlying story that is in the data without creating additional reports, conditional formatting can help! Whether it's showing the age of your inventory by highlighting the items using a color scale, or accentuating the largest variances in year over year financial data, conditional formatting has built-in options that can be used without any complex code. It can be used instead of sorting or filtering since it works with the data that is already there! By the end, you will be creating your own report using conditional formatting to analyze a company's payroll.

Learn how to use conditional formatting with your data through built-in options and by creating custom formulas. 

Conditional Formatting in 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

Save yourself hours when working with Microsoft Excel and Google Sheets and gain spreadsheet skills you can use every day. 

In this track, you’ll learn time-saving methods such as data validation and gain a foundation of statistical concepts to quickly calculate averages and analyze data. Through hands-on exercises, you’ll expand your spreadsheet mastery and create impressive visualizations, including histograms, scatter plots, and bar plots. You’ll also leverage your data validation skills and more advanced techniques such as regular expressions to create your own marketing dashboard using real-world digital marketing data.

Expand your spreadsheet skills. Learn how data validation, statistics, and regular expressions can save you time with Excel and Sheets!

Take your Tableau skills up a notch with advanced analytics and visualizations. In this course, you’ll learn how to create detail-rich map visualizations, configure date and time fields to show trends over time, and extend your data using Calculated Fields. You’ll also apply your new skills to complete a customer analytics case study. Through hands-on activities, you’ll learn how to create bins, customize filters and interactions, and apply quick table calculations. Finally, you’ll learn power user techniques, including how to slice and dice data and apply dynamic sets and groups—bringing you one step closer to being Tableau Desktop Specialist certification-ready.

Data Science Courses

Data Science Tracks

Our Learning Experience

@esogbesan

Workspace Publications (0)

Completed Tracks(2)

Completed courses (9)

Completed Projects (0)