M6 A.2 Practice and Prove: Profit Ratios (Excel)

Before we start looking at manipulating our data in Tableau, let’s practice how this would be done in Excel. Please time how long it takes you to complete this exercise, so we have a point of comparison. Here's what you need to do:

Step 1: Open the Sample - Superstore dataset in Excel

• The same data we have used in earlier exercises.

Step 2: Perform the necessary Excel manipulations

• As needed to answer the questions below, referencing the previous Shadow Me video. Note how much time it takes to do the Excel work.

Step 3: Answer the questions below based on your Excel work