$365/2019$ capstone level $3$ working with sales dataExcel $365/2019$ Capstone $-$

Level $3$ Working With

Sales Data

In this project, you will work with sales data from Top't Corn, a popcorn

company with an online store, multiple food trucks, and two retail stores. You

will begin by copying the sales data for one of the retail stores from another

workbook. Next, you will insert a new worksheet and enter sales data for the

four food truck locations, formatting the data, and calculating totals. You will

create a pie chart to represent the total units sold by location and a column

chart to represent sales by popcorn type. You will format the charts, and then set

up the worksheet for printing. Next, you help Top't Corn calculate payments for

a loan and decide whether or not the purchase is a good idea. Working with the

daily sales data for one of the brick$-$and$-$mortar stores, you will apply

conditional formatting to find the top $10$ sales dates. $Y$ ou will also calculate the

sales for each date, and the average, minimum, and maximum sales. You will use

Goal Seek to find the appropriate price to reach a higher daily average sales

goal. You will use VLOOKUP to look up sales data for a specific date. Finally, you

will work with their online sales data to format it as an Excel table and apply

sorting and filtering. You will create a PivotTable and a PivotChart from a copy of

the online sales data to summarize the sales.

Skills needed to complete this project:

Open a workbook

Copy a worksheet to another workbook

Close a workbook

Insert a worksheet

Name a worksheet

Move a worksheet

Enter text

Enter numbers

Edit text

Autofit a column