Excel Pivot Tables ➤ Detailed Instructions for Beginners

112,258 views

Андрей Сухов

Published on Aug 19, 2021
About :

???? Excel and Pivot Tables Course - https://andreysukhov.ru Excel Pivot Tables are a very interesting and extensive topic. In this video, I will tell you everything you need to know to start using Pivot Tables in your work. CONTENTS 00:00 Introduction 00:51 Setting the Problem 02:57 Solving the Problem with Formulas (SUMIF) 05:07 Creating a Pivot Table in Excel 12:48 Formatting a Pivot Table 15:32 Grand Totals and Subtotals 17:08 Pivot Table Layout 19:10 Filtering and Sorting Data 22:24 Slicers in Pivot Tables 23:40 Dates in Pivot Tables Related videos: ► Absolute references: • Absolute and relative references ➤ To... ► Smart tables: • Smart table in Excel ➤ Secrets of effe... Additional materials: ➤ Download file with example: https://disk.yandex.ru/i/ily1UYWJ_BakDQ ➤ Text version: https://zen.me/CsmxV ★ Author's books and courses: https://andreysukhov.ru ★ Download course on Excel: https://andreysukhov.ru/education/exc... ★ Telegram: https://t.me/excelmate ★ Zen: https://zen.yandex.ru/id/5c4d8a530aae... ★ VK group: https://vk.com/public212583018 #Excel

  • vidoe Comments
Trend Videos
4:18
Ah, what's the problem?
킥서비스
1,134,383 views   6 days ago
8:14
Don't make it hard to pickle radish✔️ I can't eat this method these days because it's not available.
엄마의손맛
925,498 views   13 days ago
14:54
Where will Son Heung-min go if he leaves Tottenham?
김진짜 Real KIM
726,217 views   1 day ago
26:41
Reasons for not getting married. No, I can't... No, I won't...
걍밍경
687,569 views   1 day ago
8:45
Understanding the intention of the questioner
너덜트
1,186,586 views   1 day ago
25:19
Every word she says makes me nervous. Joo Byung Jin's second blind date full of excitement~ #highlight #CanILoveNow EP.2
tvN STORY 티비엔 스토리
2,131,615 views   4 days ago
26:41
Reasons for not getting married. No, I can't... No, I won't...
걍밍경
687,569 views   1 day ago
28:08
[Eating Vlog #104] From now on, my personal color is chicken feet in soup..❤️‍🔥I'll bring everything that's trendy these days😎 Michelin, Dunkin Dubai, Shin Ramyun Toomba, Dongpa Pork + Jajangmyeon, Chestnut Tiramisu, Marshmallow Cake, S'mores Chocolate
살빼조DietJo
436,818 views   4 days ago
19:57
[VLOG] Tearful Taeyomine Dongdong's Birth Vlog 👼🏻
태요미네
1,165,294 views   1 day ago
8:17
I danced in front of Angel - Woowakgudz Hot Clip
우왁굳 Z
169,548 views   3 days ago
26:30
🥬8-pack Kimchi🥬Lee Ha-yeon's 2024 Kimchi! All the secret ingredients of the master's kimchi are revealed!
김치쌤 이하연
135,612 views   3 days ago
12:41
Jindo dog that was stuck in an apiary for 2 months returns to its original home
프응TV Honeybeefather
476,993 views   2 days ago
54:46
Seoul Mukbang VLOG + One bite Hyeyoung 😋 Episode 3) Samgyeopsal + chicken feet + Mul Naengmyeon Life Kkwabarow + Cheese Bomb Nurungji Chicken + Yogurt World Buldak Bokkeummyeon Cheongwaok Ginger Bear Dore Dore Lotte Hotel X Bomnal Encollaboration 2 nights 3 days Seoul trip❤️MUKBANG
여수언니 정혜영 [Yeosu Unnie]
223,179 views   3 days ago
10:34
Don't bother with pickling dongchimi✔️ This method allows you to scrape off all the broth and eat it.
엄마의손맛
652,833 views   9 days ago
54:46
Seoul Mukbang VLOG + One bite Hyeyoung 😋 Episode 3) Samgyeopsal + chicken feet + Mul Naengmyeon Life Kkwabarow + Cheese Bomb Nurungji Chicken + Yogurt World Buldak Bokkeummyeon Cheongwaok Ginger Bear Dore Dore Lotte Hotel X Bomnal Encollaboration 2 nights 3 days Seoul trip❤️MUKBANG
여수언니 정혜영 [Yeosu Unnie]
223,179 views   3 days ago
11:49
When I first visited my sister-in-law's newlywed home after she got married in Korea, there were so many new things that I was surprised by.
예나러브 [Jun & Yena]
385,964 views   3 days ago
14:54
Where will Son Heung-min go if he leaves Tottenham?
김진짜 Real KIM
726,217 views   1 day ago
28:08
[Eating Vlog #104] From now on, my personal color is chicken feet in soup..❤️‍🔥I'll bring everything that's trendy these days😎 Michelin, Dunkin Dubai, Shin Ramyun Toomba, Dongpa Pork + Jajangmyeon, Chestnut Tiramisu, Marshmallow Cake, S'mores Chocolate
살빼조DietJo
436,818 views   4 days ago
10:32
The Meat-Eater Reveals Seoul's Best Sausage Restaurants (Not an Advertisement)
잡식맨 JOBXICMAN
180,952 views   4 days ago
25:19
Every word she says makes me nervous. Joo Byung Jin's second blind date full of excitement~ #highlight #CanILoveNow EP.2
tvN STORY 티비엔 스토리
2,131,615 views   4 days ago
26:50
Palbok's gender has been revealed~!!!!!
아뽀TV
437,779 views   3 days ago
26:30
🥬8-pack Kimchi🥬Lee Ha-yeon's 2024 Kimchi! All the secret ingredients of the master's kimchi are revealed!
김치쌤 이하연
135,612 views   3 days ago
11:49
When I first visited my sister-in-law's newlywed home after she got married in Korea, there were so many new things that I was surprised by.
예나러브 [Jun & Yena]
385,964 views   3 days ago
11:17
A day in the life of a veteran construction worker who shows up on his bike at dawn
에어부산
203,619 views   3 days ago
23:46
Realistic reasons for leaving Britain.
연국의 내일 Plan B Yeonguk
594,861 views   4 days ago
26:37
19 Hour Silk Road Taxi Journey - Tajikistan (1)
곽튜브
1,043,864 views   10 days ago
13:14
Sister, would you really do a kimchi business with me? (with Yangnyeompak Park Junmyeon) [Eng sub]
덱스101
279,829 views   4 days ago
23:46
Realistic reasons for leaving Britain.
연국의 내일 Plan B Yeonguk
594,861 views   4 days ago
4:57
Lee Su Yeon - You Know My Name [Immortal Songs 2 Singing the Legend/Immortal Songs 2] KBS 241109 Broadcast
KBS 레전드 케이팝
1,019,681 views   6 days ago
10:32
[Rising in popularity] The all-purpose 'ginger juice' is really easy! Don't miss out on fresh ginger✔️ these days and make it~ (+Hemma Hangju gift set)
땅끝마을 임선생
177,858 views   4 days ago
18:21
The affection of a Korean who moved the Uzbek family to tears (Uzbek international couple)
우즈벡 라이프 UZBEK LIFE 우라티비
152,245 views   3 days ago
29:11
Eat 11,111 calories of Pepero in one day!! (w. Baek & Ah Areum)
박씨집안
248,730 views   4 days ago
Google AdSense
336 x 280
Up Next
1:20:46
Life Without Thoughts with Arthur Sita
Счастье с Артуром Сила
47,193 views
Streamed 7 months ago
1:31:28
ENLIGHTENMENT. AWAKENING. Watch THIS and your LIFE will change Sergey Kuldin
Время Открыть
272,846 views
2 weeks ago
2:55:14
Life Without Thoughts with Arthur Sita
Счастье с Артуром Сила
58,257 views
Streamed 7 months ago
1:35:51
Enlightenment Comes When You Disappear Into Emptiness OSHO
Источник Познания
235,461 views
1 year ago
1:59:21
Man and Woman - Arthur Sita - 2.04.22
Счастье с Артуром Сила
184,012 views
Streamed 2 years ago
29:19
How to Get Out of Suffering. Arthur Sita.
Любодар Инфо
83,273 views
8 years ago
55:32
OSHO – WHO IS HE? 🤔 A MYSTIC, A SECTARIAN OR A SCAMMER? WHAT WAS HIS SECRET?
СКРЫТАЯ РЕАЛЬНОСТЬ | Подкаст с АРТУРОМ СИЛА
103,037 views
3 months ago
37:43
How to get everything done without fuss and anxiety
СКРЫТАЯ РЕАЛЬНОСТЬ | Подкаст с АРТУРОМ СИЛА
70,199 views
2 months ago
2:46:36
Open Live Broadcast with Arthur Sita Event January 26, 2023 New Year's Retreat in Thailand
Счастье с Артуром Сила
48,785 views
Streamed 1 year ago
49:53
PRACTICE AND ENLIGHTENMENT
СКРЫТАЯ РЕАЛЬНОСТЬ | Подкаст с АРТУРОМ СИЛА
86,788 views
3 months ago
3:36:26
What is beyond thoughts
Счастье с Артуром Сила
303,685 views
Streamed 4 years ago
1:28:06
How to Realize Yourself - Arthur Sita - Live 1.05.22
Счастье с Артуром Сила
46,033 views
Streamed 2 years ago
1:39:40
SECRETS OF SHIVAITES AND BRAHMINS – NIKITA MASHKIN
Йога Тичер
4,251 views
12 days ago
1:49:16
Mindfulness: Living Without Thoughts with Arthur Sita
Счастье с Артуром Сила
62,111 views
Streamed 7 months ago
1:35:15
If after this video you are not awakened, then it is just a shame))). Satsang in Berlin 19.0624
Сергей Кулдин
132,017 views
3 months ago
1:53:24
How Does Gut Health Affect Brain Health? A Conversation Between Sadhguru and Dr. Emeran Mayer
Садхгуру — официальный канал на русском
223,892 views
3 months ago
1:40:21
You are not a human being. You are CONSCIOUSNESS.
Счастье с Артуром Сила
396,403 views
4 years ago
1:18:56
Relationships, money, health, fate: Dmitry Trotsky
Александр Авакянц
276,539 views
5 months ago
2:04:26
Open Live with Arthur Sita in Thailand February 10
Счастье с Артуром Сила
40,972 views
Streamed 9 months ago
45:11
What type of meditation is right for you? What will meditation give you?
СКРЫТАЯ РЕАЛЬНОСТЬ | Подкаст с АРТУРОМ СИЛА
60,302 views
3 months ago
5:27
Santiago Bernabéu L10 still has works to do on the accesses
BveMike Studios
54 views
8 days ago
1:17:40
Circulations through Nuevos Ministerios station
ItzAlfredoYT
55,783 views
2 years ago
22:01
Spain, Madrid, Metro ride from Manuel Becerra to Nuevos Ministerios
Anton V.
161,673 views
6 years ago
12:43
Subways in November 2024.
JUNAVIDEOT JA METROT
539 views
7 days ago
5:03
Various things Santiago Bernabéu L10
BveMike Studios
52 views
8 days ago
25:06
Roblox PHASE 2 C-5 Renfe Cercanias Atocha / Mostoles - El Soto
BveMike Studios
43 views
7 days ago
30:03
[REOPENING] Circulation on Gran Vía L1, L5: Madrid Metro (Series 2000A, 2000B, 3000)
ItzAlfredoYT
39,332 views
3 years ago
9:41
Modernization of the Brasov - Sighisoara Railway 31.10.2024
Tot Ce Zboară Se Mănâncă
2,808 views
2 weeks ago
2:45
Madrid Metro Nuevos Ministerios station L8
BveMike Studios
145 views
8 days ago
15:12
💵WHAT DO YOU BUY WITH $100 IN THE USA? 🇺🇸/ Is a supermarket expensive in North America?
Van de a 4
254 views
1 hour ago
46:03
BAYLY LIVE Incredible Trump and Biden meeting failed?
MegaTV
79,665 views
1 day ago
5:51
Streetwalks - Montreal Metro Berri-UQAM - November 7th 2024
Kapitan Curtis
562 views
7 days ago
27:49
Spain, Madrid, Metro Light ride from Pinar de Chamartin to Las Tablas
Anton V.
145,037 views
6 years ago
55:01
Travelling on line 5 between Casa de Campo and Alameda de Osuna Madrid Metro
ItzAlfredoYT
51,832 views
1 year ago
6:04
Metros at the University of Helsinki and Vuosaari
JUNAVIDEOT JA METROT
775 views
10 days ago
18:24
Madrid Metro: CUATRO CAMINOS 🚇 Series 3000, 2000A and 8400 on Lines 1, 2 and 6 + EMT Buses 🚍
291281
53,445 views
2 years ago
3:12
Madrid Metro Santiago Bernabéu station L10 - November
BveMike Studios
79 views
8 days ago
1:26:55
New energy from the perspective of the regulator and the state, Smart NRG Forum (September 29, 2020)
Smart NRG Forum
111 views
7 days ago
Google AdSense
336 x 280

fetery.com. Copyright 2024