Learn Google Sheets FAST: Sorting, Functions, Charts and More

Video Description

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: 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/ #GoogleSheets #DataVisualization #SpreadsheetSkills