Learn Advanced Formulas in Excel

Simon Sez IT July 5, 2022
Video Thumbnail

About

No channel description available.

Video Description

Download the demo file and follow along here ➡️ https://www.simonsezit.com/article/advanced-formulas-excel-webinar/ In this Advanced Formulas in Excel tutorial, we'll talk about the VLOOKUP formula before moving on to discuss lookups with multiple criteria. We'll also discuss combining and splitting texts, INDEX and MATCH with multiple criteria, COUNTIFS and SUMIFS, and more. Finally, we'll take a look at the LAMBDA formula and how you can create your own functions with LAMBDA. 🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/ 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3 ✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT 🔔 Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Spice Up Your Life

AI-recommended products based on this video

Loading...
Bachan’s Original Japanese Barbecue Sauce, Authentic Umami Flavour, Teriyaki-Style Marinade & Dipping Sauce, Preservative-Free, Cold-Filled, 355 ml Bottle

Bachan’s Original Japanese Barbecue Sauce, Authentic Umami Flavour, Teriyaki-Style Marinade & Dipping Sauce, Preservative-Free, Cold-Filled, 355 ml Bottle

(7)
$14.49
FREE delivery Sun, Mar 29 on your first order
600+ bought in past month
Loading...
Hand Warmers Rechargeable OUTJUT 2 in 1 USB Pocket-Sized Handwarmers Easy to Carry Electric Hand Warmer 3 Heat Settings Hot Hand Gifts for Men Women Go Out for Hiking Camping Sking and Fishing

Hand Warmers Rechargeable OUTJUT 2 in 1 USB Pocket-Sized Handwarmers Easy to Carry Electric Hand Warmer 3 Heat Settings Hot Hand Gifts for Men Women Go Out for Hiking Camping Sking and Fishing

(18)
$31.37
FREE delivery Sat, Jun 14 on your first order
Loading...
Water Heater Cleaning and Flushing Tool, Sediment Buster Hot Water Tank Flush Kit, Breaks Up Stubborn Clogs, Remove Sediment & Dirt Easily, Friendly Plumbing Maintenance Kit for Electric & Gas Heaters

Water Heater Cleaning and Flushing Tool, Sediment Buster Hot Water Tank Flush Kit, Breaks Up Stubborn Clogs, Remove Sediment & Dirt Easily, Friendly Plumbing Maintenance Kit for Electric & Gas Heaters

(0)
$15.39
$4.99 delivery Jun 19 - Jul 3
Loading...
TESPERT Pool and Spa Test Strips Hot Tub Test Strips 7-in-1 125 Strips Pack, Chemistry Test Kit for Test Bromine, Total Alkalinity, pH, Free Chlorine, Total Hardness, Cyanuric Acid, and Total Chlorine

TESPERT Pool and Spa Test Strips Hot Tub Test Strips 7-in-1 125 Strips Pack, Chemistry Test Kit for Test Bromine, Total Alkalinity, pH, Free Chlorine, Total Hardness, Cyanuric Acid, and Total Chlorine

(1,962)
$16.99
FREE delivery Thu, Aug 14 on your first order
400+ bought in past month
Loading...
GoGo squeeZ Fruit Sauce Variety Pack, Apple, Strawberry, Peach, Banana, No Sugar Added. 90g per pouch, Pack of 20

GoGo squeeZ Fruit Sauce Variety Pack, Apple, Strawberry, Peach, Banana, No Sugar Added. 90g per pouch, Pack of 20

(526)
$14.97
FREE delivery Sat, Jun 14 on your first order
3K+ bought in past month
Loading...
Waterdrop CoreRO Countertop Reverse Osmosis Water Filter, Instant Hot Water Dispenser, 5 Temperature Options, NSF/ANSI 372 Certified, Portable Pure Water Pitcher, 3:1 Pure to Drain, 6 Stage, WD-C1H

Waterdrop CoreRO Countertop Reverse Osmosis Water Filter, Instant Hot Water Dispenser, 5 Temperature Options, NSF/ANSI 372 Certified, Portable Pure Water Pitcher, 3:1 Pure to Drain, 6 Stage, WD-C1H

(3,806)
$379.00
FREE delivery Tue, Sep 23