Google Sheets Tutorial for Beginners – Step-by-Step
Loves Data
@lovesdataAbout
Learn how to use Google Analytics, Google Tag Manager, Google Ads, and Looker Studio with Loves Data. We're here to help you get the most out of Google's platforms and your data. And we're about getting to the good stuff and skipping the fluff.
Latest Posts
Video Description
Ready to start learning Google Sheets? Get started with this Google Sheets tutorial for beginners. Learn how to create your first spreadsheet, through to formatting and adding visualizations. Download the example file at https://lovesdata.co/cONsHe JUMP TO A TOPIC: 00:00 Introduction to Google Sheets 00:47 How to create a new spreadsheet in Google Sheets 02:28 How to import data into a spreadsheet in Google Sheets 04:07 Understanding columns and rows in Google Sheets 05:09 How to freeze the header row in Google Sheets 05:34 Text wrapping in Google Sheets spreadsheet cells 06:23 Formatting values and text in Google Sheets cells 08:00 Sorting values in a Google Sheets spreadsheet 08:39 How to use conditional formatting in Google Sheets 09:36 Calculating new values in Google Sheets 13:30 Inserting extra columns in a spreadsheet 14:03 Using functions in Google Sheets 16:26 How to use filters in Google Sheets 17:19 Validating data in Google Sheets 18:03 Visualizing data in your Google Sheets spreadsheet 19:28 Sharing and collaborating in Google Sheets 19:53 Next steps WHAT TO WATCH NEXT: ○ Creating charts and graphs in Google Sheets - https://youtu.be/IFX9e9SqGlw ○ Google Sheets tips - https://youtu.be/Pn8ZIM0My9I ○ Looker Studio tutorial - https://youtu.be/Coe_f79Xc2o TOOLS WE USE AND RECOMMEND: ○ Data connector – https://lovesdata.co/oOWkI ○ Cookie banner – https://lovesdata.co/letON ○ Email platform – https://lovesdata.co/zrLd7 ○ Course platform – https://lovesdata.co/2Zzfq Join our courses: https://www.lovesdata.com/courses Subscribe to our YouTube channel: http://www.youtube.com/subscription_center?add_user=lovesdata #googlesheetstutorial #googlesheets
Boost Productivity with These Google Sheets Must-Haves
AI-recommended products based on this video

65W 45W Laptop Charger for Acer Aspire 3 5 A515-55 A515-56 A515-46 A515-54 A515-54G A517-52 Swift Spin 1 3 5 SF113-31 SF114-32 Chromebook 11 R11 13 14 15 CB3 C720 C720P Power Adapter

TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G502 Hero High Performance Wired Gaming Mouse, Hero 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC/Mac, Black

Dell 24 Monitor - SE2425HM - 23.8-inch Full HD (1920x1080) 16:9 100Hz Display, IPS Panel, 16.70 Million Colors, Anti-Glare, 1 HDMI / 1 VGA Port, TÜV Rheinland 3-Star*, Comfortview Plus - Black

Dell S2425HS Monitor - 23.8 Inch, FHD (1920x1080) Display, 100Hz Refresh Rate 1500:1 Contrast Ratio, TÜV Rheinland Eye Comfort 4 Star, Integrated 2x5W Speaker, Height/Tilt/Swivel/Pivot - Ash White

USB C Docking Station Dual Monitor for Dell Hp,15-in-1 Laptop Docking Station 3 Monitors USB C Hub with Dual 4K HDMI,8K DP,Button,PD Charging,Ethernet,6 USB A&C,SD/TF, Audio USB-C Multiport Adapter

Dell 24 Monitor - P2425H EPEAT

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

100W USB C Universal Laptop Charger Fit for Lenovo MacBook HP Dell Acer Asus Thinkpad Google MSI LG Samsung Huawei, ROG Ally, Steam Deck, Chromebook Computer and All USB-C Devices

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc



















