Agenda
1. Agenda
Let's start by going over the agenda for the course. Module one begins with a look at advanced formatting with Google Sheets. You'll learn how to apply and customize themes in Google Sheets and explore conditional formatting options. In module two, you will learn about some of Google Sheets' advanced formulas and functions. We will look at creating formulas, using functions, and referencing and validating data. Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all that data can be difficult without a summary or visualization. In module three, we will explore the data visualization options in Google Sheets, such as charts and pivot tables. We'll also look at ways to automate repetitive tasks using macros. Module four introduces Google Forms. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. In this module, we're going to examine how forms and sheets work together by connecting collected form data to a spreadsheet or by creating a form from an existing spreadsheet. And at the end of the course, you will use Google Sheets to help Thomas Omar from On the Rise solve his forecasting challenge.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.