Data Analysis with Spreadsheets

  1. Advanced Analysis Techniques
    1. Array Formulas
      1. Array Formula Concepts
        1. Single-Cell Arrays
          1. Multi-Cell Arrays
            1. Array Constants
            2. Array Formula Entry
              1. Ctrl+Shift+Enter Method
                1. Dynamic Array Functions
                2. Array Formula Applications
                  1. Complex Calculations
                    1. Multiple Criteria Analysis
                      1. Matrix Operations
                    2. Dynamic Arrays
                      1. Dynamic Array Functions
                        1. FILTER Function
                          1. SORT Function
                            1. UNIQUE Function
                              1. SEQUENCE Function
                                1. RANDARRAY Function
                                2. Spill Ranges
                                  1. Automatic Spill Behavior
                                    1. Spill Range References
                                      1. Spill Error Handling
                                    2. Power Query Integration
                                      1. Power Query Basics
                                        1. Data Connection Creation
                                          1. Query Editor Interface
                                            1. Data Transformation Steps
                                            2. Data Transformation Operations
                                              1. Column Operations
                                                1. Row Filtering
                                                  1. Data Type Changes
                                                    1. Merge and Append Operations
                                                    2. Advanced Power Query
                                                      1. Custom Columns
                                                        1. Grouping Operations
                                                          1. Pivot and Unpivot
                                                            1. M Language Basics
                                                          2. Statistical Analysis Tools
                                                            1. Descriptive Statistics
                                                              1. Summary Statistics
                                                                1. Frequency Distributions
                                                                  1. Percentile Analysis
                                                                  2. Hypothesis Testing
                                                                    1. T-Tests
                                                                      1. Chi-Square Tests
                                                                        1. ANOVA Analysis
                                                                        2. Regression Analysis
                                                                          1. Linear Regression
                                                                            1. Multiple Regression
                                                                              1. Regression Diagnostics

                                                                          Previous

                                                                          8. What-If Analysis and Scenario Planning

                                                                          Go to top

                                                                          Next

                                                                          10. Best Practices and Workflow Management