Data Analysis with Spreadsheets

  1. Data Organization and Analysis
    1. Data Sorting Techniques
      1. Single-Column Sorting
        1. Ascending Sort
          1. Descending Sort
            1. Custom Sort Orders
            2. Multi-Level Sorting
              1. Primary Sort Keys
                1. Secondary Sort Keys
                  1. Tertiary Sort Keys
                  2. Advanced Sorting Options
                    1. Sorting by Cell Color
                      1. Sorting by Font Color
                        1. Sorting by Icon Sets
                          1. Case-Sensitive Sorting
                        2. Data Filtering Methods
                          1. AutoFilter Implementation
                            1. Enabling AutoFilter
                              1. Filter Drop-Down Menus
                                1. Multiple Filter Criteria
                                2. Custom Filtering
                                  1. Number Filters
                                    1. Text Filters
                                      1. Date Filters
                                        1. Top 10 Filters
                                        2. Advanced Filter Techniques
                                          1. Criteria Range Setup
                                            1. Complex Criteria Logic
                                              1. Copying Filtered Results
                                                1. Unique Records Only
                                              2. Structured Data with Tables
                                                1. Table Creation and Management
                                                  1. Converting Ranges to Tables
                                                    1. Table Design Options
                                                      1. Table Style Formatting
                                                      2. Table Functionality
                                                        1. Structured References
                                                          1. Automatic Formula Extension
                                                            1. Total Row Features
                                                              1. Table Expansion
                                                              2. Table Analysis Features
                                                                1. Slicer Integration
                                                                  1. Table Relationships
                                                                    1. Data Model Integration
                                                                  2. Data Grouping and Outlining
                                                                    1. Manual Grouping
                                                                      1. Row Grouping
                                                                        1. Column Grouping
                                                                          1. Nested Groups
                                                                            1. Group Expansion and Collapse
                                                                            2. Automatic Outlining
                                                                              1. Auto Outline Creation
                                                                                1. Outline Level Management
                                                                                  1. Summary Row Recognition
                                                                                  2. Subtotal Functions
                                                                                    1. SUBTOTAL Function
                                                                                      1. Aggregate Functions with Filtering
                                                                                        1. Multiple Subtotal Levels

                                                                                    Previous

                                                                                    4. Core Statistical and Analytical Functions

                                                                                    Go to top

                                                                                    Next

                                                                                    6. Pivot Table Analysis