excel project 3

Excel Portion of the Project

Steps 1-4: Use this Class/Section – date format – columns popped open:

Steps 5-6: Follow instructions. Change “Revenue” to Currency and “NumCars” to Number. Use thousandth’s separator.

Steps 7-8: First three rows of table after it is sorted. Make sure titles are not chopped off.

Step 9a-b: Copy the data only to Slide 2 & 3. For Filter Analysis, use Paste | Values. There are no banded rows. Step 9(d): Reformat the table to the same style as the Data table formatting. Adjust column widths so no titles are chopped off.

Step 10: Both pivot tables have the same Grand Total: One Pivot Table is for “CarClass”. The second Pivot Table is for “Location”. Make sure titles are not chopped off.

Step 11: Follow the instructions. All charts must be formatted with the same colors. The first chart will be grouped by “CarClass”. The second chart will be grouped by “Location”.

Step 12: Both pivot tables have the same Grand Total: One Pivot “CarClass”. The second Pivot table is for “Location”. Make sure titles are not chopped off.

Step 13: Follow the instructions. All charts must be formatted with the colors in Step 11. One chart is grouped by “CarClass”. The second chart is grouped by “Location”.

Step 14: If the table is formatted like the other tables, that is OK. If the table is not formatted like the other tables, make sure Revenue is Currency and NumCars is Number with thousandth’s separator. Neither of these two columns have decimal places.

Turn on the filters.

Step 15a: Uncheck and then re-check only the titles indicated. in the. Leave the filter on. You have three rows showing.

Step 15b: In Row 34, use a simple formula to calculate the two totals. Do not turn the filters off. There should only be four rows visible in the work sheet. Here are your check figures:

PowerPoint Portion of the Project

Step 16-17: Slide 1: The title of the presentation. Use some title other than Excel Project #3. Do not use identifiers from Step 17d, but only the information as shown below.

The theme is your choice.

Step 18: Slide 2: Follow instructions. Use the Speaker Notes section to “talk” to the audience about what you want to say about this slide. Be sure to introduce yourself.

Speaker Notes

Step 19: Slide 3: Follow instructions. Your Speaker Notes are what you “say” to the audience about what is presented in the charts. Do not type what you say onto the slide!

Speaker Notes

Steps 20-21: Slide 4: Follow the instructions.

Speaker Notes

Step 22: Follow the instructions. There should be no footer nor Slide # on the Title Slide. The first slide with a Slide Number and a footer is Slide #2, and the number should be a “2”.

Step 23: Add a transition to all slides. Mix it up. Don’t add the same transition to every slide.

Step 24: Animate some words or the graphic. Do not add an animation to every slide as that detracts from the presentation.