Channel :
youtube.com/channel/UCmgPweWplKQSVXDeguAJP0Q
Download:
drive.google.com/file/d/1wa8443btI2LrJKNz03i7oSOHoXQrouRd/view?usp=sharing
How to Work with Pivot Table - Excel Expert Hat Video no. 004
1) Basics of Pivot Table
2) Slicer
3) Table Formating
Time Laps:
1) 0:25 : Start Making Data Table
2) 0:57 : Making Pivot Table
3) 3:17 : Filter Pivot Table
4) 4:32 : Setting Up Data For Pivot Table
5) 5:17 : Setting Up Pivot Table
6) 6:37 : Formatting Individual Column in Pivot Table
7) 8:12 : How ON/OFF Expand Collapse Button in Pivot Table
8) 8:51 : How to set up Slicer in Excel
9) 10:46 : Pivot Table Options
10) 10:56 : Repeat All Item Labels
11) 11:49 : How to Merge and Center cells with Same Labels
12) 12:47 : How to fix Column width in Pivot Table
13) 13:19 : Pivot Table Formatting
14) 13:52 : Show and hide Grand Total Row in Pivot Table
Hello Friends,
We have explained Excel tricks and tactics in detail in each video.
Please do visit our channel and given links below.
See Our All Videos: youtube.com/playlist?list=PLLDgWfTcbEqwZpiYkTcPDootHATU7_iH1
Our Short Video: youtube.com/playlist?list=PLLDgWfTcbEqy8tDiOjNRjr9Q_Vle7k61p
Visit Our Channel: youtube.com/channel/UCrSs6nt15x-1NSIsVssZUXg
Our Long Videos:
1) Using Slicers in Excel to Filter Data
youtu.be/w3pRSkLmYh4
2) Excel Gantt Chart with Pivot Table
youtu.be/BeFlFovYpcU
3) Progress Bar in Excel Cells & Conditional Formatting
youtu.be/liwDRTesuiE
4) Excel Workday function: Find end date & exclude weekends & holidays
youtu.be/eCHUjsAKeSs
5) Project Plan in Excel with Gantt Chart (Plan, Actual & Progress, Work Priority)
youtu.be/N46pParHBZM
6) Remove author from the file properties – Excel
youtu.be/fqfDai3P_MI
7) Excel Pivot Tables EXPLAINED in 15 Minutes (Productivity, Slicer tips included!)
youtu.be/0siJqnZvr40
8) How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMXMY2, SUMX2PY2, SUMX2MY2, SUMPRODUCT Formula in Excel
youtu.be/MZrL1PoSCtQ
Our Short Video:
1) Your Tab in Excel...Very Simple
youtu.be/tJMETTUCLPA
2) How to Show Excel Formulas in Cells with FORMULATEXT Function
youtu.be/H56sIzAjJpA
3) Unit Converter in Excel
youtu.be/9vn1ep4j_-o
4) How to find Duplicated in List – Excel
youtu.be/t9Z8POfCgIY
- Excel Pivot Tables EXPLAINED in 15 Minutes (Productivity, Slicer tips included!) (V001) ( Download)
- Excel - 5 Pivot Table Productivity Tricks You NEED To Know! ( Download)
- MS Excel - Pivot Table in Just 15 Mins ( Download)
- Progress Bar in Excel Cells & Conditional Formatting (V005) ( Download)
- From scratch to dashboard in 15 minutes ( Download)
- How to create pivot table in MS Excel । এমএস এক্সেলে পিভট টেবিল কীভাবে তৈরি করবেন ( Download)
