Course Information
Course Overview
Master Google's Spreadsheet Program
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.
Course Content
- 4 section(s)
- 16 lecture(s)
- Section 1 Introduction
- Section 2 Formatting Worksheets
- Section 3 Working with Data
- Section 4 Finalizing Your Work
What You’ll Learn
- Competently navigate the Google Sheets Interface and successfully enter data
- Format spreadsheets so that they are both readable and attractive
- Create formulas and use built-in Spreadsheet functions
- Manage spreadsheet data and apply filters and sorts
- Output, Use Collaboration Tools and Export Spreadsheets
Skills covered in this course
Reviews
-
LLorraine Peters
It was a little rough to start and follow how to open the Excel spreadsheet in Google Sheets, but once figured out, all was good. Instructor is clear and engaging.
-
AAndrea Jimenez Salas
First of all, I love the instructor's energy when explaining. I also really appreciated that he provided a practice sheet to follow along with the class as it progressed.
-
BBrian Connelly
Clear, concise explanations, no fluff and used great visuals to demonstrate the different tools Google Sheets has to offer. Although I was already aware of a lot of these functions, I still gave this course 5 stars because a) I wasn't expecting anything too advanced, b) the presentation was fantastic and effective and c) I still learned some things.
-
FFrank Bischop
Wasn't able to follow along with the Google sheet example. So I took a lot of notes and hopefully it's just as effective. Please email me my copy of the certificate of completion to fjtb2000@gmail.com