Google Sheets Tutorial for Beginners: Sorting, Functions, Charts & More @AnsonAlexander
Google Sheets Tutorial for Beginners: Sorting, Functions, Charts & More  @AnsonAlexander
Uploaded August 2023 | Updated November 2026, 2 days ago
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
User Interface: 00:54
Budget Sheet Setup: 01:53
Merging Cells: 04:34
Resizing Rows and Columns: 05:20
Changing Cell Colors: 05:45
Setting Data Types: 06:54
Using Functions: 07:47
Sorting (Alphabetical, etc.): 10:14
Filtering Data: 12:03
Inserting a Chart: 14:20
Using the Chart Editor: 15:01
Why Use Pivot Tables?: 17:01
Using Fixed Cells (constants): 17:28
Inserting Pivot Tables: 20:25
Using Multiple Sheets: 20:52
Pivot Table Setup: 21:42
Final Budget Demonstration: 23:19
Alternating Cell Row Colors: 24:32
Sharing and Exporting: 25:04

πŸ”— Links Mentioned:

Google Sheets:
sheets.google.com

Google Drive:
drive.google.com

πŸ’» More Tips and Tutorials
AnsonAlex.com

πŸ“š LinkedIn Learning Courses
linkedin.com/learning/instructors/anson-alexander

πŸ”Ž Request a Tutorial
https://forms.gle/sciVnK4tHno7sCcGA

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

πŸŽ₯ Behind the Scenes
instagram.com/ansonalex.c0m

#GoogleSheets #DataVisualization #SpreadsheetSkills
Google Sheets Tutorial for Beginners: Sorting, Functions, Charts & MoreConvert Digital Audio Out to a 3.5mm Headphone JackHow to Share a Screen on SkypeMultiple User Profiles on Pixel / Android | TutorialWhy I Still Prefer Intel Macs Over Apple SiliconHow to Use Google Forms | TutorialNvidia GeForce Now - Install EAC for Unsupported Steam GamesThe #1 Website to Use If You Actually Want to Type FasterHow to Use Disk Utility on Mac | TutorialmacOS Tahoe on a 2013 MacBook Pro β€” Is It Actually Usable?How to Use Google Meet | Tutorial
Anson Alexander |

Google Sheets Tutorial for Beginners: Sorting, Functions, Charts & More

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER