FREE FILE TO DOWNLOAD: https://jopaexcel.com/pivottablechartdatasetg7v3rdxj5xe

In this Excel video tutorial, we will learn how to make a pivot table in Excel and also how to make a pivot chart, both tools are very important on daily baisis to help us make analyzes with Excel and also to create a dashboard, that is a visual way to analyze data.

So if you need to learn how to make a pivot table in Excel or how to make pivot charts in Excel from scratch step by step for beginners, this free Excel tutorial can help you a lot.

The first thing we need to have to do any type of analysis in Excel is a dataset and from our dataset we can create a table in Excel and then from the table we can create pivot tables and dynamic charts.

You do not necessarily need to use a table in Excel, but the table has many benefits, for example, whenever you add new information to your dataset, this new information will already be included within the range of use of the pivot table and pivot chart. This way it is much easier to keep the pivot charts and pivot tables up to date.

#JopaExcel #Dashboard #Excel