Data Analysis with Spreadsheets

  1. Pivot Table Analysis
    1. Pivot Table Fundamentals
      1. Pivot Table Concepts
        1. Data Summarization Principles
          1. Dimensional Analysis
            1. Cross-Tabulation Concepts
            2. Creating Pivot Tables
              1. Data Source Selection
                1. Pivot Table Wizard
                2. Pivot Table Interface
                  1. PivotTable Fields Pane
                    1. Field List Management
                      1. Drag and Drop Operations
                    2. Pivot Table Structure
                      1. Field Areas
                        1. Filters Area
                          1. Columns Area
                            1. Rows Area
                              1. Values Area
                              2. Field Configuration
                                1. Adding Fields to Areas
                                  1. Removing Fields
                                    1. Rearranging Field Order
                                      1. Field Settings
                                    2. Data Summarization in Pivot Tables
                                      1. Summary Functions
                                        1. Sum Calculations
                                          1. Count Calculations
                                            1. Average Calculations
                                              1. Min and Max Values
                                                1. Standard Deviation
                                                  1. Variance
                                                  2. Value Field Settings
                                                    1. Changing Summary Functions
                                                      1. Number Formatting
                                                        1. Show Values As Options
                                                        2. Calculated Fields
                                                          1. Creating Calculated Fields
                                                            1. Calculated Field Formulas
                                                              1. Calculated Items
                                                            2. Pivot Table Grouping
                                                              1. Date Grouping
                                                                1. Grouping by Years
                                                                  1. Grouping by Quarters
                                                                    1. Grouping by Months
                                                                      1. Grouping by Days
                                                                        1. Custom Date Grouping
                                                                        2. Numeric Grouping
                                                                          1. Automatic Grouping
                                                                            1. Custom Numeric Ranges
                                                                              1. Group Interval Settings
                                                                              2. Text Grouping
                                                                                1. Manual Text Grouping
                                                                                  1. Custom Group Names
                                                                                2. Advanced Pivot Table Features
                                                                                  1. Pivot Table Formatting
                                                                                    1. Report Layout Options
                                                                                      1. Subtotal Display
                                                                                        1. Grand Total Settings
                                                                                          1. Empty Cell Display
                                                                                          2. Interactive Elements
                                                                                            1. Slicers for Filtering
                                                                                              1. Timeline Controls
                                                                                                1. Report Connections
                                                                                                2. Pivot Charts
                                                                                                  1. Creating Pivot Charts
                                                                                                    1. Chart Type Selection
                                                                                                      1. Dynamic Chart Updates
                                                                                                        1. Pivot Chart Formatting
                                                                                                      2. Pivot Table Refresh and Updates
                                                                                                        1. Data Source Changes
                                                                                                          1. Refreshing Pivot Tables
                                                                                                            1. Changing Data Sources
                                                                                                              1. Expanding Data Ranges
                                                                                                              2. Pivot Table Options
                                                                                                                1. Refresh Settings
                                                                                                                  1. Data Retention Options
                                                                                                                    1. Error Value Handling

                                                                                                                Previous

                                                                                                                5. Data Organization and Analysis

                                                                                                                Go to top

                                                                                                                Next

                                                                                                                7. Data Visualization and Chart Creation