15th Lesson
In this lesson we will look at some differences between traditional pivot tables and two-way pivot tables.
We will also dive into the most important properties that we need to pay attention to when using pivot tables.
=========== INVEST IN YOUR TRAINING ==================
Are you looking to improve your skills and obtain a digital certificate of attendance?
My Masterclasses offer exclusive content and a complete learning experience. By purchasing from my site you will also have access to exclusive discounts.
Don't miss the opportunity to grow professionally.
www.bi4you.it/masterclass/
=========== SUBSCRIBE ON YT =================
Subscribe to this channel to access the benefits: / @lodovicodincau
======= SAFE AND AFFORDABLE SOFTWARE! ==
CyberGhost VPN/Antivirus TOP: www.cyberghostvpn.com/offer/B...
Windows, Office, WindowsServer, SQL Server: mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mice: amzn.to/3Tnu1Kk
Yeti microphone: amzn.to/3YWIM8h
Microphone without stand: amzn.to/3ZXDSci
Yeti Filter: amzn.to/3mZfkRF
Sony Alpha 6400L: amzn.to/42niFu8
Elgato Stream Deck: amzn.to/3Tm94Q8
Elgato Cam Link 4K: amzn.to/3yMOEGo
Elgato Facecam: amzn.to/3TqL0eX
TC Helicon Mixer: amzn.to/3Tmzf9p
RGB keyboard: amzn.to/3JQaOOx
2k Gaming monitors: amzn.to/3yNJWs2
Switch: amzn.to/3JQftQA
My name is Excel: I solve problems: amzn.to/3LxkrD4
DAX book in Italian: amzn.to/3TGHj4L
The Definitive Guide to DAX: amzn.to/3JLunYe
Prime Student 90 days free: amzn.to/3YWDwBm
============ R I S O R S E ====================
Channel index - Available to subscribers only: docs.google.com/spreadsheets/...
Download for subscribers: docs.google.com/spreadsheets/...
Lesson Chapters:
00:00 Introduction
01:16 Traditional Pivot Table
02:07 Two-dimensional Pivot Table
02:52 Types of tables
03:38 How Pivot works
04:41 You might need relationships between tables
06:45 Remove tb of excel from PP
07:21 Data integration flag
07:29 Active Tables
11:35 A-Z sorting and searching
12:38 Distinct Count
13:50 Management of Totals
16:47 Show Details
18:58 Pay attention to filters
19:51 Greetings
#Bidimensional Pivot #PivotTable #ExcelPowerPivot
Негізгі бет Excel PQ/PP - Bidimensional Pivot
Пікірлер: 1