A table named “Daily Sales” in a Microsoft Access database has the following fields:
Product A
Product B
Product C
Product D
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
0 comments