# Google Sheets Bootcamp

Canonical URL: <https://www.nobledesktop.com/classes/google-sheets-bootcamp-nyc>

## Overview

Google Sheets is more than just an online spreadsheet. It is a comprehensive online collaboration tool used by many businesses. Learning to use these features will improve productivity among your team in ways you may not have imagined. In this course, we will cover the basics of using spreadsheet formulas and functions. 

We will also show you how to leverage collaboration features that take advantage of its web-based functionality. You'll learn how to effectively work as a team using Google Sheets and get more done than you ever could with just a desktop app alone.

## What you'll learn

- Formulas and calculations
- Text functions for splitting and joining text
- Data functions like the VLOOKUP
- Logic functions like IF, AND, and OR
- Statistical functions
- Pivot Tables
- INDEX-MATCH

## Curriculum

#### Level 1

- Accessing Google Sheets
- Basic Navigation & Formulas
- Date Time Functions
- Sharing & Collaboration
- Calculation Functions
- Managing Sheets
- Sorting & Filtering
- Conditional Formatting
- Charts
- Basic Keyboard Shortcuts

#### Level 2

- Google Native Functions
- Vlookup & Xlookup
- Pivot Tables
- Filter Views
- Publishing & Embedding Sheets
- Importing Data Across Sheets
- Working with Images in Sheets
- Google Sheets Macros
- Leveraging Third Party Apps
- Google's AI Tool (Explore)

## Pricing

**Tuition:** $549