Assignments for Feb. 5

Reading: From Near and Far, St. Petersburg Times.

Excel: Pivot Table and Functions Exercise. You can skip the references to VLOOKUP and use this data file for the first section and this data file for the second.

Excel: Import this fixed width text file into a spreadsheet. Then do a pivot table to count the number of employees *and* the average years of service for each job position. That’s two different calculations on the same pivot table.

Send me all three Excel files when done and be prepared to discuss the story in class.


About this entry