Scribd
Upload
2 views2 pages

Revenue Data Sorting and Analysis Guide

Uploaded by

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

Revenue Data Sorting and Analysis Guide

Uploaded by

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

1.

Sort data based on Revenues (Largest to Smallest)


2. Add another level to Custom Sort and sort by Revenues (Largest-to-Smallest) and then by Season (Z to A)
3. Change the order and Sort first by Season and the by Revenues
4. Using conditional formatting, highlight duplicate values in the Revenue Column
5. Filter data to show just Spring values
Customer Season Revenue
Contoso Spring 201,438.00
Contoso Winter 183,651.00
Contoso Fall 118,299.00
Contoso Summer 114,452.00
Fabrikam Fall 255,599.00
Fabrikam Summer 183,632.00
Fabrikam Spring 139,170.00
Fabrikam Winter 100,508.00
Northwind Traders Fall 188,851.00
Northwind Traders Winter 174,336.00
Northwind Traders Summer 129,732.00
Northwind Traders Spring 120,666.00
Fabrikam Winter 139,170.00
Fabrikam Spring 100,508.00
Northwind Traders Spring 188,851.00
Northwind Traders Summer 174,336.00
Northwind Traders Winter 129,732.00
Northwind Traders Fall 120,666.00
Fabrikam Winter 100,508.00
Northwind Traders Summer 188,851.00
Northwind Traders Fall 174,336.00
Northwind Traders Winter 174,336.00

You might also like