Charts and pivot tables

Charts and pivot tables in Excels

1. Charts and Pivot Tables

2. Sorting Data Sorting data reorders the rows in a worksheet based on the content in a particular column. You can choose Sort Ascending or Sort Descending. Sort Ascending will place data in alphabetical order or with the lowest numerical value on top. Sort Descending will place data in reverse alphabetical order (i.e., starting with z) or with the highest numerical value on top. Excel also provides option to sort by cell color, font color, and cell icon.

3. Sorting with Custom Lists Custom Lists is used to sort data based on specifications you provide, such as days of the week or months of the year. Excel provides a number of built-in custom list options.

4. Creating a Chart Charts visually display the data entered in a worksheet. Excel has 11 chart types. The following slide shows the 5 most commonly used charts.

5. Creating a Chart

6. Creating a Chart There are four basic parts to a chart: Plot area Value (Y-axis) Chart area Category (X-axis)

7. Creating a Chart

8. Customizing a Chart Once a chart has been created, a Chart Tools group appears on the User Interface Ribbon. Note : The chart must be selected to use Chart Tools. This group has three tabs that help when customizing a chart: Design, Layout and Format.

9. Pivot Table A Pivot Table is an interactive list that filters, sorts and rearranges data in a specified order. To create a Pivot Table, the used must be in list form. List form is where each piece of data has its own row. Pivot tables allow us to "slice and dice" data any way we want and perform complex calculations. Summarize huge amounts of information. Helps you find hidden trends and relationships.

10. Customizing a Pivot Table Pivot Table Field list: this dialogue box appears after a Pivot Table has been created. Any time this is open, you are able to edit a Pivot Table. It is used to add and remove items from the Pivot Table and contains afield for each of the columns in your data list.

11. Customizing a Pivot Table Once a Pivot Table is created, a Pivot Table Tools group appears on the User Interface Ribbon. This group has two tabs : Options and Design

12. Workbook Sharing The Workbook Sharing function is a setting that allows separate users to edit a workbook at the same time. This function is useful when multiple people are collaborating on a workbook.

13. Comments Comments can be inserted into specific cells. This can be helpful when collaborating on a workbook. When a comment is inserted, a small red triangle appears on the top right corner of the cell to indicate that a comment has been added. Once a comment is inserted, three options are available: Show.Hide Comment Delete Comment Edit Comment

14. Track Changes When multiple people are making changes to a single workbook, it’s help to know who made each changes. Track changes provides a record of changes and assigns a different color to each user contributing to workbook.