Essential Excel functions that will become increasingly important in the future! The first step toward becoming an Excel expert Everything about table functions Basic introduction 14 lessons - 오빠두엑셀 l 엑셀 강의 대표채널 - World Latest Movie, Series, Videos and Trailers | fetery.com

Essential Excel functions that will become increasingly important in the future! The first step toward becoming an Excel expert Everything about table functions Basic introduction 14 lessons

139,866 views

오빠두엑셀 l 엑셀 강의 대표채널

Published on Feb 17, 2021

About :

👇🏻 Download example files used in the lecture https://www.oppadu.com/%EC%97%91%EC%8... ⭐We have opened the Oppa Do Excel We Can Do membership channel. / @oppadu Pro: Live lecture full video replay provided Premium: On-site workshop attendance and premium member-only posts ❤️ Oppa Do Excel official website: https://www.oppaducom 📚 Go to Excel Community: https://www.oppadu.com/question 00:00 Lecture starts 00:37 What is the table function? 01:05 Difference between table and range 02:00 When do you use the table function? 03:22 How to use the table function - Basics 05:23 Let's look at the advantages and disadvantages of the table function 05:28 Advantage 1. Auto filter function 06:07 Advantage 2. Summary row function 07:39 Advantage 3. Table style function 07:50 Advantage 4. Formula auto-fill feature 09:09 Advantage 5. Auto-expand feature 11:18 Advantage 6. Slicer feature 12:21 Advantage 7. Structural reference 13:44 Disadvantage 1. Cell merging is not possible 14:35 Disadvantage 2. Difficulty in using structural reference 14:47 Looking at structural reference 16:39 Precautions when using structural reference 18:53 How to solve the problem of absolute reference error

vidoe Comments

Trend Videos

15:35

💀 The truth of the world... Seoul, Busan, and Incheon are all sinking / 💀 The dangers of rising sea levels

지식해적단

488,861 views 5 days ago

5:01

[Hwang Young-woong regular album] Your side_Official music video

황영웅 Tv

1,136,652 views 2 days ago

17:48

It takes at least an hour just to decide what to eat out.. (ft. Is this just my family..?)

미자네 주막

319,883 views 3 days ago

3:55

PLAVE - What If Official M/V

GENIE MUSIC

452,236 views 4 days ago

21:06

I went to Jakarta to eat Nasi Goreng⎪🇮🇩Indonesia1

원지의하루

503,277 views 3 days ago

5:02

2 weeks before the second birth, Jo Du-pal (+30kg)

조두팔

266,518 views 2 days ago

9:05

[Musical Star] Kwak Philip - I'm a Monster (MONSTER) Frankenstein (4K)

빵송국

287,108 views 5 days ago

42:17

[SUB] We've invited the Nobel Dopamine Prize candidates👩‍🎓 [I didn't prepare anything] EP.31 #LeeYoungJi #HaeWon

차린건 쥐뿔도 없지만

4,524,984 views 6 days ago

25:49

Moving to a two-room rooftop apartment with three terraces in Seoul - [Single-family home 3]

계곡은개골개골

246,440 views 2 days ago

1:11

[Steph] Korean Dance Choi Ho-jong 'Nightmare' Main Role Casting Audition

The CHOOM (더 춤)

405,123 views 2 days ago

11:07

I'm surprised that cabbage kimchi is this delicious.

김대석 셰프TV

572,054 views 7 days ago

13:18

Can you beat Minecraft in Adventure Mode?

우융

260,443 views 5 days ago

11:53

Japan's Hidden Gourmet Snack 'Basashi' [馬刺し]

유우키의 일본이야기 YUUKI

373,158 views 3 days ago

38:53

[Ep.9] Funeral Hall Laughing Failed 4-Party Face-Off Jo Dong-A-Ri VS Joo Doo-A-Ri [Jo Dong-A-Ri Episode 9]

조동아리

766,400 views 6 days ago

16:12

💀Continuing abnormal climate on the Korean Peninsula… How are we coping with it? / 💀 feat. Gyeonggi-do

지식해적단

177,624 views 2 days ago

19:39

Waking up at 6:30 AM ㄷㄷ A day in the life of the 7 rookies of 2025 who joined Daejeon training for the first time🐥

Eagles TV

248,583 views 1 day ago

5:02

2 weeks before the second birth, Jo Du-pal (+30kg)

조두팔

266,518 views 2 days ago

2:51

SAY MY NAME 'WaveWay' MV

SAY MY NAME

1,076,095 views 1 day ago

8:57

Why Son Heung-min is better without Hwang Hee-chan

김진짜 Real KIM

676,480 views 6 days ago

3:16

Neneko Mashiro 'Spring Dream'

네네코 마시로 NENEKO MASHIRO

115,321 views 1 day ago

11:34

How much will the taxi fare be?

고재영

1,013,279 views 2 days ago

3:55

PLAVE - What If Official M/V

GENIE MUSIC

452,236 views 4 days ago

10:22

Grilling 3.2kg King Crab with Mayonnaise

먹어볼래TryToEat

431,223 views 4 days ago

18:45

Yeon Jung Hoon reveals for the first time the secret to seducing 22-year-old Han Ga In (against marriage, dating story)

자유부인 한가인

1,030,336 views 7 days ago

3:47

DRAMAㅣZINGBERGER COVER

징버거 JINGBURGER

432,178 views 5 days ago

1:11

[Steph] Korean Dance Choi Ho-jong 'Nightmare' Main Role Casting Audition

The CHOOM (더 춤)

405,123 views 2 days ago

4:05

[4K] Lee Ho-kwang - Land of Lola (Angel: Bori, Yari) LIVE @241013 Congratulatory Song

짱호

332,566 views 3 days ago

5:01

[Hwang Young-woong regular album] Your side_Official music video

황영웅 Tv

1,136,652 views 2 days ago

1:11

[Steph] Korean Dance Choi Ho-jong 'Nightmare' Main Role Casting Audition

The CHOOM (더 춤)

405,123 views 2 days ago

11:53

Japan's Hidden Gourmet Snack 'Basashi' [馬刺し]

유우키의 일본이야기 YUUKI

373,158 views 3 days ago

16:21

Kang Min-a, who got married in Yeoju

인생84

1,355,180 views 5 days ago

17:05

[Daily Vlog] What do you do when you're not filming mukbang? 😲 Real close-up vlog of playing, eating, and working hard💻📝 (feat. Speak)

살빼조DietJo

236,148 views 2 days ago

Google AdSense
336 x 280

Up Next

50:13

TAYRONE 2024 - 12 NEW SONGS (NEW CD) - UPDATED REPERTOIRE

Melodia TopTop

11,648 views
1 day ago

34:24

TOUCH TEN OF SARESTA 2024 - TOUCH TEN OCTOBER 2024 - TOUCH TEN AT MAXIMUM 4.0 - TOUCH TEN LAUNCH

DMM HITS

21,117 views
14 hours ago

1:05:34

TAYRONE - LIVE DVD IN SALVADOR - COMPLETE

Tayrone

18,724,322 views
8 years ago

54:38

FABIO PAZ - SPECIAL ROMANTIC SERESTA - THE BEST OF SERESTA

CASA DA SERESTA - O MELHOR DA SERESTA

450,896 views
1 year ago

1:17:07

Roberta Miranda, Amado Batista, Pablo, Eduardo Costa, Black Race..🎻Country Music Suffering 2024

Sertaneja 2024

615,626 views
2 weeks ago

33:28

FROM BAR TO BAR 5 - NATANZINHO LIMA FEAT. RAI ROUND SKIRT

Natanzinho Lima Oficial

12,213,607 views
4 months ago

35:58

Tayrone Luxury Cheesy Serenade

Nostalgico

5,650,375 views
6 years ago

53:07

Zezo The best 2022

Gabriell DSoul

10,013,847 views
2 years ago

1:08:42

Review Without Taking It Out - Klessinha's Seresta Ep COMPLETE OFFICIAL

Seresta da Klessinha

1,240,722 views
1 month ago

1:30:30

Pablo - Audiovisual 20 years (Complete)

Pablo Oficial

780,289 views
2 weeks ago

32:32

VAZZINHO FERNANDES 2024 - GOOD ROMANTIC SERESTA - SERESTA TO TAKE ONE - THE BEST OF SERESTA

CASA DA SERESTA - O MELHOR DA SERESTA

26,004 views
11 months ago

49:24

TAYRONE CIGANO - Show Aracaju 2006 (Complete)

MrCezzars

17,174,782 views
11 years ago

59:20

Pablo 2024🙌 Pablo 20 YEARS Pablo Best New Songs 2024🎻 Pablo's Most Played Songs 2024

Sertaneja 2024

440,671 views
3 weeks ago

1:14:33

TAYRONE 2024, TAYRONE TBT OF TAYRONE, TAYRONE MARCH 2024, TAYRONE 2024 UPDATED

iuXan CDS

567,144 views
7 months ago

33:23

TOUCH TEN OF SARESTA 2025🧡TOUCH TEN OCTOBER 2024🧡TOUCH TEN AT MAXIMUM 4.0, TOUCH TEN 2024, DEC 4.0

DMM HITS

82,057 views
1 day ago

1:20:31

AMADO BATISTA AND ROBERTA MIRANDA SERESTA 2024 SELECTION - ONLY THE BEST OF SERESTA# ROBERTAMIRANDA

Sertaneja Sofrência

57,591 views
1 day ago

51:46

NATANZINHO LIMA - (NATTANZINHO LIMA'S SERESTÃO) OCTOBER - N.LIMA - NEW SONGS

Dodô Diplomata

10,616 views
6 hours ago

52:32

TAYRONE 2020 - 100% QUALITY, NO INTERVAL, NO ADVERTISING, NO VIGNETTES,

Podcast do GD

460,713 views
4 years ago

28:18

silvano sales the passionate singer #arrocha #Bahia #joaomonte

João Monte Bahia

1,004,965 views
1 month ago

31:46

Good Old Serenade 2020

Alcione Calorinda

5,180,984 views
4 years ago

57:18

Vlog at the Saint Quentin Fair 2020: An intense edition with strong sensations

FP Ride

6,642 views
4 years ago

1:01:32

Dunkirk Fair - France - December 2022

FP Ride

2,256 views
1 year ago

1:15:02

François Damiens drives his customers crazy! 😝 (Compilation)

Les caméras cachées de François Damiens

92,113 views
5 days ago

18:28

BoosterCaptain Off/OnRide Etaples Sur Mer 2024

Leo Game

50 views
4 days ago

50:16

EUROPE RASCAGED, episode 1: BRUSSELS

Vincent Lapierre

410,862 views
2 weeks ago

53:20

Immersive Vlog at the Douai Fair - France - July 2022

FP Ride

4,170 views
2 years ago

46:42

Vlog at the Saint Martin de Soissons Fair - France - November 2022

FP Ride

3,225 views
1 year ago

1:31:06

Saint-Romain Fair 2023 On ride POV

LTRide - Fête Foraine & Parc d'Attraction

3,612 views
8 months ago

59:17

Vlog at Walibi Belgium for the Halloween season - Belgium - October 2022

FP Ride

10,468 views
1 year ago

20:39

Calais Fair - France - January 2023

FP Ride

1,772 views
1 year ago

54:11

Phantasialand discovering Wintertraum - Germany - December 2022

FP Ride

420 views
1 year ago

5:09

A trip to Saint-Quentin? (Vlog)

Pôle Jeunesse - Saint-Quentin

1,839 views
1 year ago

22:42

SAINT QUENTIN FAIR 2023/ THE FACTORY

Erwan Maxxx

10,454 views
1 year ago

1:27:59

The Little Secrets of Funfairs - Full Documentary - AMP

Reportages et investigations

432,217 views
2 years ago

1:52:07

Vlog at the Saint-Romain fair in Rouen (Full report) - France - November 2022

FP Ride

5,103 views
1 year ago

17:12

Saint Denis Fair 2023 Saint Quentin (Aisne, Picardy, France) - Ranger XXL - L'Usine ...

Chez Gunjiskan

891 views
1 year ago

59:04

funfair MEETT toulouse first edition 2023 🔥🔥🔥🔥

Fete Foraine de France

5,428 views
1 year ago

20:21

Report: assembly and installation of the Saint Michel fair in Le Havre in 2023

dream event 76

5,071 views
1 year ago

16:32

Saint Denis Fair 2020 Saint Quentin (Aisne, Picardy, France)

Chez Gunjiskan

5,585 views
4 years ago

Google AdSense
336 x 280