15 Spreadsheet Formulas Working Professionals Should Know! скачать в хорошем качестве

15 Spreadsheet Formulas Working Professionals Should Know!

🔩 Grab my free Workspace Toolkit: https://academy.jeffsu.org/?utm_sourc... 👨🏻‍💻 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 -   / j.sushie   🤝 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