Each record on the table represents a day of total sales for each product and the data covers the last five years . Your boss asks you to create a visual report of the sales performance of each product during the last 12 months .
Prepare a step-by-step description of how you would use Microsoft Excel to prepare the report and email it to your boss following these steps :
Step 1 – Import data from Access to Excel Step 2 – Summarize Monthly Data for each product during the last 12 months Step 3 – Create a visual representation of monthly data Step 4 – Email the spreadsheet with your comments to your boss ( Points : 40 )
( TCO 9 ) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors . The data is currently in a text file and has over two thousand records of data . Explain how you would use Excel to analyze this data and organize it to prepare a written report . Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations .