Excel Project

Steps 1-4: Use this Class/Section and the date in the format shown below:

Steps 4-7: Follow instructions in the project.

Step 8: First two rows of table after it is sorted:

Step 9: Copy and Paste table to Slide 2 and Slide 3 tabs.

Copy and “Paste | Values“ for Filter Analysis tab. Re-format as directed in Steps 6 & 7.

Step 10: Follow the instructions. Check to make sure:

The Pivot Table is placed two rows (Row 36) below the table, beginning in Column A. The next Pivot Table should begin around Row 45.

The Column Titles are the Four Quarters.

The Row Titles are the CarClass and the Location, respectively.

Check all titles (Excel Table and Pivot Tables) to make sure ALL labels can be read and are not chopped off. Be sure to check all words in the Pivot Table.

Each table will have these check figures as the Grand Total:

Step 11: Follow the instructions. Check to make sure:

The Chart is placed two columns to the right of the Excel Table, around Column “I” and beginning in Row 1.

There are 16 bars in this chart, with each group of 4 bars representing each of the four Car Classes.

The next Chart is placed two rows below the first chart, beginning around cell I-17.

There are eight bars in this chart, four representing Airport and four, Downtown.

Both charts should be colored the same and the same size.

Add titles to each of the charts. Something simple like: Car Rentals by CarClass 2015

Step 12: Follow the instructions. Check the information presented in Step 10 (above).

The first Pivot Table will begin around cell: A36

The second Pivot Table will begin around cell: A45

Each table will have these check figures as the Grand Total:

Step 13: Follow the instructions. Check the information presented in Step 11 (above).

The first Chart will begin around cell: I11 (“I”-eleven)

The second Chart will begin around cell: I17 (“I”-seventeen)

ALL charts (in Slide 2 and Slide 3) must be colored the same and the same size.

Step 14: Follow instructions.

Step 15: From within the Filter, select Quarter 1 (only) and Hybrid (only)

You must use the =SUM( ) formula to write your formula for each.

Use the following for your check figures:

PowerPoint Presentation Portion of the Project

Four slides with limited words on each slide. Speaker notes required for Slides 2, 3, & 4. Read the instructions on what goes on each. (Yours does not have to look like mine, select your own theme.)

Slide 1: Your title that reflects something about the presentation. Do not include the name of the class or the title of this project. Your full name, the class and section, and the date formatted as shown below go in the sub-title.

Slide 2: The title is given to you. You insert the graphs. They should be the same size. You then write notes (to yourself) about what you will say when you talk to your audience. There must be complete sentences in your notes.

Slide 3: The title is given to you. You insert the graphs. You write the speaker notes in complete sentences about what you would be saying about the graphs in the notes.

Slide 4: The title is given to you. You have two major bullets and only 1-4 sub-bullets. Limit the words on the bullets. It is in the speaker notes where you tell the audience what you found out and what you are recommending. Visit for ideas: http://www.garrreynolds.com/preso-tips/design/