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.