Best+Buy+Black+Friday+Analysis

‍‍ ,-added by esom1‍

‍ As an analysis for Best Buy situated in New York City, my responsibility was to determine the total amount of sales per unit sold as well as, the total profit obtained during this one day only event. Also, I had to determine the top five highest sales and the top five highest cost purchases for the store. In order to obtain all this information,I used many tools such as the conditional formatting, format as table, cell style, logical functions, sort & filter, pivot charts and other formatting options. The cells highlighted in green identify the five top total sales, and in red identify the top five most expensive units for the store. One of the benefits of using the pivot table is that it allows us to recognize the total amount of sales from a specific utility such as a washer, a microwave, and so on. All the items are based on actual items found at Best Buy, yet the prices are slightly different from the ones at the store.