• • 
•  
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Microsoft Excel 2007

GES 810 -- 35 hours

Course Outline

I. Beginning Guide to Microsoft Excel 2007
a. Make a Rainfall Graph
b. Create a Price Sheet
c. Calculate Revenue

II. Intermediate Guide to Microsoft Excel 2007
a. Mail Merge with Excel
b. Create a Time Sheet
c. Calculate Revenue

III. Advanced Guide to Microsoft Excel 2007
a. Absolute and Relative References
b. Create Filters, Subtotals, Use the Lookup Function
c. Analyze Data with a PivotTable



---