Copy of Pivot Tables 2 and Charts-In class Example

Copy of Pivot - In-Class Example Questions1 Find the total number of hours spent by each staff member for Quarter 3 by month(you must use

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

Unformatted text preview: In-Class Example Questions1. Find the total number of hours spent by each staff member for Quarter 3, by month (you must use grouping).a. Create a PivotTable (Insert – PivotTable)b. Layoutc. Group Date into Months and Quartersd. Change name of fielde. Drag Quarters to Report Filter areaf. Filter by Quarter 3for each project by staff . Create a pivot chart of this report.b. Layoutc. Formati. Change Expenses to Currency Style (0 decimal)i. Highlight data to use in PivotTableii.New Worksheeti.Value = Sum of Hoursii.Column = Staffiii.Row = Datei.Right click on Date fieldii.Choose Groupiii.Start and End date should be ok (start date of data & end date of data)iv.By: Select both Quarters and Monthsi.Select field name in PivotTable and type in new name 1.Change Date to “Months” and “Quarters”2.Change Sum of Hours to “Total Hours”2. Find the total expenses spent in the 4thquarter for the Mid-West region a. Create PivotTable – choose PivotCharti.Report Filter = Regionii.Report Filter = Date iii.Row = Staffiv.Column = Projectv.Value = Sum of ExpensesQuarters...
View Full Document

This note was uploaded on 04/12/2011 for the course FIN 304 taught by Professor Doug during the Spring '11 term at Boise State.

Page1 / 4

Copy of Pivot - In-Class Example Questions1 Find the total number of hours spent by each staff member for Quarter 3 by month(you must use

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online