# Google Sheets The Intermediate Level

0/5

## Google Sheets The Intermediate Level

### What you’ll learn

Working with Formulas and Functions in Google Sheets
Automating Processes with Macros in Google Sheets
Creating Visualizations and Dashboards with Google Sheets
Analyzing Data with Pivot Tables in Google Sheets
Collaborating with Others in Google Sheets

### Requirements

Ability to work with formulas and functions
Familiarity with spreadsheet concepts such as formatting and sorting
Basic understanding of working with charts and data tables

### Overview

Section 1: Working with Formulas and Functions in Google Sheets

Lecture 1 SUMIF Function

Lecture 2 SUMIFS Function

Lecture 3 VLOOKUP Function

Lecture 5 IMAGE Function

Lecture 6 FILTER Function

Lecture 7 QUERY Function

Lecture 8 SPLIT Function

Section 2: Complex formula with combinations of functions in Google Sheets

Lecture 9 SUBSTITUTE, INDEX, SPLIT Functions

Lecture 10 CHOOSE, MONTH, QUERY Functions

Lecture 11 ARRAYFORMULA, VLOOKUP, IFERROR Functions

Lecture 12 TRIM, PROPER, SPLIT Functions

Lecture 13 FREQUENCY, RANDBETWEEN Functions

Lecture 14 OFFSET and MATCH Functions

Lecture 15 DATEDIF and VLOOKUP Functions

Section 3: Tricky functions in Google Sheets

Lecture 16 Lists and Checkbox data validation

Lecture 17 Text data validation

Lecture 18 Named functions

Lecture 19 Named ranges

Lecture 20 Protected ranges and sheets

Lecture 21 IMPORTDATA function

Section 4: Charts in Google Sheets

Lecture 22 Line charts

Lecture 23 Column charts

Lecture 24 SPARKLINE function

Lecture 25 Bubble Chart

Lecture 26 Pie Chart

Lecture 27 Geo Chart

Section 5: Other features in Google Sheets

Lecture 28 Alternating Colors

Lecture 29 Publishing charts

Lecture 30 Pivot Tables

This course is designed for anyone who is looking to learn how to use Google Sheets beyond the basic level. It is for anyone who wants to take their skills to the next level and become an intermediate user.

#### Course Information:

Udemy | English | 2h 40m | 1.31 GB
Created by: Philipp Shay

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

Scroll to Top