15 Spreadsheet Formulas Working Professionals Should Know!
119.7 هزار بار بازدید -
3 سال پیش
-
👨🏻💻 Having worked in roles
👨🏻💻 Having worked in roles that required me to use Excel and Google Sheets extensively over the past 7 years, I thought it might be good to share 15 Google Sheets Formulas that all Working Professionals Should Know! Whether you're a beginner who have never come across Google Sheets functions, or a power user who feel comfortable combining multiple Google Sheets formulas, I hope there's something for you in this Google Sheets / Excel formula video!
For simple formulas that most people use such as VLOOKUP, there are things you want to watch out for, for example when to use "TRUE" vs. when to use "FALSE." We also cover more advanced formulas such as IMPORTRANGE, ARRAYFORMULA, CONCATENATE, and combined functions such as =IF(SEARCH())
If you're a fresh graduate who just landed a first full-time job, or a working professional who has been working for 1-5 years, you probably will come across situations where you would need to use some (if not all) of the formulas mentioned in this video, whether you work with Microsoft Excel or Google Sheets, so why not give yourself a head start by practicing today? 😉
TIMESTAMPS
00:00 DETECTLANGUAGE
00:46 VLOOKUP mistakes
01:25 Wildcard Asterisk Character
01:50 TODAY
02:15 IMPORTRANGE
03:45 COUNTIF
04:08 COUNTA
04:48 SPLIT
05:43 LEFT
05:55 RIGHT
07:02 ISEMAIL and SUBSTITUTE
08:06 ISURL
08:31 ARRAYFORMULA
09:10 CONCATENATE
10:11 &
10:37 IF and SEARCH
11:49 IFERROR
12:22 SUMIF
13:45 TRIM, UPPER, LOWER, and PROPER
RESOURCES I MENTION IN THE VIDEO
📧 Subscribe to my Productivity newsletter - https://www.jeffsu.org/productivity-p...
MY FAVORITE GEAR
🎥 My YouTube Gear - https://geni.us/youtube-gear
🎒 What's In My Bag - https://geni.us/mybag
💻 What's On My Desk - https://geni.us/mydesk
🛩 What I Travel With - https://geni.us/mytravel
MY FAVORITE SOFTWARE
✍️ Skillshare - https://geni.us/skillshare-jeff
🎨 Canva - https://partner.canva.com/jeffsu
BE MY FRIEND:
📧 Subscribe to my Productivity newsletter - https://www.jeffsu.org/productivity-p...
📸 Instagram - Instagram: j.sushie
🤝 LinkedIn - LinkedIn: jsu05
👋🏻 Clubhouse - https://www.joinclubhouse.com/@jsushie
👨🏻💻 WHO AM I:
I'm Jeff, a full time Product Marketer. In my spare time I like to tinker with tools and create systems that help me get things done faster - or as one of my friends puts it: "Get better at being lazy" 😏
If you'd like to talk, I'd love to hear from you. Messaging me on Instagram (@j.sushie) directly will be the quickest way to get a response!
PS: Some of the links in this description are affiliate links I get a kickback from 😇
Disclaimer: My opinions are my own and may not reflect that of my employer
#formulas #functions #googlesheets
For simple formulas that most people use such as VLOOKUP, there are things you want to watch out for, for example when to use "TRUE" vs. when to use "FALSE." We also cover more advanced formulas such as IMPORTRANGE, ARRAYFORMULA, CONCATENATE, and combined functions such as =IF(SEARCH())
If you're a fresh graduate who just landed a first full-time job, or a working professional who has been working for 1-5 years, you probably will come across situations where you would need to use some (if not all) of the formulas mentioned in this video, whether you work with Microsoft Excel or Google Sheets, so why not give yourself a head start by practicing today? 😉
TIMESTAMPS
00:00 DETECTLANGUAGE
00:46 VLOOKUP mistakes
01:25 Wildcard Asterisk Character
01:50 TODAY
02:15 IMPORTRANGE
03:45 COUNTIF
04:08 COUNTA
04:48 SPLIT
05:43 LEFT
05:55 RIGHT
07:02 ISEMAIL and SUBSTITUTE
08:06 ISURL
08:31 ARRAYFORMULA
09:10 CONCATENATE
10:11 &
10:37 IF and SEARCH
11:49 IFERROR
12:22 SUMIF
13:45 TRIM, UPPER, LOWER, and PROPER
RESOURCES I MENTION IN THE VIDEO
📧 Subscribe to my Productivity newsletter - https://www.jeffsu.org/productivity-p...
MY FAVORITE GEAR
🎥 My YouTube Gear - https://geni.us/youtube-gear
🎒 What's In My Bag - https://geni.us/mybag
💻 What's On My Desk - https://geni.us/mydesk
🛩 What I Travel With - https://geni.us/mytravel
MY FAVORITE SOFTWARE
✍️ Skillshare - https://geni.us/skillshare-jeff
🎨 Canva - https://partner.canva.com/jeffsu
BE MY FRIEND:
📧 Subscribe to my Productivity newsletter - https://www.jeffsu.org/productivity-p...
📸 Instagram - Instagram: j.sushie
🤝 LinkedIn - LinkedIn: jsu05
👋🏻 Clubhouse - https://www.joinclubhouse.com/@jsushie
👨🏻💻 WHO AM I:
I'm Jeff, a full time Product Marketer. In my spare time I like to tinker with tools and create systems that help me get things done faster - or as one of my friends puts it: "Get better at being lazy" 😏
If you'd like to talk, I'd love to hear from you. Messaging me on Instagram (@j.sushie) directly will be the quickest way to get a response!
PS: Some of the links in this description are affiliate links I get a kickback from 😇
Disclaimer: My opinions are my own and may not reflect that of my employer
#formulas #functions #googlesheets
3 سال پیش
در تاریخ 1400/06/02 منتشر شده
است.
119,739
بـار بازدید شده