Pivot Tables & Chart
A very important tool in Advanced Excel is a pivot tables, which allows making a customized summary from a large database.
A chart is the Quick Analysis tool helps viewers to interpret the information a database has.
To aid viewers in interpreting the chart data, configure a chart to include identifying elements such as a title, legend, and data markers.
Charts (also referred to as graphs) are created by plotting data points onto a two dimensional or three-dimensional axis to assist in data analysis.