Scribd
Upload
2 views1 page

Pivot Table Practice Task BN

The document outlines various tasks for practicing Excel Pivot Tables, including region-wise sales analysis, product quantity analysis, salesperson performance, monthly sales reporting, and category vs region comparisons. It also includes challenge questions related to revenue, sales performance, and average sales calculations. Additionally, there is a mention of interview questions focusing on Pivot Tables and functions like SUMIFS and COUNTIFS.

Uploaded by

adhikarysourav458
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Pivot Table Practice Task BN

The document outlines various tasks for practicing Excel Pivot Tables, including region-wise sales analysis, product quantity analysis, salesperson performance, monthly sales reporting, and category vs region comparisons. It also includes challenge questions related to revenue, sales performance, and average sales calculations. Additionally, there is a mention of interview questions focusing on Pivot Tables and functions like SUMIFS and COUNTIFS.

Uploaded by

adhikarysourav458
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel Pivot Table Practice Task ( )

Raw Data Columns


Date | Salesperson | Region | Product | Category | Quantity | Unit Price | Total
Sales

1: Region-wise Sales
Pivot Table Region Total Sales Highest selling region
. Setup: Rows=Region, Values=Sum of Total Sales

2: Product-wise Quantity Analysis


Product Quantity sold . Setup: Rows=Product,
Values=Sum of Quantity

3: Salesperson Performance
sales Top performer . Setup: Rows=Salesperson,
Values=Sum of Total Sales

4: Monthly Sales Report


Date field group sales . Hint: Right click Date > Group
> Months

5: Category vs Region Comparison


Rows=Category, Columns=Region, Values=Sum of Total Sales

6: Advanced Dashboard
Slicer for Region, Product Timeline for Date

Challenge Questions
1) Highest revenue product? 2) Best salesperson in East region? 3) Q1 sales? 4)
Average sales per order?

Interview Question
Pivot Table SUMIFS/COUNTIFS-

You might also like