EXCEL - LET Function Explained: Make Your Formulas Smarter in Excel!

469 views

EXCEL BEM FÁCIL

Published on Dec 28, 2024
About :

???? Simplify Your Excel Formulas with the LET Function! ???? Tired of giant and confusing formulas? ???? Today you will learn the LET Function, which promises to transform the way you work in Excel! ???? With LET, you can: ✅ Create variables to avoid repetitions; ✅ Make your formulas more organized and simple to understand; ✅ Improve the performance of your spreadsheets! ????‍???? What you will learn in this video: Practical examples that show the power of LET. Comparison with other functions such as IF, INDEX, MATCH, XLOOKUP and SUMPRODUCT. Real cases to simplify calculations of discounts, net profits and much more! ✅ SUMPRODUCT FUNCTION PLAYLIST: https://studio.youtube.com/playlist/P... ???? Timestamps to make your studies easier: 00:00 Class Introduction 03:22 Using the LET Function – Example 2 04:03 Using the IF and SUM Functions – Example 2 07:32 Using the LET Function – Example 2 11:24 Using the SUMPRODUCT Function – Example 3 13:29 Using the SUM and IF Functions – Example 3 14:37 Showing the Isolated IF Function – Example 3 15:47 Using the LET Function – Example 3 19:08 Data Validation – Example 4 19:45 Using the INDEX and MATCH Functions – Example 4 20:57 Using the XLOOKUP Function – Example 4 21:49 Using the LET Function – Example 4 24:22 Using the SUM Function – Example 5 26:02 Using the LET Function – Example 5 28:15 Calculating Isolated Variables – Example 5 30:33 Advantages of Using the LET Function 31:35 Finishing the Class ???? Tips: Share this video with that friend who loves Excel! Did you like the class? Like ????, comment ???? and subscribe to the Excel Bem Fácil channel for more amazing tips! ???? Questions or suggestions? Write our comments, I'll love to help and hear your opinion! ???? #Excel #LETFunction #ExcelTips #SimplifiedSpreadsheets ✅✅✅ YOU WILL ALSO LIKE THESE VIDEOS! ✅✅✅ ???? Forms and Controls - Part 1: ???? • EXCEL- FORMS AND CONTROLS ???? Forms and Controls - Part 2: ???? • EXCEL - FORMS AND CONTROLS 2 - F... ???? Forms and Controls - Part 3: ???? • EXCEL - FORMS AND CONTROLS 3 - F... ???????????? CONNECT WITH ME! ???????????? ???? Facebook: ???? facebook.com/excelbemfacil ???? Instagram: ???? @excelbemfacil ???? Website: ???? excelbemfacil.com ???? Email: ???? [email protected]

  • vidoe Comments
Trend Videos
5:15
Blue and Summer - Mrs. GREEN APPLE / COVER by LILPA
릴파 lilpa
1,011,153 views   11 days ago
3:25
Squid Game II 3 Minutes Summary
유요
915,061 views   3 days ago
10:56
Camping scale of the other world... Now we are even building a camping village
김숙티비kimsookTV
270,809 views   1 day ago
7:22
Lee Byung-hun, Lee Jung-jae, Kang Ha-neul, Lee Seo-hwan, Jo Yu-ri's audience-level reactions Highlight reactions Squid Game Season 2 Netflix
Netflix Korea 넷플릭스 코리아
1,779,642 views   6 days ago
18:14
Why did Ryu Hyun-jin's friends (Yang Ui-ji, Kim Hyun-soo, Hwang Jae-gyun) and juniors (Chae Eun-seong, Jang Min-jae, Park Geon-woo) all show up at the end of the year?
Eagles TV
298,388 views   2 days ago
4:09
BOYNEXTDOOR (보이네스트도어) 'Today Only I LOVE YOU' Official MV
HYBE LABELS
6,826,028 views   1 day ago
7:02
2NE1 - Come Back Home+Fire+I Don't Care+UGLY+I'm the Best♬
SBS Entertainment
6,142,554 views   13 days ago
21:15
A heart-pounding winter survival operation💕
원지의하루
347,529 views   1 day ago
7:45
[39th Golden Disk] GFRIEND - 'Intro + Running Through Time + Night + In Our Affectionate Season' ♪ JTBC 250107 Broadcast
Golden Disc
964,097 views   1 day ago
43:38
Everyone was moved to tears by the actions of the scrapyard grandmother. Seol-sam stepped forward for the 9 companion dogs that became the light of an 81-year-old grandmother who lost her entire family and lives alone. #Whyareyousocute
EBS 세나개 x 고부해 - 왜그러냥? 귀엽개!
353,093 views   4 days ago
10:24
A man you absolutely must not miss
짧은대본 ShortPaper
1,677,384 views   10 days ago
13:32
To be or not to be thyroid cancer, that is the question...
배말랭
459,796 views   2 days ago
39:38
[Ep.21] Kim Won-hee calls Kim Yong-man OO? ㅣ The truth about the KakaoTalk message from 3 years ago that embarrassed Kim Yong-man [Jo Dong-ari Episode 21]
조동아리
381,341 views   2 days ago
24:30
[🇦🇺vlog] A busy 2024 summer Christmas vlog spent with family
해쭈 [HAEJOO]
479,405 views   2 days ago
21:13
2025 Season 1 [Invitation to Noxus] Season Opening Draft 2025 LCK
LCK
493,344 views   2 days ago
28:38
[vlog] Year-end spent with loved ones
찰스엔터
349,115 views   1 day ago
29:22
2025 LCK CUP Draft
LCK
374,599 views   1 day ago
21:15
A heart-pounding winter survival operation💕
원지의하루
347,529 views   1 day ago
26:46
[VLOG] 6 years after marriage, father visits daughter's house for the first time👴🏻❗️(Proud Yujun, starts dieting)
리쥬라이크 LIJULIKE
733,120 views   2 days ago
6:19
Buy lots of winter perilla leaves and try this!! Simple, healthy, and delicious/an ultra-simple perilla leaf dish
sogyo table 소교식탁TV
147,251 views   2 days ago
0:19
RIIZE RISE 'Hug' Stage Video Teaser
SMTOWN
164,114 views   1 day ago
9:22
No, honey, stop crying;;
김계정
455,319 views   3 days ago
4:09
BOYNEXTDOOR (보이네스트도어) 'Today Only I LOVE YOU' Official MV
HYBE LABELS
6,826,028 views   1 day ago
9:59
🥔Ep. 0 ㅣ CEO KWANGSOO Dreams Big, KYUNG SOO Makes It Happenㅣ👨‍🍳🥔GBRB Spinoff
채널십오야
877,750 views   1 day ago
25:50
[Eating Vlog #109] I finally tried rose-duruchigi. But the taste..🤔 I'm the one who eats mackerel 3 times a week🐟 Hippo pound bagel, heart tiramisu, spicy noodles, cheese stir-fried noodles + pudding hotdog + cheese ball
살빼조DietJo
462,458 views   5 days ago
12:10
I waited 7 hours to buy strawberry soup for my wife who had just given birth.
네루짱NERU
520,149 views   2 days ago
15:07
Lee Ji-hye's emotional surprise camera of her husband who bursts into tears (Terry Ellie, crying)
밉지않은 관종언니
256,999 views   1 day ago
12:47
An American grandpa who came to Cherry's Taekwondo observation class and was surprised lol
올리버쌤
559,900 views   4 days ago
48:25
'Squid Game 2' Review
침착맨
949,291 views   2 days ago
24:30
[🇦🇺vlog] A busy 2024 summer Christmas vlog spent with family
해쭈 [HAEJOO]
479,405 views   2 days ago
39:38
[Ep.21] Kim Won-hee calls Kim Yong-man OO? ㅣ The truth about the KakaoTalk message from 3 years ago that embarrassed Kim Yong-man [Jo Dong-ari Episode 21]
조동아리
381,341 views   2 days ago
23:38
SNL vs XXXL! A talk show where two real crazy people make each other crazy Takdae EP24 Kim Ah-young
빠더너스 BDNS
972,484 views   2 days ago
Google AdSense
336 x 280
Up Next
8:07
Replacing the oil seal (with dust cover) on the rod in the iB5 Ford Focus 1 Duratec 1.6 V8 gearbox
Алексей Балицкий
97,001 views
6 years ago
3:36
Fiesta Ecosport Focus Xasara Picasso hitch cable terminal
DOUTOR MAP Mercerol
104,041 views
7 years ago
16:26
How to change the shift lever rod bushing on the Ford Ka Fiesta Courier
Um Pouco das Coisas
26,451 views
3 years ago
17:03
Fiesta gear lever is loose and has stopped changing gears see the solution
VICIADOS EM VIDEOS
44,343 views
4 years ago
8:15
Gear Lever Repair Replacement for the New Ford Ka.
Mecânica Nunes
79,752 views
4 years ago
2:54
Ford KA loose gear lever solving the problem part 2
Paulo Braga
41,792 views
4 years ago
5:37
Oil leak! Replacing the IB5 gearbox seal for Fiesta, Focus, Eco sport and Ka
Lucas Furlan
201,363 views
8 years ago
14:28
Ford Ka won't shift gears, is the gearbox stuck? Follow this great tip!
Alexandre Menezes
62,633 views
1 year ago
16:21
How to Change the Rear Bearings on a Fiesta (Step by Step)
Fabricio Mecânico
72,722 views
4 years ago
9:50
Ka lever repair after 2015 part 2
DOUTOR MAP Mercerol
54,778 views
6 years ago
10:44
Change of gear shift seal IB5 Ford Fiesta Focus Ka
Brankowski Centro Automotivo
124,114 views
6 years ago
10:16
Gear does not engage Ford fiesta
Cleiton Gilmazim
96,788 views
3 years ago
9:33
How to change the gear lever repair Fiesta Ka Ecosport up to 2009
DOUTOR MAP Mercerol
119,943 views
7 years ago
10:22
Ford Fiesta 2006// B5/IB5 gearbox selector shaft seal
R A M Restauraciones Y Algo Más
214,652 views
4 years ago
8:31
HOW TO TAKE UP THE SLACK IN THE GEARBOX OF THE FIESTA AND ECOSPORT
A.M.S Criações
22,210 views
3 years ago
18:12
Ford IB5 gearbox - assembly, tips and details (Fiesta/Ka/Courier/Escort)
Motores e Mecânica
19,617 views
2 years ago
5:11
how to lubricate gear lever gears; [Ford Ka, fiesta, Ecosport, courier,]
canal do Ka
10,695 views
1 year ago
6:53
Removing Vertical Clearance in the Gear Lever of the Fiesta Rocam
FIESTA Dicas Automotivas
9,224 views
1 year ago
2:23
FIESTA HAS DIFFICULTY IN ENGAGING GEAR
Auto Center Fr
110,416 views
7 years ago
13:25
How to change, repair step by step the lock, core, key of the Ford Ka 98 car
Fuçado seja um também
162,396 views
7 years ago
16:26
How to change the shift lever rod bushing on the Ford Ka Fiesta Courier
Um Pouco das Coisas
26,447 views
3 years ago
17:26
Ford Ka, New Fiesta and Ecosport lock repair step by step. Solved!
Adriano Leonardo Pazzini
116,045 views
3 years ago
27:11
How to fix your trunk or door drum, spending little or nothing
Paulino Força
28,056 views
6 years ago
4:24
How to change the cable on the inside handle of the Ford Ka driver's door
Kanabarroo
680 views
2 years ago
3:46
Trunk won't open? Fiesta Street
Perrengues e Experiências
31,487 views
4 years ago
14:20
how to change the door lock on an old ford ka
celio vlogs e variedades
11,546 views
2 years ago
18:50
I LEFT THE FORD FIESTA WITH SHOW PANEL - I SPENT ONLY 28 REAIS
FELIPE ZOREBA
59,808 views
3 years ago
13:32
FORD FIESTA NAIL KEY - Made by the ignition cylinder.
Vanderlei Margutti - Margutek Eletrônica Chaveiro
24,488 views
2 years ago
8:28
Removing the Ford Ka lock core
Universidade do instalador
30,628 views
6 years ago
23:37
Analog Hall Effect, installing Anti-Drift PS4 Controller.
J-Tech Manutenção de Controles
7,076 views
1 month ago
27:38
Electric Lock + Door Lining - Part 1/2 - Ford Ka 1998
Paulo's Garage
39,701 views
6 years ago
8:12
REPLACING DOOR LININGS ON FIESTA AND COURIER
TAKEO GARAGE
49,428 views
3 years ago
25:46
Ford Fiesta 1.0 2002 - Wheel Bearing Replacement (Front and Rear)
Clayton Nicola
30,393 views
4 years ago
11:29
Replacing rear brake shoes or linings Ford Courier with tips and in detail - Part 02
Um Pouco das Coisas
22,461 views
3 years ago
3:04
Tibbe Key - Ford door cylinder parts.
robertocerraj
38,684 views
4 years ago
14:28
Ford Ka won't shift gears, is the gearbox stuck? Follow this great tip!
Alexandre Menezes
62,633 views
1 year ago
19:26
How to change the door opening actuator cable on a Ford Ka or Fiesta without removing the lock!
faça você mesmo
25,395 views
1 year ago
20:23
How to change the key core of a 98 Fiesta at home
Alex Machado
3,618 views
2 years ago
Google AdSense
336 x 280

fetery.com. Copyright 2024