In the 4th video in organization, we look at parts of tables, how to clean tables, and how to sort and filter tables!
Timestamps
00:00 Introduction
00:35 Headers
01:58 Fields of Data VS Records
02:34 Cleaning Data
03:00 Cleanup Suggestion
03:53 Trim Whitespace
04:20 Formatting Numbers
05:33 Check email with ISEMAIL Function
06:21 Default Number Format Vs. Text
07:36 Dates
10:24 Remove Duplicates
11:48 Sort Range
16:23 Filter Range
18:47 Filter Range to Account for Future Data
19:30 Filter Views
22:09 Conclusion
23:02 End Slides
--
Section 1: Organization
docs.google.com/spreadsheets/...
--
Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN www.linkedin.com/in/matthew-k...
Music is "WFH" by Ambiosynthesis
• WFH
---
#spreadsheet
#technology
#googlesheets
#sheets
Негізгі бет Ғылым және технология Organizing Tables
Пікірлер