PivotTable Basics in Microsoft Excel for Beginners [PivotTable Tutorial 1/5]

115,454 views

Digitale Profis

Published on Jul 21, 2022
About :

Download the files: https://bit.ly/pivotde All videos in the series PivotTables 01: Basics - • PivotTable basics in Microsoft Ex... PivotTables 02: Formatting PivotTables - • [Pivot Complete Course 2/5] PivotTables ... PivotTables 03: Sorting, filtering & grouping - online from July 25th, 2022 PivotTables 04: Values ​​in PivotTables - online from July 27th, 2022 PivotTables 05: PivotCharts and interactive dashboards - online from July 29th, 2022 PivotTables have become an indispensable part of professional work with Excel. Sooner or later, almost all areas and applications will have to deal with the topic, and that is why confident use of Pivot is now a prerequisite in many jobs. In this first part of the complete course on PivotTables in Microsoft Excel, we really start with the basics - what are PivotTables anyway, how can we create them and what are the most important areas and functions. We start by learning how to structure our source data correctly for working with PivotTables. Then we explain exactly what the PivotTable fields are and how we can use them. After we have talked about the new tabs in the ribbon - PivotTable Analysis and Design - we look at PivotTable actions and learn how to update the PivotTable using Refresh and Change Data Source. We also show how you can simplify the whole thing using a table and explain in detail what the PivotTable Cache is and how it works. Video content 00:00 Welcome 00:56 Overview and download of the example file 03:25 Structuring data correctly for a PivotTable 08:23 Inserting/creating PivotTables 12:06 The PivotTable fields explained 23:11 The PivotTable analysis and design tabs in the ribbon 25:37 PivotTable actions explained 32:00 Refreshing and changing data sources 40:00 Formatting data as a table to work better with changing data 47:32 The PivotTable cache 55:35 Automatically generating filtered output data 59:06 Outro

Trend Videos
36:19
4,022,008 views   4 days ago
11:16
518,340 views   2 days ago
8:34
1,133,262 views   8 days ago
5:25
25:02
3:13
10,996,380 views   2 days ago
10:48
725,942 views   4 days ago
25:02
7:16
2,745,869 views   5 days ago
5:25
3:29
330,360 views   1 day ago
3:13
10,996,380 views   2 days ago
Google AdSense
336 x 280
Up Next
17:47
*Papier Verrückte*
1,261 views
2 days ago
1:28:00
*Papier Verrückte*
1,396 views
Streamed 1 month ago
9:20
9:24
Cosis Dekotipps
3,149 views
1 hour ago
20:40
*Papier Verrückte*
5,342 views
2 months ago
23:32
Kunterbunt & Kreativ
1,533 views
4 days ago
23:23
*Papier Verrückte*
1,902 views
1 month ago
21:04
1:24:36
LUISE HEINZL - JUNK JOURNAL ART
6,334 views
2 days ago
1:51:38
Alexandra Grape
7,514 views
2 weeks ago
9:24
Cosis Dekotipps
3,149 views
1 hour ago
28:37
Yammibean
224,371 views
2 days ago
1:05:48
Andrea bastelt mit Action, Tedi und Co
1,190 views
2 days ago
39:18
23:31
18:32
Einfach Lilienhaft
4,237 views
2 days ago
9:20
Google AdSense
336 x 280

fetery.com. Copyright 2024