This page lists every Google Sheets tutorial on Statology.
Operations
How to Round to Significant Figures in Google Sheets
How to Round to Nearest 5 or 10 in Google Sheets
How to Round to Nearest 25 in Google Sheets
How to Use Data Validation in Google Sheets
How to Auto Increment Values in Google Sheets
How to Count Cells Between Two Values in Google Sheets
How to Use COUNTIF Contains in Google Sheets
How to Use COUNTIF with Multiple Ranges in Google Sheets
How to Use COUNTIF From Another Sheet in Google Sheets
How to Use COUNTIF with OR in Google Sheets
How to Use COUNTIF with Wildcards in Google Sheets
How to Use COUNTIFS with Date Range in Google Sheets
How to Use COUNTIF Greater Than Zero in Google Sheets
How to COUNTIF Not Equal to Text in Google Sheets
How to COUNTIF True in Google Sheets
How to Use SUMIFS with a Date Range in Google Sheets
How to Use SUMIF with Multiple Columns in Google Sheets
How to Use SUMIF Contains in Google Sheets
How to Use SUMIF with OR in Google Sheets
How to Use SUMIF From Another Sheet in Google Sheets
How to Use a LARGE IF Formula in Google Sheets
How to Use a RANK IF Formula in Google Sheets
How to Use a MULTIPLY IF Function in Google Sheets
How to Exclude Cell from Range in Formulas in Google Sheets
How to Use an IF Function with 3 Conditions in Google Sheets
How to Use an IF Function with Range of Values in Google Sheets
How to Use an IF Function with Dates in Google Sheets
How to Sort by Date in Google Sheets
How to Convert Date to Quarter and Year in Google Sheets
How to Convert Date to Month and Year in Google Sheets
How to Convert Date to Number in Google Sheets
How to Convert Days to Months in Google Sheets
How to Get First Day of Month in Google Sheets
How to Sum Time Duration in Google Sheets
How to Convert Minutes to Hours in Google Sheets
How to Convert Time to Seconds in Google Sheets
How to Convert Time to Minutes in Google Sheets
How to Convert Time to Decimal in Google Sheets
How to Create Formula for “If Time is Greater Than” in Google Sheets
How to Sort and Ignore Blanks in Google Sheets
How to Count the Number of Workdays Between Dates in Google Sheets
How to Calculate Days Between Date and Today in Google Sheets
How to Generate Number of Days in a Month in Google Sheets
How to Write a Case Statement in Google Sheets
How to Use a SUMPRODUCT IF Formula in Google Sheets
How to Use DEVSQ in Google Sheets
How to Use SUMSQ in Google Sheets
How to Convert Negative Numbers to Zero in Google Sheets
How to Add Strikethrough When Checkbox is Checked in Google Sheets
How to Sum If Checkbox is Checked in Google Sheets
How to Change Color when Checkbox is Checked in Google Sheets
How to Sum Only Positive Numbers in Google Sheets
How to Sum Every Nth Row in Google Sheets
How to Sum Cells If Not Blank in Google Sheets
How to Sum by Month in Google Sheets
How to Sum by Year in Google Sheets
How to Count by Month in Google Sheets
How to Select Every Nth Row in Google Sheets
How to Calculate Average if Greater Than Zero in Google Sheets
How to Calculate Average by Month in Google Sheets
How to Calculate Average If Not Blank in Google Sheets
How to Use AVERAGEIFS in Google Sheets
How to Calculate a Weighted Average in Google Sheets
How to Use Weighted Average IF Formula in Google Sheets
How to Calculate Average If Cell Contains Text in Google Sheets
How to Calculate Average by Group in Google Sheets
How to Calculate Average Excluding Outliers in Google Sheets
How to Calculate Average If Between Two Dates in Google Sheets
How to Get Remainder in Google Sheets
How to Return Blank Instead of Zero in Google Sheets
How to Use ISBLANK with Cell Range in Google Sheets
How to Split Text into Rows in Google Sheets
How to Split Date & Time in Google Sheets
How to Use SPLIT with Multiple Delimiters in Google Sheets
How to Use SPLIT and Get First Item in Google Sheets
How to Use SPLIT and Get Last Item in Google Sheets
How to Count Cells with Text in Google Sheets
How to Count Characters in Google Sheets
How to Count Duplicates in Google Sheets
How to Use SEARCH with Multiple Values in Google Sheets
How to Find Duplicates in Two Columns in Google Sheets
How to Interpolate Missing Values in Google Sheets
How to Use MAXIFS in Google Sheets
How to Use MINIFS in Google Sheets
How to Use Multiple IF Statements in Google Sheets
How to Rank Items by Multiple Columns in Google Sheets
How to Sum Filtered Rows in Google Sheets
How to Count Filtered Rows in Google Sheets
How to Average Filtered Rows in Google Sheets
How to Filter Multiple Columns in Google Sheets
How to Filter from Another Sheet in Google Sheets
How to Filter by List of Values in Google Sheets
How to Filter Cells by Color in Google Sheets
How to Use FILTER with Wildcard in Google Sheets
How to Use FILTER Function with OR in Google Sheets
How to Use FILTER Function with AND in Google Sheets
How to Pull Data from Another Sheet Based on Criteria in Google Sheets
How to Find the Closest Value in Google Sheets
How to Find the Top 10% of Values in Google Sheets
How to Multiply Column by a Percentage in Google Sheets
How to Multiply Column by a Constant in Google Sheets
How to Filter for Cells that Contain Text in Google Sheets
How to Filter for Cells that Do Not Contain Text in Google Sheets
How to Filter Using Custom Formula in Google Sheets
How to Filter a Column by Multiple Values in Google Sheets
How to Count Number of Occurrences in Google Sheets
How to Extract Last Word from Cell in Google Sheets
How to Substitute Multiple Values in Google Sheets
How to Count Rows with Value in Google Sheets
How to Group Data by Month in Google Sheets
How to Group Data by Week in Google Sheets
How to Get Date from Week Number in Google Sheets
How to Get First Day of Week in Google Sheets
How to Add Weeks to Date in Google Sheets
How to Add Months to Date in Google Sheets
How to Add Years to Date in Google Sheets
How to Extract Month from Date in Google Sheets
How to Extract Year from Date in Google Sheets
How to Calculate Number of Months Between Dates in Google Sheets
How to Use the Binomial Distribution in Google Sheets
How to Replace Blank Cells with Zero in Google Sheets
How to Replace #N/A Values in Google Sheets
How to Replace Text in Google Sheets
How to Replace Spaces with Dashes in Google Sheets
How to Use LEFT to Extract Text Before Space in Google Sheets
How to Use ISERROR in Google Sheets
How to Check if Multiple Cells are Equal in Google Sheets
How to Check if Value is in Range in Google Sheets
How to Check if Cell Contains Text from List in Google Sheets
How to Check if Value Exists in Another Column in Google Sheets
How to Convert Between Month Name & Number in Google Sheets
How to Perform a Left Join in Google Sheets
How to Compare Two Columns in Google Sheets
How to Compare Three Columns in Google Sheets
How to Combine the IF and OR Functions in Google Sheets
How to Combine the IF and AND Functions in Google Sheets
How to Calculate the Difference Between Dates in Google Sheets
How to Convert Timestamp to Date in Google Sheets
How to Calculate a Time Difference in Google Sheets
How to Create a Countdown Timer in Google Sheets
How to Compare Dates in Google Sheets
How to Compare Strings in Google Sheets
How to Filter by Date Range in Google Sheets
How to Convert Dates to Strings in Google Sheets
How to Convert Text to Numbers in Google Sheets
How to Filter with Multiple Conditions in Google Sheets
How to Add & Subtract Days in Google Sheets
How to Calculate Day of the Year in Google Sheets
How to Generate Random Dates in Google Sheets
How to AutoFill Dates in Google Sheets
How to Autofill Values from Another Sheet in Google Sheets
How to Fill Series in Google Sheets
How to Create a Crosstab in Google Sheets
How to Link to Another Tab in Google Sheets
How to Randomize a List in Google Sheets
How to Count Unique Values in Google Sheets
How to Use Count Unique IF Function in Google Sheets
How to Create Unique List Across Multiple Columns in Google Sheets
How to Perform a Reverse VLOOKUP in Google Sheets
How to Use a Case Sensitive VLOOKUP in Google Sheets
How to Use IFERROR with VLOOKUP in Google Sheets
How to Use VLOOKUP by Date in Google Sheets
How to Use ARRAYFORMULA with VLOOKUP in Google Sheets
How to Use VLOOKUP with Multiple Criteria in Google Sheets
How to Use VLOOKUP to Return All Matches in Google Sheets
How to Use VLOOKUP to Return Multiple Columns in Google Sheets
How to Use VLOOKUP From Another Workbook in Google Sheets
How to Use VLOOKUP with IF Statement in Google Sheets
How to Use INDEX MATCH with Multiple Criteria in Google Sheets
How to Use XLOOKUP in Google Sheets
How to Select a Random Sample in Google Sheets
How to Select a Random Value From a List in Google Sheets
How to Escape Quotes in Google Sheets
How to Reverse a Text String in Google Sheets
How to Count Specific Words in Google Sheets
How to Extract Substring in Google Sheets
How to Remove Substring in Google Sheets
How to Extract Numbers from String in Google Sheets
How to Concatenate Cells with Line Break in Google Sheets
How to Concatenate Cells with a Comma in Google Sheets
How to Use a Concatenate If Formula in Google Sheets
How to Use CONCATENATE with a Space in Google Sheets
How to Concatenate Dates in Google Sheets
How to Calculate Tenure in Google Sheets
How to Remove Non-Numeric Characters in Google Sheets
How to Remove Numbers from Strings in Google Sheets
How to Combine Columns in Google Sheets
How to Calculate Compound Interest in Google Sheets
How to Use the PMT Function in Google Sheets
How to Use SEQUENCE Function in Google Sheets
How to Sum Across Multiple Sheets in Google Sheets
How to Add Calculated Field to Pivot Table in Google Sheets
How to Add Commas to a Number in Google Sheets
How to Create Pivot Table with Count of Occurrences in Google Sheets
How to Create Pivot Table with Unique Counts in Google Sheets
How to Display Percentage of Total in Pivot Table in Google Sheets
How to Create Pivot Table from Multiple Sheets in Google Sheets
How to Format Pivot Tables in Google Sheets
How to Sort a Pivot Table in Google Sheets
How to Remove Grand Total from Pivot Table in Google Sheets
How to Perform What-If Analysis in Google Sheets
How to Remove Special Characters in Google Sheets
How to Ignore #N/A Values with Formulas in Google Sheets
How to Ignore Blank Cells with Formulas in Google Sheets
How to Ignore #DIV/0! Error in Google Sheets
How to Check if Cell is Empty in Google Sheets
How to Use “Does Not Equal” in Google Sheets
How to Highlight Highest Value in Google Sheets
How to Highlight Lowest Value in Google Sheets
Google Sheets: Conditional Formatting with Multiple Conditions
Google Sheets: Conditional Formatting if Another Cell Contains Text
Google Sheets: Conditional Formatting if Another Cell is Not Empty
Google Sheets: Conditional Formatting from Another Sheet
Google Sheets: Conditional Formatting Based on Checkbox
Google Sheets: Conditional Formatting If Date is Before Today
Google Sheets: Conditional Formatting Between Two Values
Google Sheets: Use “Not Equal” in Conditional Formatting
Google Sheets: A Simple Formula for “If Contains”
Google Sheets: A Simple Formula for “If Not Empty”
Descriptive Statistics
How to Calculate Descriptive Statistics in Google Sheets
How to Calculate a Five Number Summary in Google Sheets
How to Calculate Mean, Median & Mode in Google Sheets
How to Calculate the Interquartile Range in Google Sheets
How to Calculate Standard Deviation in Google Sheets
How to Calculate the Midrange in Google Sheets
How to Calculate the Coefficient of Variation in Google Sheets
How to Calculate Skewness & Kurtosis in Google Sheets
How to Calculate Standard Error of the Mean in Google Sheets
How to Create a Summary Table in Google Sheets
How to Create a Covariance Matrix in Google Sheets
How to Create a Correlation Matrix in Google Sheets
How to Perform Matrix Multiplication in Google Sheets
How to Calculate the Dot Product in Google Sheets
How to Calculate Spearman Rank Correlation in Google Sheets
How to Calculate Square Root & Cube Root in Google Sheets
How to Normalize Data in Google Sheets
How to Calculate Frequencies in Google Sheets
How to Calculate Class Width in Google Sheets
How to Calculate the Mean Absolute Deviation in Google Sheets
How to Calculate Mean and Standard Deviation in Google Sheets
How to Calculate a Trimmed Mean in Google Sheets
How to Calculate Z-Scores in Google Sheets
How to Calculate Deciles in Google Sheets
How to Calculate Quintiles in Google Sheets
How to Calculate Percent Change in Google Sheets
How to Calculate Cumulative Percentage in Google Sheets
How to Calculate a Weighted Percentage in Google Sheets
How to Calculate Average Percentage in Google Sheets
How to Find Outliers in Google Sheets
How to Find A Line of Best Fit in Google Sheets
How to Find an Exponential Moving Average in Google Sheets
How to Calculate CAGR in Google Sheets
How to Use MIN Function and Exclude Zero in Google Sheets
How to Find Max Value by Group in Google Sheets
How to Sum Values by Category in Google Sheets
How to Perform a Median IF Function in Google Sheets
How to Use a Percentile IF Formula in Google Sheets
How to Calculate the 90th Percentile in Google Sheets
How to Calculate Percentile Rank in Google Sheets
How to Perform a Standard Deviation IF Function in Google Sheets
Visualizations
How to Create a Boxplot in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create an Area Chart in Google Sheets
How to Create a Pareto Chart in Google Sheets
How to Create a Quadrant Chart in Google Sheets
How to Create a Cumulative Sum Chart in Google Sheets
How to Add Average Line to Chart in Google Sheets
How to Create a Scatter Plot with Lines in Google Sheets
How to Add a Second Y-Axis in Google Sheets
How to Add Axis Labels in Google Sheets
How to Change Axis Scales in Google Sheets
How to Plot Multiple Lines in Google Sheets
How to Plot an Equation in Google Sheets
How to Plot a Time Series in Google Sheets
How to Find Intersection of Two Lines in Google Sheets
How to Create and Use Variables in Google Sheets
How to Create Progress Bars in Google Sheets
How to Create a Pie Chart in Google Sheets
How to Create a Dot Plot in Google Sheets
How to Create a Gauge Chart in Google Sheets
How to Create a Bell Curve in Google Sheets
How to Create a Combo Chart in Google Sheets
How to Create a Burndown Chart in Google Sheets
How to Create a Double Bar Graph in Google Sheets
How to Create a Stacked Bar Chart in Google Sheets
How to Create a Candlestick Chart in Google Sheets
How to Change Number of Bins in Histogram in Google Sheets
How to Create a Table in Google Sheets
How to Add Error Bars to Charts in Google Sheets
How to Add Custom Data Labels in Google Sheets
How to Add Labels to Scatterplot Points in Google Sheets
How to Add a Horizontal Line to a Chart in Google Sheets
How to Add a Vertical Line to a Chart in Google Sheets
How to Add Trendline to Chart in Google Sheets
How to Add Multiple Trendlines to Chart in Google Sheets
How to Find the Slope of a Trendline in Google Sheets
How to Chart Data from Multiple Sheets in Google Sheets
How to Create Chart with Multiple Ranges of Data in Google Sheets
How to Create a Chart and Ignore Blank Cells in Google Sheets
Hypothesis Tests
How to Perform t-Tests in Google Sheets
How to Perform the F-Test in Google Sheets
How to Perform a Normality Test in Google Sheets
How to Find P-Values in Google Sheets
How to Find Critical Values in Google Sheets
How to Calculate Confidence Intervals in Google Sheets
Regression
How to Perform Linear Regression in Google Sheets
How to Perform Polynomial Regression in Google Sheets
How to Perform Logarithmic Regression in Google Sheets
How to Perform Logistic Regression in Google Sheets
How to Use LOGEST Function in Google Sheets
How to Create a Forecast in Google Sheets
How to Perform Curve Fitting in Google Sheets
How to Create a Residual Plot in Google Sheets
How to Calculate R-Squared in Google Sheets
ANOVA
One-Way ANOVA in Google Sheets
Repeated Measures ANOVA in Google Sheets
Chi-Square Tests
Chi-Square Goodness of Fit Test in Google Sheets
Query Functions
Google Sheets Query: How to Select Multiple Columns
Google Sheets Query: Select Rows that Contain String
Google Sheets Query: How to Use “Not Equal” in Query
Google Sheets Query: How to Ignore Blank Cells in Query
Google Sheets Query: How to Create a Pivot Table
Google Sheets Query: How to Get Row Number in Queries
Google Sheets Query: How to Use Order By
Google Sheets Query: How to Use Group By
Google Sheets Query: How to Filter by Date Range
Google Sheets Query: How to Use TODAY() Function in Query
Google Sheets Query: How to Use the COUNT Function
Google Sheets Query: How to Use the SUM Function
Google Sheets Query: How to Sum Multiple Columns
Google Sheets Query: How to Use “NOT LIKE” in Query
Google Sheets Query: How to Use Column Names
Google Sheets Query: How to Use Named Ranges in Query
Google Sheets Query: How to Insert Blank Columns in Output
Google Sheets Query: How to Extract Top N Values from Range
Google Sheets Query: How to Return Only Unique Rows
Google Sheets Query: How to Use LIMIT to Limit Rows
Google Sheets Query: How to Use WHERE IN a List
Google Sheets Query: How to Query From Another Sheet
Google Sheets Query: How to Query From Multiple Sheets
Google Sheets Query: How to Query From Multiple Ranges
Google Sheets Query: How to Use CONCAT with QUERY
Google Sheets Query: How to Join Two Tables
Google Sheets Query: How to Use IMPORTRANGE with Conditions
Google Sheets Query: Use IMPORTRANGE with Multiple Sheets
Google Sheets Query: How to Filter IMPORTRANGE Data
Google Sheets Query: Use IMPORTRANGE Within Same Spreadsheet
Google Sheets Query: How to Query Using Month
Google Sheets Query: How to Use Cell Reference in Formula
Google Sheets Query: How to Use Multiple Criteria in Query
Google Sheets Query: How to Use Wildcard Characters
Google Sheets Query: How to Use the Label Clause
Google Sheets Query: How to Remove Header from Results