VTC Legacy
Home / Business Applications

Google Sheets

by Melanie Hedgespeth
114 lessons19 chapters7.5 hReleased 202110 free
Start the free chapter

Google Sheets is a spreadsheet program that is part of the vast suite of applications Google provides, all of which are available online anytime, anywhere. With sheets, you can analyze and organize data, design charts, implement calculations, create macros and collaborate easily with others.rnThis course will begin with the fundamentals of Google Sheets. You will learn how to navigate the interface, understand the terminology, create basic spreadsheets, format data and manage your files on the Google platform. You will then learn how to utilize numerous formulas and functions along with sorting and filtering your data. With Sheets you will be able to help others understand data through a visual chart. By learning how to work with pivot tables, macros, add ons and templates you can truly master the program. Most importantly, this course will teach you how to easily collaborate with others by sharing files and keeping those files safe by restricting permissions.rnGoogle Sheets is a vast program that can help you both in a professional or personal setting. Work through this course and master Sheets so you can be efficient and effective with data.

Course content

Welcome1 lessons
Fundamentals4 lessons
Sheets Basics5 lessons
Sheets Essentials7 lessons
Managing Your Files3 lessons
Data4 lessons
Working with Data7 lessons
Calculations6 lessons
Formulas & functions20 lessons
Charts & Graphs21 lessons
Working with Others7 lessons
Drawings3 lessons
Pivot Tables3 lessons
Templates7 lessons
Add-ons6 lessons
Macros3 lessons
Other Useful Elements5 lessons
Wrap Up1 lessons
Author1 lessons