
Mark welcomes you to the course and tells you what to expect.
You'll hit the ground running and develop your first spreadsheet in Google Sheets. Part I.
You'll hit the ground running and develop your first spreadsheet in Google Sheets. Part II
Create formulas and use built-in Google Sheets functions to do the calculations in your Spreadsheet. Complete the exercise after watching the video lectures in this section.
Themes is a new feature in Google Sheets that will ensure your spreadsheet look their best.
Learn about the different ways that Google Sheets can handle and display numbers.
Learn how to format text cells in Google Sheets.
Learn how to wrap and rotate text within cells. Complete this exercise after watching the video lectures and downloading the .xlsx file in this section.
Learn different methods for storing data within a Google Sheets Spreadsheet.
Filtering allows you to set criteria for data displayed within a spreadsheet. Learn how to create filters in Google Sheets in this video.
In this section you'll learn how to save filters you create with Filter views.
Learn how to get better data by limiting the kinds of data that can be input to a cell. And then, after downloading the .xlsx file, complete the exercise after watching the video lectures in this section.
Learn how to collaborate with Google Sheets and share your work with others.
Printing worksheets is easier said than done. In this video, you'll learn the ins and outs of printing with Google Sheets.
Learn how to email your work to others for collaboration.
Sometimes you'll need to export your work in Google Sheets to another format-- like Excel. Learn how in this video.
Google Sheets has become the go-to spreadsheet program for millions of users.
An advanced spreadsheet application, Google Sheets is used for everything from tracking finances, to data management, to logging and tracking. With dozens of features, Google Sheets can be intimidating to first-time users. Luckily you can learn the basics in a short period of time and immediately be productive with the Google Sheets software.
This is a learn-by-doing course in which expert instructor Mark Lassoff will guide you step-by-step through creating your first spreadsheet in the very first sections of the course. You'll even write your first functions just a few minutes into the course! He'll then go deeper into formatting your spreadsheet document so it looks good and is readable. Next, Mark will talk about managing data within Google Sheets. You'll learn sorting and filtering as well as data entry validation. Mark will wrap up the course by discussing the output, export, and collaboration tools within Google Sheets.
Open your laptop and follow along with the video lectures and secure and solidify your knowledge with the step-by-step lab exercises included with the course. The exercises are specially designed to help you retain and apply the information taught in the video lectures.