Excel data analysis
Create a workbook named Lastname_firstname_pivottable.xls.
Excel data analysis
Create a workbook named Lastname_firstname_pivottable.xls. It must contain at least 100 records with at least 5 columns of your choosing (can be random information).
Based on the worksheet you have just completed, create 1 pivot table and 1 pivot chart in Excel to answer 2 business questions similar to below.
What type of customers or region generated the highest revenue?
What’s the average total quantity sold/purchase?
Leave a Reply