Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2019-07-23 13:30:01 | ![]() 64,615 Views |
Excel Pivot Table Design Tricks: Learn how to customize your PivotTable with these advanced design tools in Excel.
Complete Word, Excel and PowerPoint Foundation Courses Combo:
https://shop.presentation-process.com/p/complete-foundation-course-for-word-excel-and-powerpoint
Free Excel Mini Course: https://www.presentation-process.com/mini-course-top-10-excel-tips-to-save-time.html
What is covered in this Excel tutorial:
==============
00:00 How to Add PivotTable
00:40. How to use Report Tools in PivotTable
01:11 Show in Tabular Format
01:47 How to remove Subtotals
02:13 How to Remove Collapse/Expand Buttons
02:48 View/ Hide Field List Pane
03:09 Create alternate banded rows to make information easy to read
03:35 How to apply different PivotTable Styles
04:36 Add Blank rows after each Category Item
Complete Word, Excel and PowerPoint Foundation Courses Combo:
https://shop.presentation-process.com/p/complete-foundation-course-for-word-excel-and-powerpoint
Free Excel Mini Course: https://www.presentation-process.com/mini-course-top-10-excel-tips-to-save-time.html
What is covered in this Excel tutorial:
==============
00:00 How to Add PivotTable
00:40. How to use Report Tools in PivotTable
01:11 Show in Tabular Format
01:47 How to remove Subtotals
02:13 How to Remove Collapse/Expand Buttons
02:48 View/ Hide Field List Pane
03:09 Create alternate banded rows to make information easy to read
03:35 How to apply different PivotTable Styles
04:36 Add Blank rows after each Category Item
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.