Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
283x Filetype XLSX File size 0.06 MB Source: www.exceldemy.com
Sheet 1: Pivot Table with Slicer_2
| Manufacturer | Data | |||||||||||||||||||
| AMD | Apollo | Baseus | LG | Logitech | MSI | Nvidia | Samsung | Toshiba | Total Sum - Quantity | Total Sum - Unit Price | ||||||||||
| Components | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | Sum - Quantity | Sum - Unit Price | ||
| Cooler | 35 | $45.00 | 35 | $45.00 | ||||||||||||||||
| Cpu | 55 | $340.00 | 55 | $340.00 | ||||||||||||||||
| Gpu | 35 | $450.00 | 35 | $450.00 | ||||||||||||||||
| HDD | 12 | $65.00 | 12 | $65.00 | ||||||||||||||||
| Monitor | 154 | $200.00 | 154 | $200.00 | ||||||||||||||||
| Motherboard | 50 | $200.00 | 50 | $200.00 | ||||||||||||||||
| Mouse | 37 | $85.00 | 37 | $85.00 | ||||||||||||||||
| PSU | 45 | $70.00 | 45 | $70.00 | ||||||||||||||||
| Ram | 95 | $70.00 | 95 | $70.00 | ||||||||||||||||
| SSD | 65 | $150.00 | 65 | $150.00 | ||||||||||||||||
| Usb Hub | 25 | $10.00 | 25 | $10.00 | ||||||||||||||||
| Total Result | 55 | $340.00 | 45 | $70.00 | 25 | $10.00 | 154 | $200.00 | 37 | $85.00 | 50 | $200.00 | 35 | $450.00 | 65 | $150.00 | 142 | $180.00 | 608 | $1,685.00 |
| Sum - Quantity | Manufacturer | |||||||||
| Components | AMD | Apollo | Baseus | LG | Logitech | MSI | Nvidia | Samsung | Toshiba | Total Result |
| Cooler | 35 | 35 | ||||||||
| Cpu | 55 | 55 | ||||||||
| Gpu | 35 | 35 | ||||||||
| HDD | 12 | 12 | ||||||||
| Monitor | 154 | 154 | ||||||||
| Motherboard | 50 | 50 | ||||||||
| Mouse | 37 | 37 | ||||||||
| PSU | 45 | 45 | ||||||||
| Ram | 95 | 95 | ||||||||
| SSD | 65 | 65 | ||||||||
| Usb Hub | 25 | 25 | ||||||||
| Total Result | 55 | 45 | 25 | 154 | 37 | 50 | 35 | 65 | 142 | 608 |
| Prepare MIS Reports in Excel | |||||
| Components | Manufacturer | Country of Manufacture |
Quantity | Unit Price | Total Price |
| Motherboard | MSI | China | 50 | $200.00 | $10,000.00 |
| Cpu | AMD | Vietnam | 55 | $340.00 | $18,700.00 |
| Gpu | Nvidia | Taiwan | 35 | $450.00 | $15,750.00 |
| Monitor | LG | China | 154 | $200.00 | $30,800.00 |
| SSD | Samsung | South Korea | 65 | $150.00 | $9,750.00 |
| HDD | Toshiba | Japan | 12 | $65.00 | $780.00 |
| Cooler | Toshiba | Japan | 35 | $45.00 | $1,575.00 |
| Usb Hub | Baseus | China | 25 | $10.00 | $250.00 |
| Ram | Toshiba | Japan | 95 | $70.00 | $6,650.00 |
| PSU | Apollo | China | 45 | $70.00 | $3,150.00 |
| Mouse | Logitech | China | 37 | $85.00 | $3,145.00 |
no reviews yet
Please Login to review.
