- 65
- 40 792
M@TT
United States
เข้าร่วมเมื่อ 24 ต.ค. 2023
Thanks for stopping by! I am Matt and I work in IT in an educational setting. I've always enjoyed learning, technology, and teaching, and figured why not make a channel!
This channel is all about technology and some helpful tips for it! We will be exploring various programs and technology. First on the list is all about Google Spreadsheets. I've got other ideas in mind too so if spreadsheets aren't your thing, other series may pop up to your liking!
This channel is all about technology and some helpful tips for it! We will be exploring various programs and technology. First on the list is all about Google Spreadsheets. I've got other ideas in mind too so if spreadsheets aren't your thing, other series may pop up to your liking!
Number Formatting
In this video we take a look at formatting numbers! It may seem like a simple task, but there's a lot that goes on behind the scenes. Incorrectly formatted data can cause huge issues with calculations inside a data set and can skew results. We'll start with the basics and tackle some common mistakes in this section!
--
Current Section:
➡️Section 5: Numbers
docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy
Previous Sections:
✅Section 1: Organization
docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy
✅Section 2: Formula Building
docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy
✅Section 3: Data Validation
docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy
✅Section 4: Sharing
docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE/copy
--
🗣️Socials:
WEBSITE: matttechtidbits.github.io/matttechtidbits/
REDDIT: www.reddit.com/user/MattTechTidbits
INSTAGRAM: matttechtidbits
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com/freelancers/~01e15eefe1443fcea1
-
⏳Timestamps:
00:00 Introduction
00:32 Format Numbers Menu Overview
01:39 Format as Plain Text
02:21 Format as Number
04:10 Format as Percent
05:23 Format as Scientific
05:54 Format as Custom
10:26 Helpful Number Keyboard Shortcuts Table
11:21 Helpful Number Functions Table
12:37 Conclusion
13:01 End Slides
🎵Music is "WFH" made by me with my solo music project name, Ambiosynthesis
th-cam.com/video/sKi5cGTQoBM/w-d-xo.html
-
#sheets
#spreadsheet
#googlesheets
#technology
--
Current Section:
➡️Section 5: Numbers
docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy
Previous Sections:
✅Section 1: Organization
docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy
✅Section 2: Formula Building
docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy
✅Section 3: Data Validation
docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy
✅Section 4: Sharing
docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE/copy
--
🗣️Socials:
WEBSITE: matttechtidbits.github.io/matttechtidbits/
REDDIT: www.reddit.com/user/MattTechTidbits
INSTAGRAM: matttechtidbits
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com/freelancers/~01e15eefe1443fcea1
-
⏳Timestamps:
00:00 Introduction
00:32 Format Numbers Menu Overview
01:39 Format as Plain Text
02:21 Format as Number
04:10 Format as Percent
05:23 Format as Scientific
05:54 Format as Custom
10:26 Helpful Number Keyboard Shortcuts Table
11:21 Helpful Number Functions Table
12:37 Conclusion
13:01 End Slides
🎵Music is "WFH" made by me with my solo music project name, Ambiosynthesis
th-cam.com/video/sKi5cGTQoBM/w-d-xo.html
-
#sheets
#spreadsheet
#googlesheets
#technology
มุมมอง: 116
วีดีโอ
QR Code Generator in Google Sheets
มุมมอง 7714 วันที่ผ่านมา
This video shows a method to create QR Codes in Google Sheets! It is free and requires no add-ons. There was another method like this with Google's APIs but those have been deprecated. Here's another way to get QR codes created for free! Here's the end result if you want to use the template I made! docs.google.com/spreadsheets/d/1mATlTKNbP8eVg3cl1nlSUEuBA6pJRGgaP4R9Po6UfVw/copy 🗣️Socials: WEBSI...
Hide Document Tab Button
มุมมอง 14321 วันที่ผ่านมา
In this video we look at how we can hide the button within the Source Code. As mentioned a few times, this will only work for the duration of your session on that page. If you close and open or refresh, the button will reappear. If you don’t like the button and spend hours writing, this quick fix may be a solution for you. 🗣️Socials: WEBSITE: matttechtidbits.wordpress.com/ REDDIT: www.reddit.co...
Printing Document Tabs
มุมมอง 571หลายเดือนก่อน
In this video we take a look at a way to print ALL Tabs in a document! Currently, you can’t do that within Google Docs (Hopefully updated soon!) 🗣️Socials: WEBSITE: matttechtidbits.wordpress.com/ REDDIT: www.reddit.com/user/MattTechTidbits INSTAGRAM: matttechtidbits Need a Freelancer? Check out my Upwork Profile: www.upwork.com/freelancers/~01e15eefe1443fcea1 ⏳Timestamps: 00:00 I...
New Google Docs Document Tab!
มุมมอง 6Kหลายเดือนก่อน
The new update to Google Docs! If you don't have it natively yet, make a copy and try for yourself! Updates! ( as of 10/22/2024) 1. You can now search Tabs! Use CTRL H and select "This Tab" or "All Tabs" 2. As you Scroll down to the end of a tab, it gives a pop up to go to the next page. Google Blog Post: workspaceupdates.googleblog.com/2024/10/tabs-in-google-docs.html?m=1 Document Tab: docs.go...
New 2024 Table Updates - Use IMPORTRANGE and More!
มุมมอง 359หลายเดือนก่อน
New Exciting Table Updates! A ton of changes happened since Google Sheet’s Structured Tables came out. In this video, I highlight some of the big changes! Follow along with the data: docs.google.com/spreadsheets/d/1UjLehmkbYRtOdj8yIp4dpBJ5tGduBIDZ6xUSY93HUlI/copy Here’s the “import_table” sheet: docs.google.com/spreadsheets/d/1EGjGNwDvmT6A5Ui7eBBRiUulDqKF5M16X9fTV2HS908/copy 🗣️Socials: WEBSITE:...
Automatic Formula in Google Sheets Using MAP
มุมมอง 185หลายเดือนก่อน
This video shows how to make automatic formulas with multiple columns of data with the MAP Function. This is a LAMBDA function that requires you to include LAMBDA, and is very helpful to allow for you to create an automatic formula down rows in one cell. Blog Post: matttechtidbits.wordpress.com/2024/10/01/automatic-formula-with-multiple-columns-with-map/ Link to spreadsheet if you want to copy ...
Automatic Formula By Rows
มุมมอง 198หลายเดือนก่อน
Ever want to create formulas that can automatically fill down below instead of having to copy / pasting or pulling down the formula? This video shows how you can do this with the BYROW() and LAMBDA() Functions! Check out my Blog if you want to read instead of watch: wordpress.com/post/matttechtidbits.wordpress.com/45 Here's the example sheet: docs.google.com/spreadsheets/d/1sgiwRU5mAJZ8LE9Yryju...
Timestamp Formula for Google Sheets
มุมมอง 3622 หลายเดือนก่อน
Create a Timestamp that will STAY* with this Formula! *As warned, it can break without any way to fix, see the video for details! Checkout my blog post on this if you prefer reading about it: matttechtidbits.wordpress.com/2024/09/13/hello-world/ ⏳Timestamps: 00:00 Introduction and Warning! 01:15 Looking at TODAY() and NOW() Functions 02:39 Creating an IF() Condition 03:51 Adding LAMBDA() Functi...
Mail Merge With Google Sheets Using Canva
มุมมอง 3012 หลายเดือนก่อน
THIS DOES REQUIRE A PREMIUM CANVA ACCOUNT! Teachers: You can get premium features like this free with your school! Mail merge is a super helpful way to export data into letters, certificates, and more. Google sheets have a limited number of options. Scripts is the "built in" option although it can take time creating it. I find Canva is an easy way to get really nice looking designs. Even if you...
Google Sheets Timeline View
มุมมอง 2002 หลายเดือนก่อน
In this video we will create a Timeline View in Google Sheets! Super helpful way to use data inside your spreadsheet to view it in a clean, easy to read way! ~NOTE YOU DO NEED A WORKSPACE ACCOUNT TO USE THIS FEATURE~ Here’s Google’s Article on it: support.google.com/docs/answer/12935277?hl=en#zippy=,these-workspace-editions-can-use-timeline-view ⏳Timestamps: 00:00 Introduction (Workspace Only F...
Google Sheets Conditional Notifications
มุมมอง 1.3K2 หลายเดือนก่อน
NEW 2024 FEATURE: CONDITIONAL NOTIFICATIONS! This is for workspace accounts only, so if you don't see "conditional notifications" in the Tools menu bar options, unfortunately you will not have this option. Here is Google's Article on Conditional Notifications: support.google.com/docs/answer/14099459?hl=en&ref_topic=9055295&sjid=6331716504146356394-NC ⏳Timestamps: 00:00 Introduction (Workspace A...
New 2024 Multiple Selection in Dropdowns for Google Sheets
มุมมอง 1K2 หลายเดือนก่อน
New Feature coming out in end of August to early September in 2024! Now you can select multiple dropdown options in a cell! This video will show how to use it (once when you have the feature) and a couple ways to count the responses. Here's Google's blog post: workspaceupdates.googleblog.com/2024/07/release-notes-07-26-2024.html You can make a copy and try this out yourself: docs.google.com/spr...
Mail Merge Asset Tags
มุมมอง 682 หลายเดือนก่อน
In this video we look at Microsoft's Mail Merge Feature in Word and create Labels. This example is for asset tags, but you can of course use this for name tags, mailing labels, and much, much more! 🔗Links: Font download from Google Fonts: fonts.google.com/specimen/Libre Barcode 39 Text If that doesn’t work, I do have the font from my folder here: LibreBarcode39Text-Regular.ttf Here’s the link f...
Linking Google Sheets Data to Google Docs or Slides
มุมมอง 1173 หลายเดือนก่อน
Linking Google Sheets Data to Google Docs or Slides
Protect Sheets and Ranges in Google Sheets
มุมมอง 1764 หลายเดือนก่อน
Protect Sheets and Ranges in Google Sheets
Sharing Google Spreadsheets With People
มุมมอง 1374 หลายเดือนก่อน
Sharing Google Spreadsheets With People
ChromeOS Flex USB Troubleshooting & Repair
มุมมอง 3114 หลายเดือนก่อน
ChromeOS Flex USB Troubleshooting & Repair
New 2024 Looker Studio Google Sheets Option
มุมมอง 1.2K4 หลายเดือนก่อน
New 2024 Looker Studio Google Sheets Option
Create a Single Entry Google Form for Families
มุมมอง 5754 หลายเดือนก่อน
Create a Single Entry Google Form for Families