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
18:21
The affection of a Korean who moved the Uzbek family to tears (Uzbek international couple)
우즈벡 라이프 UZBEK LIFE 우라티비
156,247 views   3 days ago
23:21
Han Hye-jin's Hongcheon Kimchi with Pungja x Um Ji-yoon❤️(I miss Na-rae..^^)｜Kimchi, boiled pork, ramen mukbang, Hongcheon villa, let's be my wife
한혜진 Han Hye Jin
388,041 views   1 day ago
8:14
Don't make it hard to pickle radish✔️ I can't eat this method these days because it's not available.
엄마의손맛
930,505 views   13 days ago
19:57
[VLOG] Tearful Taeyomine Dongdong's Birth Vlog 👼🏻
태요미네
1,187,273 views   1 day ago
19:57
[VLOG] Tearful Taeyomine Dongdong's Birth Vlog 👼🏻
태요미네
1,187,273 views   1 day ago
3:13
[Steph] Choi Ho Jong · Eternal Nightmare Main Character Stage Choice by PUBLIC Mission Solo Cam Stage Voting
The CHOOM (더 춤)
565,936 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]
392,875 views   3 days ago
8:17
I danced in front of Angel - Woowakgudz Hot Clip
우왁굳 Z
172,448 views   3 days ago
23:21
Han Hye-jin's Hongcheon Kimchi with Pungja x Um Ji-yoon❤️(I miss Na-rae..^^)｜Kimchi, boiled pork, ramen mukbang, Hongcheon villa, let's be my wife
한혜진 Han Hye Jin
388,041 views   1 day ago
2:21
Jjajangmyeon Mukbang on Moving day
소맥거핀
740,172 views   18 hours ago
3:31
JAESSBEE - 'All Now with You' Official MV
MMTG 문명특급
1,570,836 views   5 days ago
26:30
🥬8-pack Kimchi🥬Lee Ha-yeon's 2024 Kimchi! All the secret ingredients of the master's kimchi are revealed!
김치쌤 이하연
139,326 views   3 days ago
12:41
Jindo dog that was stuck in an apiary for 2 months returns to its original home
프응TV Honeybeefather
480,243 views   2 days ago
22:18
Noh Hong-chul goes to his older brother's house in Japan (glamping, sauna)
노홍철
411,249 views   1 day ago
22:18
Noh Hong-chul goes to his older brother's house in Japan (glamping, sauna)
노홍철
411,249 views   1 day ago
32:13
Why does that person do that?
[하말넘많] heavytalker
752,365 views   8 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,138,061 views   4 days ago
0:40
[Moana 2] 'Beyond' MV Teaser
Disney Korea
384,731 views   21 hours ago
16:46
Sold out in 10 minutes. Samsung Galaxy Z Fold SE... What are your thoughts after using it for a week?
ITSub잇섭
882,656 views   1 day ago
14:54
Where will Son Heung-min go if he leaves Tottenham?
김진짜 Real KIM
735,829 views   1 day ago
10:34
Don't bother with pickling dongchimi✔️ This method allows you to scrape off all the broth and eat it.
엄마의손맛
656,131 views   9 days ago
29:11
Eat 11,111 calories of Pepero in one day!! (w. Baek & Ah Areum)
박씨집안
251,017 views   4 days ago
23:38
Mysterious Soviet Taxi Driver and Extreme Road Trip - Tajikistan (2)
곽튜브
721,840 views   7 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]
392,875 views   3 days ago
26:37
19 Hour Silk Road Taxi Journey - Tajikistan (1)
곽튜브
1,045,394 views   11 days 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
438,426 views   4 days ago
4:30
[I Live Alone Pre-release] The King's Table in Front of Jeon Hyun-moo?! A Hearty Korean Birthday Table Prepared by Chef Jeong Ji-seon🎂, Broadcast on MBC 241115
나혼자산다 STUDIO
75,581 views   19 hours ago
3:12
JAESSBEE - 'All Now with You' @JAESSBEE 1st Fan Concert 20241115
MMTG 문명특급
274,207 views   14 hours ago
26:30
🥬8-pack Kimchi🥬Lee Ha-yeon's 2024 Kimchi! All the secret ingredients of the master's kimchi are revealed!
김치쌤 이하연
139,326 views   3 days 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
438,426 views   4 days ago
8:45
Understanding the intention of the questioner
너덜트
1,210,218 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,138,061 views   4 days ago
Google AdSense
336 x 280
Up Next
37:33
[Potionomics・Live 03] Finding a stable basic move
Noise on Stage
84 views
2 weeks ago
49:36
[WITCHING STONE Live 01] Connect gems and cast spells in rapid succession, gem puzzle + deck-building rogue-lite
Noise on Stage
59 views
4 days ago
25:27
[Mirthwood] Farm, trade, and adventure in a medieval fantasy world. This RPG life sim where you can choose your own life is so fascinating [Mirthwood] [Steam]
あきねこ - ほのぼのゲームライフ
16,989 views
9 days ago
41:46
[Potionomics Live 06] From ingredients to customers
Noise on Stage
52 views
12 days ago
30:08
[STEAM Business Simulation] 20 Business Simulations You Can Enjoy and Lose Track of Time [2020-2024]
やまチャンネルPCゲーム紹介実況
26,049 views
1 month ago
1:06:46
Confrontations: The World of Quantum and Gravity. Paweł Horodecki, Michał Eckstein, Tomasz Miller
Copernicus
151,244 views
Streamed 1 year ago
1:24:25
The "card shop management game where you can open all the products in your store" is fun [TCG Card Shop Simulator]
ポッキー
439,993 views
1 month ago
2:32:23
Why We Love HARD Games Dark Souls / Bloodborne / Sekiro and More
Bez/Schematu
135,751 views
Streamed 1 year ago
37:20
[Potionomics Live 04] Everyday life is stressful
Noise on Stage
54 views
2 weeks ago
42:25
[Yokai no Kyou: Live 02] Say goodbye to tendonitis with pad support [YAOLING MYTHICAL JOURNEY]
Noise on Stage
36 views
2 weeks ago
2:14:18
BLOODBORNE Cult. Is This the Best Soulslike Game? Discussion
Bez/Schematu
60,364 views
Streamed 1 year ago
41:59
[SULFUR・Live 01] A highly challenging roguelike FPS where you advance through a strange world
Noise on Stage
72 views
6 days ago
3:39:11
FULL PRACTICAL SQL COURSE for Data Analysts 2024
Нікіта Тимошенко [ Аналіз даних українською ]
137,023 views
10 months ago
30:42
#01 [Mirthwood] Free-style playstyle RPG [Game commentary]
シムパパ
2,804 views
8 days ago
48:24
[Miracle] Apparently there's a secret trick to seeing it in the shelter with a 1/100 chance [60 Seconds!] #14
レトルト
1,231,118 views
7 years ago
44:32
[LEAGUE OF LEGENDS・Commentary 17] The minimum goal is 40 consecutive losses
Noise on Stage
254 views
8 days ago
31:38
[Potionomics・Live 05] The momentum is building
Noise on Stage
67 views
13 days ago
31:34
[SULFUR・Commentary 02] Not even 3 minutes left
Noise on Stage
16 views
5 days ago
24:55
[Elin Strategy] 9 things to do before trash can dunking [Zundamon]
ひろぽん
35,921 views
10 days ago
1:44:12
Special for the fifth season of Ex Date program ❌ Ex Date
Ashi Ley
710,178 views
17 hours ago
2:46:51
The MidNight S1 E08 with @SoheilPrank Do you say cream?
AmirEyZed 🍌
98,467 views
1 year ago
2:38:37
The MidNight S2 E03 @thebeniamin (Youtuber) The only girl who doesn't give up no matter how hard you push her is your daughter
AmirEyZed 🍌
77,503 views
11 months ago
41:30
Mr. Judge series 2 - Case 48 - Fraud Serial Aghaye Ghazi 2 - Part 49
Cafe Media - کافه مدیا
46,897 views
8 hours ago
3:21:57
The MidNight S1 E12 @persianrareaction Sohrab & Roham My father gave me the first courier
AmirEyZed 🍌
40,871 views
1 year ago
53:56
A few Saturdays with Sina The sixth chapter Part 9 With the presence of Narges Kalhor Filmmaker, writer and director
MBC PERSIA
71,508 views
9 hours ago
3:27:45
The MidNight S1 E19 @Safirfarsi If you are very attractive, you are here
AmirEyZed 🍌
185,016 views
1 year ago
2:33:05
The MidNight S1 E22 @AmirPhanThom Yes, I had two streamer girlfriends
AmirEyZed 🍌
49,246 views
1 year ago
1:01:49
I reconciled Farshad and Payam JustChetMoments #143
EyZedMoments
37,507 views
5 days ago
2:04:52
Please have dinner with YouTuber (3rd series, 3rd night) JustChetMoments #126
EyZedMoments
32,535 views
1 month ago
2:47:05
The MidNight S1 E09 with @omidlennon I was raised by my father
AmirEyZed 🍌
189,660 views
1 year ago
2:43:55
The MidNight S1 E18 @pixieowo If God said to come, you will not come at all
AmirEyZed 🍌
99,471 views
1 year ago
57:31
( EP0488 ) From rural and ignorant friend to raising children and growling
Soheil Eghtesadi
15,080 views
5 days ago
3:52:15
Good faith? Or a way to escape?
AmirEyZed 🍌
39,951 views
2 years ago
1:02:32
Homayun in the Miracle of Flowers Park and Global Village (Dubai).
Mr’travel
44,200 views
2 days ago
52:28
From Speed ​​Date to Dis Date Kasri and Neda
ROO LINE
23,047 views
18 hours ago
3:04:47
The MidNight S1 E21 @Eshkoort My sister and I have three-digit entrance exams
AmirEyZed 🍌
14,336 views
1 year ago
41:17
Mr. Judge series 2 - The forty-seventh case - The result of a blind trust Serial Aghaye Ghazi 2 - Part 48
Cafe Media - کافه مدیا
116,868 views
1 day ago
2:09:47
Esm Nadareh - Ep. 53 w. Koorosh Wantones, Ketchy Beats and Home Alone
Esm Nadareh
296,633 views
1 year ago
2:32:40
ZERO HOUR #50 KRZYSZTOF STANOWSKI AND PIOTR SZUMOWSKI
Kanał Zero
586,306 views
Streamed 1 month ago
Google AdSense
336 x 280

fetery.com. Copyright 2024