Google Sheets Guides

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 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 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 Sort by Date in Google Sheets
How to Sort and Ignore Blanks in Google Sheets
How to Convert Date to Number 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 Write a Case Statement in Google Sheets
How to Use a SUMPRODUCT IF Formula 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 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 Average If Cell Contains Text in Google Sheets
How to Get Remainder in Google Sheets
How to Use ISBLANK with Cell Range in Google Sheets
How to Count Cells with Text in Google Sheets
How to Count Characters in Google Sheets
How to Interpolate Missing Values in Google Sheets
How to Use MAXIFS 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 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 Using Custom Formula in Google Sheets
How to Count Number of Occurrences 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 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 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 Use ISERROR in Google Sheets
How to Check if Value is in Range in Google Sheets
How to Convert Between Month Name & Number in Google Sheets
How to Compare Two 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 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 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 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 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 Reverse a Text String in Google Sheets
How to Extract Substring in Google Sheets
How to Extract Numbers from String 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 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 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 Check if Cell is Empty in Google Sheets
Google Sheets: Conditional Formatting with Multiple Conditions
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 Covariance Matrix in Google Sheets
How to Create a Correlation Matrix 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 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 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 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 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 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 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 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 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 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 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 Extract Top N Values from Range
Google Sheets Query: How to Return Only Unique Rows
Google Sheets Query: How to Query From Another Sheet
Google Sheets Query: How to Query From Multiple Sheets
Google Sheets Query: How to Use CONCAT with QUERY
Google Sheets Query: How to Use IMPORTRANGE with Conditions
Google Sheets Query: Use IMPORTRANGE with Multiple Sheets
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