Reflective Essay: Excel Part 2

This week is the continue from last week, where it shows that Excel as a database.

For this week, we learn in how to calculate food cost using this software whereby template can be prepared earlier, then we just need to fill the template.
Unintentionally, the recipe with the amount is prepared for one portion.

In this template, information such as the name, picture and else could be insert.
For the cost, people could just fill the formula for which cell that they want accordingly.

The outcome of the learning today is as below.

thank you.

Reflective Essay: Excel

Excel is part of data where can be used for database. 

So today we had learn briefly about how to use this software where we definitely learn how to group the data and turn it into chart where it made the data easier to be read.

This knowledge is definitely necessary for all of us especially for food service establishment. 

So these are the following task. 

Spreadsheets: Individual exercise

Sarah runs a travel agency called Gulf Coast Destinations. Customers can choose from four different travel locations. Sarah takes trip reservations by mail, phone, online, and by appointment in her office. Sarah tracks her annual sales to help her make business decisions.

1.     Make a spreadsheet that looks like the one below:

Gulf Coast Destinations Annual Sales 2011
Location	Mail	Phone	Online	Appointment
New Orleans, Louisiana	65	122	388	400
Pensacola, Florida	133	488	500	822
Key West, Florida	355	966	1599	1422
Corpus Christi, Texas	144	299	488	577

2.     Calculate the total annual sales Sarah made by mail, phone, online, and by appointment. 

3.     Format the data to have currency figures

4.     Save the spreadsheet on your flash drive or to the Desktop.  Name it Annual Sales 2011.

5.     Find total sales in every destination and make it as pie chart. Give title to the chart as Sales by location.

6.     Make a bar chart that looks comparing the amount of money Sarah made in each category of reservation. Give title as Sales by Category. Don’t use a legend since there is only one color representing this data.

7.     Change the number of decimal places of the currency in the chart to 0. This will make the Axis labels easier to read.

8.     Next, make a column chart of the amount of money Sarah made for each location in each reservation category. This shows her most popular locations, and the most popular way to make reservations.

9.   Change the title to Sales Comparison: Location and Category

10. Change Chart Styles group with a black background and save it.

The outcome of the task. 

Excel : Annual Sales 2014