Name: Google Sheets Tips Tricks Quick HowTo Workspace Resources
Rating: 4.8 (11 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byLaurence Svekis

Last updated 11/2024

English

What you'll learn

How to increase your productivity within Google Sheets
How to collaborate with others within Google Workspace Sheets Spreadsheet
How to use Functions and formulas to save time
How to create Charts and insert Images into Google Sheets
How to create Marcos
Use Google Sheets and power up your Sheets skills
See examples of what can be done with Google Sheets
Explore Sheets in full with dashboard functionality
Learn more about what you can do with Sheets and some of the more commonly asked for questions

Course content

6 sections • 63 lectures • 7h 26m total length

Introduction top getting started with Google Workspace Sheets Spreadsheet2:03
Getting Started with Google Sheets How to start using Google Sheets8:47
Sheets Collaboration Sharing benefits of web based workspace working with others11:35
How to save sheet data Saving your Sheet updates and best practices to recover6:47
How Google Sheets compares to other spreadsheet apps Sheets vs Excel comparison8:40
Google Sheets other files and formats Create and Import Files to Sheets19:24
Edit and update content in sheets Editing Google Sheets19:35
How to use Sheets tips and helpful ideas about content Sheet Content Option17:26
Learn to freeze top rows and columns, highlight headings, group and protect ranges, hide or show columns, resize to fit data, and sort with header aware options.
Update the cell formats Format Cells in Sheets and options for cell data20:10
Explore how to format cells in Google Sheets, including number formats, fonts, colors, borders, alignment, wrapping, and rotation, plus merge, theme, and conditional formatting to highlight data.
How to apply filters within Google Sheets Google Sheets Filters.15:45
Apply filters in Google Sheets to remove empty rows, create and manage filter views, and sort or filter by color or condition for precise data analysis.
protect your Sheet data apply Protected Sheets and Ranges to cell content8:18
Learn to secure Google Sheets by protecting sheets and ranges, setting edit permissions, adding editors, and using warnings, while hiding and revealing sheets as needed.
Do more with Sheets Google Spreadsheet Sheet Options4:22
How to setup Named Ranges within your Google Sheets documents4:21
Setting view options within Google Sheets View options Sheets settings4:15
How to insert into your Google Sheets Insert Options Sheet content7:53
How to Insert Charts and Images into Sheets with helpful tips and tricks13:21
How to use Comments and Notes Insert in Google Sheets6:04
New features like Slicers in Sheets Filter how to use new features4:09
Learn to use slicers in Google Sheets to filter chart data and create interactive visuals, adjusting data ranges, chart types, and slicer customization to update views automatically.
Explore your Google Sheet Data Options7:21
Google Sheets how to use Tools menu Sheets Tool Options4:58
More about Google Addons and what you can do with Sheets Addons4:00
Explore the Google Sheet Explore Sheets option for your content suggestions2:47

Google Sheets Function and useful example of how to use Functions and Formulas1:06
Resources1:20
Google Sheets Functions Sheets Formula Simple Operators and Functions8:26
Selecting Cells and settings selected cell Relative vs Absolute Cells.8:26
Common functions within Google Sheets Helpful Google Sheet Functions5:10
Sheets Functions Date Options within Google Sheets Using Date Functions9:38
How to use Text Functions Sheets String Functions14:07
How to use Sheets Filter Functions for Sheet Data in Cell formulas4:21
Most commonly used Sheets Info Functions examples of Info Functions9:10
Explore how to use Google Sheets info functions to check blank cells, dates, emails, formulas, booleans, numbers, and text; retrieve cell type, address, column, row, contents, and width.
How to use Lookup in Sheets Google Sheets LookUp Functions.10:55
master lookup options in google sheets, including vlookup and hlookup, address, index, and match, to retrieve rows or columns and view formulas as text.
Examples of Common Sheets Math Functions4:05

How to Get Help Quick Tip for Google Sheets0:46
How to Share your Sheets Quick Tip for Google Sheets1:01
Publish your Google Sheets to the web to create a shareable URL and choose formats like web page, csv, pdf, or excel, then share via Gmail, Facebook, or Twitter.
Go Offline with Sheets Quick Tip for Google Sheets0:47
How to Share your Google Sheets with Others Sheets Quick Tip1:35
Google Sheets Version Control Quick Tip for Sheets users1:33
Google Sheets Examples PDF Guide1:07
Google sheets Investment Calculator Example5:14
Google Sheets Mortgage Calculator Example8:08
Google Sheets Loan Calculator Example3:07
Basic Math and Text Functions Sheets Example5:18
Logical Functions in Sheets Function Example Google Sheets Workspace5:19

Google Sheet Formulas with Apps Script13:37
Sum of the squares of the numbers in a range6:15
Create a Google Apps Script function to sum squares in a range by converting the range to a string, splitting into an array, and summing each value squared in Sheets.
Random number between two given numbers2:40
Convert a number from decimal to binary2:46
Age of a person based on their birthdate4:44
Create a Google Apps Script function to calculate a person’s current age from birth date in Google Sheets, converting to milliseconds and using Unix time to derive age.
Check if a given string is a palindrome5:50
Calculate the distance between two sets of latitude and longitude4:19
Calculate the distance between two points on a sphere using latitude and longitude with the Haversine formula, implemented as a custom function in Sheets using Apps Script.
Count the number of occurrences of a given value in a range.3:22
Calculate the factorial of a given number3:48
Concatenate two strings and capitalize the first letter8:45
Formula to calculate the average of the values in a given range8:18

Source Code Google Apps Script Custom Formula Examples19:49
Calculate a weighted Average from a range of values5:59
Create a custom weighted average function in Google Sheets with Apps Script to compute a weighted mean from a range of values and their weights.
Calculate average from range above a threshold8:32
Create a custom Google Sheets formula called average above threshold to compute the average of a range while excluding values below a threshold, using Apps Script in a bound spreadsheet.
How to Calculate total amount with a discount using a custom Apps Script Google7:42
How to get the total amount of items including the tax rate6:46
How to get the total cost custom sheets formula to calculate values across range7:32
How to use data from two sheets to create a custom Apps Script function13:33

Requirements

Students will require a Google Account to access sheets
Internet connection and basic internet skills

Description

Google Sheets is a spreadsheet app which is powerful and easy to use. Sheets has a familiar layout so you can get started quickly.....

Learn how to power up with Google Sheets with the power to Share and collaborate with others!

Increase your productivity bring it to the max, with auto saves, and the ability to access from any device, its loaded with amazing smart functionality.

Its a web based spreadsheet that you can use store and access your files from your Google drive using your Google Account.
It works across any device, mobile or desktop you choose whichever you prefer.
Google Sheets comes with your Google Account as well more powerful organization workspaces are also available.
Works seamlessly across Google Workspace Suite of apps including Google Drive, Docs, and Slides
Interface is familiar just like Excel and other similar spreadsheet products.
Lots of useful add-ons you can download to really supercharge your Google Sheets.

This course is Perfect to become more familiar with Google Sheets - helpful tips and resources also included.

Learn about Google Sheets version control - How do I manage version history in Google Sheets?

Learn about Google Sheets formulas - How do I create a formula in Google Sheets?

Google Sheets Getting Started with Sheets for Beginners

Course lessons are designed to be a step by step lesson structure to help you learn everything about Google Sheets

Getting Started with Google Sheets - How to start using Google Sheets
Sheets Collaboration Sharing benefits of web based workspace working with others
How to save sheet data Saving your Sheet updates and best practices to recover
How Google Sheets compares to other spreadsheet apps Sheets vs Excel comparison
Google Sheets other files and formats Create and Import Files to Sheets
Edit and update content in sheets Editing Google Sheets
How to use Sheets tips and helpful ideas about content Sheet Content Option
Update the cell formats Format Cells in Sheets and options for cell data
How to apply filters within Google Sheets Google Sheets Filters.
How to protect your Sheet data apply Protected Sheets and Ranges to cell content
Do more with Sheets Google Spreadsheet Sheet Options
How to setup Named Ranges within your Google Sheets documents
Setting view options within Google Sheets View options Sheets settings
How to insert into your Google Sheets Insert Options Sheet content
How to Insert Charts and Images into Sheets with helpful tips and tricks
How to use Comments and Notes Insert in Google Sheets
New features like Slicers in Sheets Filter how to use new features
Explore your Google Sheet Data Options
Google Sheets how to use Tools menu Sheets Tool Options
More about Google Addons and what you can do with Sheets Addons
Explore the Google Sheet Explore Sheets option for your content suggestions

Google Sheets FUNCTIONS allow you to do more easily with prebuilt functions

Google Sheets working with common functions
Google Sheets Functions Sheets Formula Simple Operators and Functions
Selecting Cells and settings selected cell Relative vs Absolute Cells
Common functions within Google Sheets Helpful Google Sheet Functions
Sheets Functions Date Options within Google Sheets Using Date Functions
How to use Text Functions Sheets String Functions
How to use Sheets Filter Functions for Sheet Data in Cell formulas
Most commonly used Sheets Info Functions examples of Info Functions
How to use Lookup in Sheets Google Sheets LookUp Functions examples
Examples of Common Sheets Math Functions

Benefits of using Google Sheets - Accessing Sheets from any device - Easy to Navigate Sheet Columns and Rows - How to Create and name sheet - Features of Sheets Automatically save your work - How you can select and open you can also open templates - Saving Sheets files all automatically stored in drive - How to create new Sheets duplicate Sheets content to other Sheets - Explore selecting of rows and column- range selection to get cell data - How to make changes right away

Taught by a Google Developer Expert for Google Workspace - ready to help you learn more about Google Sheets

What are you waiting for join now and become more productive with Google Sheets Today.

Who this course is for:

Perfect for anyone who wants to update their skills with Google Sheets
Great for Microsoft Excel users to transition to Google Sheets
Google Workspace users of all levels
Anyone who uses Google Workspace and Google Products

What you'll learn

Explore related topics

Course content

Introduction to Google Workspace Spreadsheet App Sheets22 lectures • 3hr 22min

Google Sheets Functions doing more within Google Sheets made easy11 lectures • 1hr 17min

Google Sheets in Action Common Functions and Q&A examples for Spreadsheets11 lectures • 34min

Sample Code Google Sheets formulas with Apps Script11 lectures • 1hr 4min

Google Sheets custom function Examples with Google Apps Script7 lectures • 1hr 10min

Learn more about Google Sheets and Resources for extra learning1 lecture • 1min

Requirements

Description

Who this course is for: