The Best Excel Shortcut to Impress Your Boss! Ctrl E Practical Examples and Free Spreadsheet

66,255 views

Excelente João

Published on Dec 8, 2024
About :

🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵 FREE DOWNLOAD EXCEL SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this Excel video lesson, we will learn one of the best Excel keyboard shortcuts, the Ctrl E shortcut. This Excel shortcut gives us access to a very important tool called Flash Fill or AutoComplete in Excel. This shortcut can be very useful for you to Automate Tasks and Processes in the Excel Spreadsheet. A practical example of the use of this function is when we download a report, for example, and in the table we have a column with the date, however, in this column we have the date together with the time and I only need the date in the column, I don't want to use the time. A great way to separate Date and Time is by using the keyboard shortcut Ctrl + E. To do this, simply type what you need in a column next to it and in the cell below press the shortcut, and that's it. Now all the rows will have AutoComplete following the pattern you created. We can also use the Ctrl E function to Join Columns, Separate Columns, Separate First Name from Last Name, Join First Name with Last Name, etc. We can use this Excel functionality to create phone number patterns, CPF CNPJ masks, etc. So, with this Excel functionality, we can save time in our daily lives and stand out in the Job Market with Excel. Basically, AutoComplete can help you quickly insert functions and arguments, minimizing typing and syntax errors. The AutoComplete menu shows the available options based on the context and you choose what you want to insert in your formula. #ExcellentJoão #Excel #Dashboard

  • vidoe Comments
Trend Videos
20:26
And a new beginning, first independence
지유롭게
1,100,314 views   1 day ago
22:12
[VLOG] I like Aunt Jiyu better❓❤️ (Cheer up, Aunt Jiyu⭐️)
리쥬라이크 LIJULIKE
626,436 views   1 day ago
0:19
RIIZE RISE 'Hug' Stage Video Teaser
SMTOWN
171,076 views   1 day ago
12:52
145,000 won per person? The most expensive strawberry buffet in Korea
더들리
504,650 views   1 day 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
157,181 views   2 days ago
9:59
🥔Ep. 0 ㅣ CEO KWANGSOO Dreams Big, KYUNG SOO Makes It Happenㅣ👨‍🍳🥔GBRB Spinoff
채널십오야
908,418 views   1 day ago
4:09
BOYNEXTDOOR (보이네스트도어) 'Today Only I LOVE YOU' Official MV
HYBE LABELS
6,981,287 views   1 day ago
15:07
Lee Ji-hye's emotional surprise camera of her husband who bursts into tears (Terry Ellie, crying)
밉지않은 관종언니
264,632 views   1 day ago
13:32
To be or not to be thyroid cancer, that is the question...
배말랭
462,471 views   2 days ago
9:55
I will tell you honestly why I did not receive the diamond button related to the number of subscribers.
보겸TV
1,291,205 views   2 days ago
29:25
Finnish Applicant's Winter Kingdom Survival Story [Finland 1]
레오티비 LEOTV
272,220 views   1 day ago
11:41
NIS Security Level(?), The Truth I Learned After My Husband Disappeared Y Drive
궁금한 Y
546,532 views   3 days ago
3:35
GFRIEND 'Season of Memories' (4K) STUDIO CHOOM ORIGINAL
STUDIO CHOOM [스튜디오 춤]
391,210 views   14 hours ago
5:15
Blue and Summer - Mrs. GREEN APPLE / COVER by LILPA
릴파 lilpa
1,016,457 views   11 days ago
2:15
[Captain America: Brave New World] Main Trailer
MarvelKorea
713,948 views   2 days ago
24:30
[🇦🇺vlog] A busy 2024 summer Christmas vlog spent with family
해쭈 [HAEJOO]
486,834 views   2 days ago
5:34
Team MID Interview 2025 Season 1 [Invitation to Noxus] Season Opening
LCK
375,625 views   18 hours 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]
조동아리
385,001 views   3 days ago
7:45
[39th Golden Disk] GFRIEND - 'Intro + Running Through Time + Night + In Our Affectionate Season' ♪ JTBC 250107 Broadcast
Golden Disc
1,037,981 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
740,982 views   2 days ago
8:34
I don't know Korean, sir
너덜트
612,792 views   18 hours ago
11:04
Compliments are pouring in🥇 My heart is exploding! 50 years of secret recipe for refreshing Napa Cabbage Kimchi
딸을 위한 레시피 Recipes for daughters
79,767 views   1 day ago
21:15
A heart-pounding winter survival operation💕
원지의하루
357,910 views   1 day ago
48:25
'Squid Game 2' Review
침착맨
962,011 views   2 days ago
28:38
[vlog] Year-end spent with loved ones
찰스엔터
358,473 views   1 day ago
10:24
A man you absolutely must not miss
짧은대본 ShortPaper
1,678,949 views   10 days ago
9:22
No, honey, stop crying;;
김계정
460,530 views   3 days ago
8:34
I don't know Korean, sir
너덜트
612,792 views   18 hours ago
9:55
I will tell you honestly why I did not receive the diamond button related to the number of subscribers.
보겸TV
1,291,205 views   2 days ago
11:04
Compliments are pouring in🥇 My heart is exploding! 50 years of secret recipe for refreshing Napa Cabbage Kimchi
딸을 위한 레시피 Recipes for daughters
79,767 views   1 day 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]
조동아리
385,001 views   3 days ago
9:22
No, honey, stop crying;;
김계정
460,530 views   3 days ago
Google AdSense
336 x 280
Up Next
17:04
VECTRA PANEL LOCKED, THE POINTERS DO NOT WORK - also change the TID film.
Vanderlei Margutti - Margutek Eletrônica Chaveiro
9,221 views
1 year ago
6:24
DEFECT IN THE TIMING COUNTER AND SPEEDOMETER OF THE VECTRA 97
Auto elétrica do Fininho
17,212 views
3 years ago
23:55
Sollers ST6 - Everything fell down for us;)
Клубный сервис
75,802 views
4 hours ago
15:02
It's started! The collapse of prices for the German 3 in China.
Гилевич Сергей
102,882 views
6 hours ago
13:13
How to change the polarized film, this tip is valid for several cars
oficina wrs.
15,857 views
1 year ago
15:19
Cruel Doubt: Is it a Dashboard or a Speed ​​Sensor? Dashboard Doesn't Work SPEEDOMETERS? Tips Check it out!
WILLIAM - VELOMOTORS
165,872 views
3 years ago
13:27
#Vectra - Hidden Details You Didn't Know Existed.
GARAGEM DO DANILO
278,197 views
3 years ago
14:51
CORSA SPEEDOMETER AND RPM PANEL DOES NOT WORK, REMOVAL TIP, BEARING KIT REPLACEMENT
SANDRO LAVELLE (SANDRO LAVELLE)
31,427 views
3 years ago
20:59
ERROR PR09 - GM VECTRA PANEL - And a bunch of other problems. pointer, burnt IC and broken track.
Vanderlei Margutti - Margutek Eletrônica Chaveiro
4,983 views
1 year ago
33:15
FIAT UNO DOES NOT RECOGNIZE THE KEY - IMMOBILIZER LIGHT DOES NOT GO OFF - RANDOM DEFECT
Vanderlei Margutti - Margutek Eletrônica Chaveiro
4,788 views
1 month ago
24:30
Vectra Definitive Guide to Electrical Problems Relays and Fuses
Tecnotip Dicas
59,374 views
2 years ago
24:26
GOL G2 PANEL KM 999999 POINT SHAKING - CORRUPT AND LOCKED FILE
Vanderlei Margutti - Margutek Eletrônica Chaveiro
2,366 views
3 months ago
24:03
How to fix Vectra Speedometer (Instrument Panel) Part 1
Tecnotip Dicas
43,504 views
3 years ago
15:58
VECTRA SPECIAL ON THE FAST LAP! Vectra A GSI x Vectra B Challenge x Vectra C Collection on the track
Acelerados
327,122 views
10 months ago
1:22:37
Repair CAMARO (2.0T LTG): Hydraulic shock
Мастерская K-POWER
375,096 views
12 days ago
11:59
WHERE TO LOCATE ALL THE VECTRA FUSES AND RELAYS, FINDING OUT THEIR AMPERAGE AND FUNCTION IN THE VEHICLE.
O CONHECIMENTO TEM QUE SER COMPARTILHADO.
102,647 views
1 year ago
24:16
The horror at the service station or the everyday life of auto mechanics #247. Emergency mobile repair of the Lada Kalina internal combustion engine in a short time!
Auto Port
42,893 views
7 hours ago
24:32
REMOVE THE VECTRA 97 TO 05 PANEL TO CHANGE THE LIGHT BULBS OR LEDS, WITHOUT BREAKING ANYTHING
PAULO DE ALMEIDA, DICAS DO ALMEIDÃO
8,433 views
2 years ago
16:35
How to fix the Vectra's electric rearview mirror control button!
Top Corsa 98
18,279 views
3 years ago
12:38
How to find faults in Vectra without a scanner? (Injection light)
Tecnotip Dicas
43,526 views
3 years ago
17:53
Universal Multimedia Installation China MP5 Winner in Vectra Elite Steering Wheel Control and Rear Camera
Mecânico Mestre
5,293 views
8 months ago
11:18
How to install a Chinese Android 1.8 multimedia center, direct connection tips and post key
MARCELO SOM OFICIAL
468,668 views
3 years ago
16:58
Multifunction steering wheel with multimedia - Installing steering wheel interface
Joao AVR
174,814 views
3 years ago
38:06
WANT TO LEARN??? COMPLETE INSTALLATION + TIPS!!! ☢JuNiOr SoM♛®
JuNiOr SoM
879,977 views
4 years ago
19:55
HOW TO INSTALL SOUND ON CORSA
magaiver012
33,405 views
2 years ago
10:08
Replacing Vectra door speaker (Elegance, Elite, Expression)
André Helena
6,297 views
2 years ago
3:13
vectra elite multimedia 9 inch
SINTONIA CAR
2,282 views
3 months ago
11:49
#16 Multimedia - Professional wiring harness without cutting the car wires (Android Multimedia Center)
Garagem do Sady
110,136 views
2 years ago
20:42
installing multimedia center and rear cameras in vektra gt... And installation tips
MARCELO SOM OFICIAL
46,085 views
5 years ago
17:22
REAR VIEW CAMERA INSTALLATION AND TIPS CHEVROLET VECTRA ELEGANCE
Garagem KW
10,147 views
4 years ago
10:52
Vectra ELEGANCE 2.0 2009 OWNER'S Opinion after 6 months with the Car
Realidade Auto
17,294 views
4 months ago
9:59
How to turn on the Vectra Elite steering wheel button lighting
Mecânico Mestre
3,074 views
8 months ago
4:03
See How to Connect the Chevrolet Vectra Steering Wheel Control ☑️
Alarme Fácil
13,381 views
1 year ago
11:34
How to install a rear view camera on a Chinese multimedia system #playsound
Playsound
723,890 views
4 years ago
18:46
RADIO INSTALLATION in the original wiring harness very FAST; UPMOTORS
Upmotors Centro de Formação Automotiva
35,101 views
1 year ago
19:49
How to remove the Pos-Key from the Multimedia Center and Prevent the Sound from Stealing Battery Power 2021.
Deivide Oliveira
90,944 views
3 years ago
Google AdSense
336 x 280

fetery.com. Copyright 2024