What is a Pivot Table in Excel?
A pivot table in Excel is a great tool. You can build a report to follow your activity without writing a single formula. Let's see how?
Pivot Table
Split report to many sub-reports automatically
You can split your report to many sub-reports automatically with a pivot table options. When you use the filter, you can spilt your report 😉
Add filter option for all your pivot table columns
How to add the filter option for all your Pivot Table columns? This article explains the trick and the technique
How to do Percentage in a Pivot Table in Excel?
How to calculate easily the percentage in a pivot table. No formula are needed. Just change the calculation mode of your field
Add a slicer with Excel Online
How to add a slicer for your pivot table with Excel Online? There is two techniques, exactly like with Excel desktop
How to use AI with Excel for Analysing your data?
How AI can helps you to analyse your data and create complex dashboard in no time with Excel? In Excel 365, there is an option just for that.
How AI can be used in Excel for your data?
Discover how AI tools can automate tasks, identify trends, and make predictions to enhance your Excel experience