Excel PivotTables - Group Text Fields and Tips for working in Groups
4.8 هزار بار بازدید -
2 سال پیش
-
Grouping Text Field in a
Grouping Text Field in a PivotTable is easy. You simply select the fields, right-click and select Group. For example, you may want to group certain employees by department, certain car brands by country, and customers by consumer vs. commercial customer. You usually group text fields in a PivotTable when the data source doesn't have the grouping field you need.
Chapters:
0:00 Intro
0:17 Create a PivotTable
1:10 Group text fields
2:20 Rename a group
3:00 Move a group
3:25 Turn off subtotals
3:50 Turn off groups
November 2022 - YouTube videos
---------------
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips Excel PivotTable - Percentage of Row ...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY Excel Tiered Conditional Formatting w...
Teams Online Course Promotion Teams Online Course Promotion
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total Excel PivotTables Percentages - Grand...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting Excel - Turn on Multiple Filters in a...
Excel - Filter a PivotTable with a Timeline Excel - Filter a PivotTable with a Ti...
PivotTables - 3 Annoying Things FIXED! PivotTables - 3 Annoying Things FIXED!
Excel Add Sparklines on a Separate Worksheet Excel Add Sparklines on a Separate Wo...
Excel Chart Maps used with the Geography Data Type Excel Chart Maps used with the Geogra...
Excel Concatenate Text and Dates with the TEXT function Excel Concatenate Text and Dates with...
Tasks by Planner in Teams - Recurring Tasks - New Feature Tasks by Planner in Teams - Recurring...
Excel - Insert a blank row after every row or every Nth row Excel - Insert a blank row after ever...
#pivottables #chrismenardtraining #msexcel #exceltraining
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Chapters:
0:00 Intro
0:17 Create a PivotTable
1:10 Group text fields
2:20 Rename a group
3:00 Move a group
3:25 Turn off subtotals
3:50 Turn off groups
November 2022 - YouTube videos
---------------
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips Excel PivotTable - Percentage of Row ...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY Excel Tiered Conditional Formatting w...
Teams Online Course Promotion Teams Online Course Promotion
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total Excel PivotTables Percentages - Grand...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting Excel - Turn on Multiple Filters in a...
Excel - Filter a PivotTable with a Timeline Excel - Filter a PivotTable with a Ti...
PivotTables - 3 Annoying Things FIXED! PivotTables - 3 Annoying Things FIXED!
Excel Add Sparklines on a Separate Worksheet Excel Add Sparklines on a Separate Wo...
Excel Chart Maps used with the Geography Data Type Excel Chart Maps used with the Geogra...
Excel Concatenate Text and Dates with the TEXT function Excel Concatenate Text and Dates with...
Tasks by Planner in Teams - Recurring Tasks - New Feature Tasks by Planner in Teams - Recurring...
Excel - Insert a blank row after every row or every Nth row Excel - Insert a blank row after ever...
#pivottables #chrismenardtraining #msexcel #exceltraining
And make sure you subscribe to my channel!
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
2 سال پیش
در تاریخ 1401/09/15 منتشر شده
است.
4,846
بـار بازدید شده