Exp-13 : Create dynamic charts, filters, sorts, pivot tables in ms excel for COPA Trade
I have learned how to create charts, applying filters, sorts, and pivot tables in ms excel
Create a chart
Select data for the chart.
Select Insert > Recommended Charts.
Select a chart on the Recommended Charts tab, to preview the chart.
Select Chart
OK
- Select any cell within the range.
- Select Data > Filter.
- Select the column header arrow .
- Select Text Filters or Number Filters, and then select a comparison, like Between.
- Enter the filter criteria and select OK.
Sort text
Select a cell in the column you want to sort.
On the Data tab, in the Sort & Filter group, do one of the following:
To quick sort in ascending order, click
(Sort A to Z).To quick sort in descending order, click
(Sort Z to A).
Create a PivotTable in Excel for Windows
Select the cells you want to create a PivotTable from.
Note: Your data should be organized in columns with a single header row.
Select Insert > PivotTable.
This will create a PivotTable based on an existing table or range.
Note: Selecting Add this data to the Data Model will add the table or range being used for this PivotTable into the workbook’s Data Model. Learn more.
Choose where you want the PivotTable report to be placed. Select New Worksheet to place the PivotTable in a new worksheet or Existing Worksheet and select where you want the new PivotTable to appear.
Click OK
