How to Use the FORMATTING TOOLS in Google Sheets | A Teacher's Guide #1 | INTERACTIVE TUTORIAL
This video will walk you through the key formatting tools in Google Sheets, along with a few ESSENTIAL TIPS that will help teachers customize and navigate your spreadsheets more efficiently. ⬇ FOLLOW ALONG ⬇ ▪ Download a copy of the mock field trip planning sheet I'm using in the video so you can practice the formatting tools along with me: https://docs.google.com/spreadsheets/d/10dsK0v3gln3mk736eA3YuX70TXb8DjVkVkZzziHhj98/copy ⬇ TABLE OF CONTENTS ⬇ ▪ 00:13 — Quickly launch a new Google Sheet from Google's Omnibox ▪ 00:30 — Overview of columns, rows, formatting toolbar, and file menu ▪ 01:28 — Highlight entire spreadsheet at once ▪ 01:45 — Change the font, text size, alignment, and other basic formatting ▪ 02:03 — Select and resize multiple cells at once ▪ 03:14 — Wrap text in a cell ▪ 04:40 — Freeze the top row of cells ▪ 05:50 — Split text into two columns ▪ 07:15 — Sort columns alphabetically ▪ 07:43 — Vertically align text in center of cell ▪ 08:24 — Rotate text ▪ 09:14 — Use the alternating colors tool ▪ 11:08 — Insert multiple cells ▪ 12:24 — Merge cells ▪ 13:35 — Add different border styles ▪ 15:35 — Add a margin around spreadsheet data ⬇ RESOURCES SHOWN IN VIDEO ⬇ ▪ Monthly Planning Calendar: https://www.teacherspayteachers.com/Product/Digital-Monthly-Calendar-Templates-Google-Sheets-Planner-To-Do-Lists-3961230?utm_source=YouTube&utm_campaign=Google%20Sheets%20Video%20Series ▪ Student Growth Data Tracker: https://www.teacherspayteachers.com/Product/Color-Coded-Student-Growth-Data-Tracker-Google-Sheets-Spreadsheet-Templates-4664963?utm_source=YouTube&utm_campaign=Google%20Sheets%20Video%20Series ⬇ LET'S CONNECT ⬇ WEBSITE: http://www.helloteacherlady.com INSTAGRAM: http://www.instagram.com/helloteacher... TWITTER: http://www.twitter.com/shanateaches EMAIL: [email protected]
Download
0 formatsNo download links available.