Data Analysis with Spreadsheets

  1. Data Import and Preparation
    1. Data Import Methods
      1. Importing from Text Files
        1. CSV File Import
          1. Tab-Delimited Files
            1. Fixed-Width Text Files
              1. Import Wizard Navigation
                1. Delimiter Selection
                  1. Text Qualifier Handling
                  2. Importing from Web Sources
                    1. Web Query Creation
                      1. HTML Table Import
                        1. Refreshable Web Connections
                          1. Authentication for Web Data
                          2. Database Connections
                            1. ODBC Connections
                              1. SQL Query Import
                                1. Database Table Import
                                  1. Connection Management
                                  2. Other Import Sources
                                    1. XML Data Import
                                      1. JSON Data Handling
                                        1. API Data Connections
                                          1. Cloud Service Integration
                                        2. Data Quality Assessment
                                          1. Identifying Data Issues
                                            1. Missing Value Detection
                                              1. Duplicate Record Identification
                                                1. Data Type Inconsistencies
                                                  1. Outlier Detection
                                                    1. Format Inconsistencies
                                                    2. Data Profiling Techniques
                                                      1. Data Distribution Analysis
                                                        1. Completeness Assessment
                                                          1. Uniqueness Validation
                                                            1. Pattern Recognition
                                                          2. Data Cleaning Operations
                                                            1. Duplicate Data Management
                                                              1. Finding Duplicate Records
                                                                1. Removing Duplicate Entries
                                                                  1. Conditional Duplicate Removal
                                                                    1. Duplicate Prevention Strategies
                                                                    2. Missing Data Handling
                                                                      1. Identifying Blank Cells
                                                                        1. Filling Missing Values
                                                                          1. Interpolation Techniques
                                                                            1. Missing Data Indicators
                                                                            2. Text Data Cleaning
                                                                              1. Removing Extra Spaces
                                                                                1. Standardizing Case
                                                                                  1. Removing Non-Printable Characters
                                                                                    1. Correcting Common Typos
                                                                                      1. Standardizing Text Entries
                                                                                    2. Text Manipulation Functions
                                                                                      1. Text Cleaning Functions
                                                                                        1. TRIM Function
                                                                                          1. CLEAN Function
                                                                                            1. SUBSTITUTE Function
                                                                                              1. REPLACE Function
                                                                                              2. Case Conversion Functions
                                                                                                1. UPPER Function
                                                                                                  1. LOWER Function
                                                                                                    1. PROPER Function
                                                                                                    2. Text Combination Functions
                                                                                                      1. CONCATENATE Function
                                                                                                        1. CONCAT Function
                                                                                                          1. TEXTJOIN Function
                                                                                                            1. Ampersand Operator
                                                                                                            2. Text Extraction Functions
                                                                                                              1. LEFT Function
                                                                                                                1. RIGHT Function
                                                                                                                  1. MID Function
                                                                                                                    1. LEN Function
                                                                                                                    2. Text Search Functions
                                                                                                                      1. FIND Function
                                                                                                                        1. SEARCH Function
                                                                                                                          1. Position-Based Extraction
                                                                                                                        2. Data Transformation Tools
                                                                                                                          1. Text to Columns Feature
                                                                                                                            1. Delimiter-Based Splitting
                                                                                                                              1. Fixed-Width Splitting
                                                                                                                                1. Advanced Splitting Options
                                                                                                                                2. Flash Fill Technology
                                                                                                                                  1. Pattern Recognition
                                                                                                                                    1. Automatic Data Extraction
                                                                                                                                      1. Flash Fill Limitations
                                                                                                                                      2. Find and Replace Operations
                                                                                                                                        1. Simple Text Replacement
                                                                                                                                          1. Wildcard Searches
                                                                                                                                            1. Regular Expression Support
                                                                                                                                              1. Format-Based Replacement
                                                                                                                                            2. Data Validation Implementation
                                                                                                                                              1. Validation Rule Types
                                                                                                                                                1. List-Based Validation
                                                                                                                                                  1. Number Range Validation
                                                                                                                                                    1. Date Range Validation
                                                                                                                                                      1. Text Length Validation
                                                                                                                                                        1. Custom Formula Validation
                                                                                                                                                        2. Dynamic Validation Lists
                                                                                                                                                          1. Named Range Lists
                                                                                                                                                            1. Table-Based Lists
                                                                                                                                                              1. Dependent Drop-Down Lists
                                                                                                                                                              2. Validation Messages
                                                                                                                                                                1. Input Messages
                                                                                                                                                                  1. Error Alert Messages
                                                                                                                                                                    1. Warning vs Stop Alerts

                                                                                                                                                                Previous

                                                                                                                                                                2. Foundational Spreadsheet Operations

                                                                                                                                                                Go to top

                                                                                                                                                                Next

                                                                                                                                                                4. Core Statistical and Analytical Functions