How to Use Google Sheets for Beginners | Sorting, Functions, Charts and More (2023)

Channel:
United States Anson Alexander
Subscribers:
306,000
Published on ● Video Link: https://www.youtube.com/watch?v=xkz-HdUXBdI


Category:
Tutorial
Duration: 27:27
1,197 views
48

Learn how to use Google Sheets to create data sets, charts and pivot tables. Discover how to sort, filter, alphabetize, merge cells, create functions, format data and more as I demonstrate creating a working monthly budget spreadsheet. The spreadsheet includes a chart and pivot table showing detailed expense information. Use the skills I show you to easily create any type of spreadsheet in Google Sheets.

📋 Table of Contents

Intro: 0:00
Accessing Sheets: 00:37
Title and User Interface: 01:30
Budget Sheet Setup: 02:29
Merging Cells: 05:10
Resizing Rows and Columns: 05:56
Changing Cell Colors: 06:21
Setting Data Types: 07:29
Using Functions: 08:22
Sorting (Alphabetical, etc.): 10:51
Filtering Data: 12:40
Inserting a Chart: 14:57
Using the Chart Editor: 15:38
Why Use Pivot Tables?: 17:38
Using Fixed Cells (constants): 18:05
Inserting a Pivot Table: 21:02
Using Multiple Sheets: 21:29
Pivot Table Setup: 22:19
Final Budget Demonstration: 23:56
Alternating Cell Row Colors: 25:09
Sharing and Exporting: 25:41

🔗 Links Mentioned:

Google Sheets:
http://sheets.google.com

Google Drive:
http://drive.google.com

💻 More Tips and Tutorials
http://AnsonAlex.com

📚 LinkedIn Learning Courses
https://www.linkedin.com/learning/instructors/anson-alexander

🔎 Request a Tutorial
https://forms.gle/sciVnK4tHno7sCcGA

☎️ Get in Contact with Me
https://www.linkedin.com/in/ansonalexander/

🎥 Behind the Scenes
https://www.instagram.com/ansonalex.c0m/



Other Videos By Anson Alexander


2023-12-13Playing Ark: Survival Ascended on Mac (high graphics settings)
2023-10-19How to Install macOS Sonoma on Unsupported Macs (Quick and Easy)
2023-10-11Wireshark Tutorial for Beginners | Network Scanning Made Easy (2023)
2023-10-05The #1 Website to Use If You Actually Want to Type Faster
2023-09-28How to Clean a Keyboard Properly (Remove the Keycaps)
2023-09-22Using Keynote for Graphic Design on ANY Mac (it's free) | Full Tutorial (2023)
2023-09-19Find ANY File on Your Mac | Become a Finder Master (2023)
2023-09-14Avoid These 10 Common Mistakes and Boost Your Speed | Typing
2023-09-07How to Block / Unblock and Prevent Spam in Gmail (report spam vs block)
2023-09-05Bulk Delete Gmail Emails on iPhone (more than 50 at at time)
2023-08-30How to Use Google Sheets for Beginners | Sorting, Functions, Charts and More (2023)
2023-08-24Transfer Google Drive Files to Another Account (2023)
2023-08-02How to Use Google Calendar Effectively in 2023 | Full Tutorial
2023-07-27Best Way to Organize a SINGLE Gmail Inbox | Digital Minimalism
2023-07-25Google Chrome Incognito Guide | Private Browsing Tutorial
2023-07-20Why I Still Prefer Intel Macs Over Apple Silicon in 2023
2023-07-19macOS Infinite Boot Loop Recovery | No Backup | No Data Loss
2023-06-29macOS | Fully Uninstall Apps Manually (Free / No Software) 2023
2023-06-03Best Free Auto Mouse Clicker for Mac (2023)
2023-05-25Convert PDFs to Google Docs and Back (Images and Formatting Included)
2023-05-10Why QWERTY? Keyboard Layouts Investigated


Tags:
google sheets
google sheets tutorial
how to use google sheets
google sheets tutorial for beginners
google sheets formulas
google sheets tips and tricks
google sheets for beginners
google spreadsheet
google sheet tutorial
learn google sheets
google spreadsheet tutorial
how to use google spreadsheet
using google sheets
spreadsheet
google sheet
sheets tutorial
google docs
how to use google sheet
chart
pivot table
pivot table in google sheets
sorting
budget