Excel 2016 Analyze Tab Lesson-3

 Excel 2016 Analyze Tab Lesson-3

Analyze Tab:-The Excel Options control the behaviour and appearance of Excel, enabling you to adjust the operation of the spreadsheet package to suit the way you work.

PivotTable Name - The name given to this Pivot Table. It is used when

Options - Button with Drop-Down. The button displays the "PivotTable Options" dialog box, Layout & Format tab. The drop-down contains the commands: Options which display Options dialog box, Show Report Filter Pages, Generate Get Pivot Data.

Active Field - The name of the active field.

Field Settings - Displays the "Value Field Settings" dialog box.

Drill Down:- Drill down is an analytics capability that allows users to instantly shift from an overview of data to a more detailed and granular view within the same dataset they are analyzing by clicking on a metric in a dashboard or report.

Drill Up:-That's what we call “drill down,” as it's a feature allowing you to go much deeper into more particular data or information layers being assessed. On the other hand, drill up allows the user to zoom out the data or information stepwise

Group Selection - Creates a group containing the currently selected items.

Ungroup Selection - (Shift + Alt + Left). Ungroups a range of cells that are currently grouped.

Group Field - Groups numeric or date fields.

Insert Slicer - Button with Drop-Down. Displays the "Insert Slicers" dialog box allowing you to quickly filter data.

Insert Timeline - Allows you to quickly filter your dates and choose specific time periods.

Filter Connections - Manage which filters the pivot table is connected to.

Sort Smallest to Largest - Sorts the current selection so the smallest items are at the top. In this command is accessible from the shortcut menu.

Sort Largest to Smallest - Sorts the current selection so the largest items are at the top. In this command is accessible from the shortcut menu

Sort - Displays the Sort by Value dialog box. In this command is accessible from the shortcut menu.

Refresh - (Alt + F5). Button with Drop-Down. Refresh - update all the information in this workbook that is coming from external data sources. Refresh All (Ctrl + Alt + F5). Refresh Status, Cancel Refresh. Connection Properties.

Change Data Source - Button with Drop-Down. The button displays the Change PivotTable Data Source lets you change the source data for this PivotTable. The drop-down also contains the Connection Properties command.

Clear - Drop-Down. The drop-down contains the commands: Clear All, Clear Filters.

Select - Drop-Down. The drop-down contains the commands: Labels and Values, Labels, Values, Entire PivotTable, Enable Selection.

Move Pivot Table - Displays the "Move PivotTable" dialog box.

Fields, Items & Sets - Drop-Down. The drop-down contains the commands: Calculated Field, Calculated Item, Solve Order, List Formulas, Create Set Based on Row Items, Create Set Based on Column Items and Manage Sets.

OLAP Tools - Drop-Down. (Tools group in 2010).

Relationships - Displays the "Manage Relationships" dialog box.

Summarize Values By - Drop-Down. The drop-down contains the commands: Sum, Count, Average, Max, Min, Product and More Options. In this command appeared before the Fields, Items & Sets drop-down.

Show Values As - Drop-Down. The drop-down contains the commands: Show Values As - No Calculation, of Grand Total, of Column Total, of Row Total, Of, of Parent Row Total, of Parent Column Total, of Parent Total, Difference From, Difference From, Running Total In, Running Total In, Rank Smallest to Largest, Rank Largest to Smallest, Index, More Options. In Excel 2010 this command appeared before the Fields, Items & Sets drop-down.

Pivot Chart - Creates a Pivot Chart based on the data in this pivot table.

Recommended Pivot Tables - Displays the "Recommended Pivot Tables" dialog box.

What-If Analysis- Drop-Down. The drop-down contains the commands: Scenario Manager, Goal Seek and Data Table. This drop-down also appears on the Data Tab, Forecast group.

Formulas - Drop-Down. The drop-down contains the commands: Calculated Field, Calculated Item, Solve Order, List Formulas.

Field List - Toggles the display of the PivotTable Field List task pane.

Buttons - Toggles the display of the expand and collapse buttons on the pivot table.

Field Headers - Toggles the display of the field headings for rows and columns.