ECS 15 Lab #8, Excel Charts and Pivot Tables

After doing each practice session and before

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ur tutorials. After doing each practice session, and before continuing with its tutorial, you should save the Excel spreadsheet, and then close Excel. Note that the “Pivot Table I…” tutorial utilizes the Microsoft Test Drive software for its exercises, and does not create an actual Excel file on your computer. To prove you have done this tutorial, you will need to submit a screenshot of the finished spreadsheet before you “Return to the Course”. To create a screenshot follow these steps: 1. Have the spreadsheet displayed on the screen, and then press the “Print Screen” button. 2. Select Start->All Programs->Accessories->Paint 3. In the Paint program select Edit->Paste. 4. Save the Paint file with the name indicated in the table below. Please save the files with their default names which are listed below. After each tutorial, to get back to the Excel 2007 training page you can either use the down arrow of your browser to get to the Excel 2007 training web page, or click “Return to Training on Microsoft Office Online”, and then select Excel 2007 in the “Office 2007 training courses” area. Notes: For “Charts I…”, Practice 1, Exercise 6, please choose Stacked Line as the final chart type. For “Charts I…”, Practice 2: Exercise 1 use style 43, Exercise 2 use color set “Flow”, and be sure to make a change to the chart for each of the later exercises. Do not do Exercise 8. Tutorial Charts I: How to create a chart. Pivot Table I: Get started with PivotTable reports in Excel 2007 PivotTable II: Filter PivotTable report data in Excel 2007 Pivot Table III: Calculate data in PivotTable reports in Excel 2007 Practice Session Practice 1 P...
View Full Document

This lab report was uploaded on 03/13/2014 for the course CS 15 taught by Professor Staff during the Summer '08 term at UC Davis.

Ask a homework question - tutors are online