Play all

Start

Introduction

Accessing Google Sheets

Navigating in Cells and Menus

Keyboard Shortcuts

Editing Cell Contents

Templates

Using Explore

Opening and Saving Sheets

Using Google Drive with Google Sheets

Showing and Using the Formula Bar and Gridlines

Basic Formulas

Using Autofill to Copy Formulas

Using Autofill to Create Redundant Data

Simple Formulas

Formulas with Absolute References

Cut, Copy, and Paste

Inserting Rows and Columns

Wrapping Text, Rotating, and Aligning Cells

Cell Formatting

Hiding Rows and Columns

Freeze Panes and Full Screen View

Spell Check and Printing

Sharing and Emailing Sheets

Publishing to Web

Conclusion

Introduction

List, Format, and Sort

Multi-Column Sort

Filters

Conditional Filters and Filtered Views

Creating Charts

Editing Charts

Removing and Deleting Chart Data

Sparklines

Formatting with Alternating Row Colors

Pivot Tables

Pivot Charts

Named Ranges

IF Functions

Nested Functions

VLOOKUP

SUMIF and AVERAGEIF

SUMIFS

AVERAGEIFS

IFERROR

LEFT and RIGHT

CONCATENATE

Sharing Files

Real-Time Authoring

Google Sheets Add-Ons

Introduction to Google Apps Scripts

Conclusion

Description:

Dive into a comprehensive 2+ hour tutorial on Google Sheets, covering everything from basic navigation to advanced features like Pivot Tables and Google Apps Scripts. Learn to create, format, and share spreadsheets, calculate data using functions and formulas, and master essential skills such as filtering, sorting, and data visualization. Explore popular features including AutoFill, VLOOKUP, Macros, and real-time collaboration. Gain hands-on experience with practical exercises and discover how to leverage Google Sheets for efficient data management and analysis. Perfect for beginners and intermediate users looking to enhance their spreadsheet skills in Google's free, web-based application.

Google Sheets Full Course Tutorial

Learnit Training

Add to list

#Business #Business Software #Google Workspace #Google Sheets #Computer Science #Algorithms #Data Sorting #Data Science #Data Processing #Data Filtering #Data Analysis #Spreadsheets #Pivot Tables #Macros #VLOOKUP

0:00 / 0:00