Calvin C Channel
TBA
Use "Alt" + "=" key to sum up numbers in columns and/or rows!
Turn off / on the auto fit function of your Pivot Table
Part 19 Disable or enable autofit function In the last video of this series, you will learn how to disable or enable autofit function in Pivot Table. Please refer to my Pivot Table video series for co...
There is always a better way to present your data - let's learn how to present empty cells in Pivot Table.
Part 18 How to present empty cells in pivot table In this video you will learn how to present empty cells in Pivot Table. Please refer to my Pivot Table video series for complete walkthrough on how to create...
How and when to use recommended pivot table?
Part 17 Using recommended pivot table In this video you will learn how to use and when to use recommended Pivot Table. Please refer to my Pivot Table video series for complete walkthrough on how ...
What if you can use Timeline to present/filter your Pivot Table and Chart? It will be amazing!!
Part 16 Insert and use a timeline In this video you will learn how to insert and use Timeline in your Pivot Table. Please refer to my Pivot Table video series for complete walkthrough on how ...
If you loves visual filter, you'll definitely relate to slicer. Watch on!
Part 15 Insert and use a slicer In this video you will learn how to insert and use Slicer in your Pivot Table. Please refer to my Pivot Table video series for complete walkthrough on how to...
Chart speaks louder than table? Let's find out - https://youtu.be/esB9Rl-PpNU
Part 13 Create a Pivot Chart In this video you will learn how to create a Pivot Chart using Pivot Table. Please refer to my Pivot Table video series for complete walkthrough on how to cr...
How to show details of a value in Pivot Table? Tune in at 1pm later.
Part 12 Show details of a particular value When your audience or yourself is interested to know the details of certain value, how do you show them or yourself - watch on. Visit https://www.facebook.co...
Tired of boring excel table? Let's learn how to format your excel table to wow your audience!
Part 11 Formatting a Pivot Table Let's learn how to format a Pivot Table:1. How to use Report tools in PivotTable2. How to remove or include subtotals3. How to show / hide buttons for group...
If you dream of auto update or even automate your pivot table, stay tune for this video premiering tonight at 830pm!
Part 10 Updating a Pivot Table How to auto update or even automate your Pivot Table?
How about a sleek analysis or presentation by grouping items in Pivot Table? Watch it premiering at 7pm tonight!
Part 9 Group Pivot Table Items How to group pivot table items for a better story telling?
Plenty of exciting layouts to beautify your pivot table! - Watch it at 1pm tomorrow.
Part 8 Pivot Table Layout How to tailor your pivot table layout
Let's learn how to sort a pivot table and include multiple filters :) https://youtu.be/7npktiHH0jw
Part 7 Sorting A Pivot Table and Multiple Filter How to sort a Pivot Table and having multiple filters
How to save your workbook?