Excel Project

This week we were able to learn more about Excel and varies functions that can be performed.  Simple functions of Excel are the varies formats for each cell. For example, when you type in 15% the cell automatically formats to percentage. The user can adjust the decimal point and how the percent will be used in the sheet.
As I worked through the project I reinforced the skills of adjusting the column and row width, inserting new columns, and formatting cells to reflect the correct data. A new aspect of Excel that I had been unaware before this lesson/project was the pivot tables. The pivot tables allow a user to compare data, find percentages throughout the data, and summarize by a sum, a count, an average and more.
An example of a pivot table would  be:

Here, my boss would be able to see the selected demographics- by age grouped into decades. Then she would be able to see that the average percent increase was almost ninety-one percent in females ages 20-29.
This can be useful in a business that would want to see average sales, or average time of work per worker, etc.
As you can see, the user can also make the table appealing by adding colors and fonts.