In this video I will show you how to customize your Pivot Tables with the value fields settings, this offers additional calculations you can do with values, and if that is not enough you can create your own calculated fields and calculated items

In this video I will show you an example on how you can summarize your PivotTables only using Calculated items, this will give full control of customization for your pivot table . If you are not familiar with this type of items, I recommend you watching my video how to create calculated fields and items.

In this video I will show how you can give format to your PivotTable. And how you can re-use that pivot table in other files. For example, if you have a weekly or monthly report this can help you reduce the time you spend formatting your pivottable from scratch.

In this video I will show you how to create a reusable template using two applications: Microsoft Word or Microsoft Excel. We will see the differences between the two applications and you can decide which works best for you.

Do you know that excel offers you an option to create customize functions within a workbook? In this video I will show you how to create customized functions using the function LAMBDA and the name manager.

In this video I will show you how to combine the functions Match and Index, to create a powerful lookup function that can return the value of a cell in a table based on vertical and horizontal criteria.

In this video I will show you how to combine the functions Match and Index, to create a powerful lookup function that can return the value of a cell in a table based on vertical and horizontal criteria.