Data Analysis with Spreadsheets

  1. Core Statistical and Analytical Functions
    1. Basic Statistical Functions
      1. Sum Functions
        1. SUM Function
          1. SUMPRODUCT Function
            1. Summing Non-Contiguous Ranges
            2. Average Functions
              1. AVERAGE Function
                1. MEDIAN Function
                  1. MODE Functions
                  2. Count Functions
                    1. COUNT Function
                      1. COUNTA Function
                        1. COUNTBLANK Function
                        2. Extreme Value Functions
                          1. MIN Function
                            1. MAX Function
                              1. LARGE Function
                                1. SMALL Function
                              2. Advanced Statistical Functions
                                1. Distribution Functions
                                  1. STDEV Functions
                                    1. VAR Functions
                                      1. SKEW Function
                                        1. KURT Function
                                        2. Percentile Functions
                                          1. PERCENTILE Function
                                            1. QUARTILE Function
                                              1. RANK Functions
                                              2. Correlation and Regression
                                                1. CORREL Function
                                                  1. SLOPE Function
                                                    1. INTERCEPT Function
                                                      1. RSQ Function
                                                    2. Logical Functions
                                                      1. Basic Logical Functions
                                                        1. IF Function Structure
                                                          1. Logical Operators
                                                            1. Boolean Logic Principles
                                                            2. Complex Logical Constructs
                                                              1. Nested IF Statements
                                                                1. IFS Function
                                                                  1. SWITCH Function
                                                                  2. Logical Operators
                                                                    1. AND Function
                                                                      1. OR Function
                                                                        1. NOT Function
                                                                          1. XOR Function
                                                                        2. Conditional Aggregate Functions
                                                                          1. Conditional Sum Functions
                                                                            1. SUMIF Function
                                                                              1. SUMIFS Function
                                                                                1. Multiple Criteria Logic
                                                                                2. Conditional Count Functions
                                                                                  1. COUNTIF Function
                                                                                    1. COUNTIFS Function
                                                                                      1. Criteria Range Specifications
                                                                                      2. Conditional Average Functions
                                                                                        1. AVERAGEIF Function
                                                                                          1. AVERAGEIFS Function
                                                                                            1. Handling Text and Number Criteria
                                                                                          2. Lookup and Reference Functions
                                                                                            1. Vertical Lookup Functions
                                                                                              1. VLOOKUP Function
                                                                                                1. Exact vs Approximate Match
                                                                                                  1. Table Array Structure
                                                                                                    1. Column Index Numbers
                                                                                                    2. Horizontal Lookup Functions
                                                                                                      1. HLOOKUP Function
                                                                                                        1. Row-Based Lookups
                                                                                                        2. Advanced Lookup Functions
                                                                                                          1. INDEX Function
                                                                                                            1. MATCH Function
                                                                                                              1. INDEX-MATCH Combinations
                                                                                                                1. XLOOKUP Function
                                                                                                                  1. FILTER Function
                                                                                                                  2. Reference Functions
                                                                                                                    1. INDIRECT Function
                                                                                                                      1. OFFSET Function
                                                                                                                        1. CHOOSE Function
                                                                                                                          1. ADDRESS Function
                                                                                                                        2. Date and Time Functions
                                                                                                                          1. Current Date and Time
                                                                                                                            1. TODAY Function
                                                                                                                              1. NOW Function
                                                                                                                                1. Automatic vs Static Dates
                                                                                                                                2. Date Component Functions
                                                                                                                                  1. YEAR Function
                                                                                                                                    1. MONTH Function
                                                                                                                                      1. DAY Function
                                                                                                                                        1. WEEKDAY Function
                                                                                                                                          1. WEEKNUM Function
                                                                                                                                          2. Date Calculation Functions
                                                                                                                                            1. DATEDIF Function
                                                                                                                                              1. NETWORKDAYS Function
                                                                                                                                                1. WORKDAY Function
                                                                                                                                                  1. EDATE Function
                                                                                                                                                    1. EOMONTH Function
                                                                                                                                                    2. Time Functions
                                                                                                                                                      1. HOUR Function
                                                                                                                                                        1. MINUTE Function
                                                                                                                                                          1. SECOND Function
                                                                                                                                                            1. TIME Function
                                                                                                                                                              1. TIMEVALUE Function

                                                                                                                                                          Previous

                                                                                                                                                          3. Data Import and Preparation

                                                                                                                                                          Go to top

                                                                                                                                                          Next

                                                                                                                                                          5. Data Organization and Analysis