How to Develop PV Table | Chart | Record Macro in Excel (All in One) In-Depth Tutorial | T Square
This tutorial video brings an in-depth learning about how to develop a PV Table, Chart, and Record a Macro (VBA) in Excel. This basic dashboard built in Excel is excellent learning for educational and business users. The content is ideal for beginners to advanced users, who want to acquire the right skills-set to advance in their technical and analytical skills. In addition, the content of this tutorial also provides an excellent financial analysis learning.
The structure of the video are as follow:
Section (I)
How to develop PV Table
How to format PV Table
How to add calculated field in PV Table
Section (II)
How to develop various types of Charts in Excel from PV Table
How to format Chart
How to add Slicer to manage chart
Section (III)
How to Record Macro (VBA) to Refresh PV Table and Chart in Excel