Analyzing Data Imported fro a Database and Organizing data with a Pivot Table Report.
1. As a start you should download the workfile and follow the following following Video:
2. You should also watch the “working with Pivot Tables in Excel 2013 parts 1, 2, 3 1nd 4. ( each part approximately 15 minutes each.
3. Use the start file attached to this assignment to work through the Level 2 Section of Chaper 2 (pages 461 to 478). This is to get practice with Pivot Tables. You do not have to send me anything.
4. After you are familiar with Pivot tables. then your course project is to Complete the Steps to Success: Level 2 starting on page 479 of your textbook.. Post a copy of your completed pivot table for review and Grading.
5 Write a essay on:
a) How you might use pivot tables to analyze data in real life situations — give specific examples
b) a critique of the course, what you learned overall: what you liked; what you did not like; and how, in your opion Excel can help you in your future courses and professional/personal life.
