How to Use TRIM, UNiQUE, IFERROR in Google Sheets (Part 3)

This 3 parts series on 20 essential, basic, and most used functions for Google Sheets for beginners, will teach you about the fundamentals of functions and formulas, which operators to use, how functions work, best practices, and typical errors. We will go over the most helpful functions that beginner and intermediate users should start with.

⚫ 🟠 This video will discuss many text clean-up functions starting with TRIM, UNIQUE, SPLIT, LEN, LEFT & RIGHT, LOWER, UPPER, PROPER, CONCATENATE & TEXTJOIN, CONVERT, CHAR, ISEMAIL, ISURL, AND IFERROR & IFNA functions. 🟠 ⚫

Each function will be discussed in detail with practical examples, best practices as well as some typical errors to avoid. Most functions are also shown together with ‘sister’ functions (variations, alternatives, or more advanced versions of the functions) so that you are aware of them and help you make a decision what is the best way to analyze your data.

Part 1
This video will show you what Google sheets can do, starting with the very basics on how to use functions and perform basic calculations, where to find help, errors to avoid, and best practices. We will discuss the SUM, SUMIF, MIN, MAX, and SUBTOTAL functions.

Part 2
This video will discuss the IF, AND & OR, AVERAGE, MEDIAN, MODE, COUNT, COUNTA, COUNTIF, ROUND, ROUNDDOWN, ROUNDDOWN, TODAY l& NOW functions.

Part 3
This video will discuss many text clean-up functions starting with TRIM, UNIQUE, SPLIT, LEN, LEFT & RIGHT, LOWER, UPPER, PROPER, CONCATENATE & TEXTJOIN, CONVERT, CHAR, ISEMAIL, ISURL, AND IFERROR & IFNA functions.


——————CHAPTERS—————————
00:00 - Intro
00:10 - #10 - TRIM
01:58 - #11 - UNIQUE vs. COUNTUNIQUE
06:12 - #12 - SPLIT
14:22 - #13 - LEN Function
15:13 - #14 - LEFT & RIGHT
18:15 - #15 - LOWER & UPPER & PROPER
19:43 - #16 - CONCATENATE vs. textjoin
23:17 - #17 - CONVERT
25:24 - #18 - CHAR(8226)
27:00 - #19 - ISEMAIL & ISURL
28:24 - #20 - IFERROR & IFNA


Part 1:    • Formulas for Beginners in Google Sheets (P...  
#1 - SUM & SUMIF
#2 - MIN & MAX
#3 - SUBTOTAL

Part 2:    • Beginner Formulas in Google Sheets (Part 2)  
#4 - IF
#5 - AND & OR
#6 - AVERAGE vs Median vs. Mode
#7 - COUNT & COUNTA & COUNTIF
#8 - ROUND Functions
#9 - TODAY & NOW

———————LINKS—————————— ——

All the Google Sheets shortcuts for Mac & PC:
https://support.google.com/docs/answe...

Google Sheet List of Functions:
https://support.google.com/docs/table...


#akaakidesign #akistepinska