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.
Charts I: How to create a chart.
Pivot Table I: Get started with
PivotTable reports in Excel
PivotTable II: Filter PivotTable
report data in Excel 2007
Pivot Table III: Calculate data
in PivotTable reports in Excel
2007 Practice Session
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.
- Summer '08