Google Sheets Resources

From data visualization to custom formulas, learn how to use Google Sheets to its fullest potential
with the help of our in-depth, step-by-step, newbie-friendly guides.
249 Resources
Pie Chart in Google Sheets
Wrap Text in Google Sheets
Waterfall Chart in Google Sheets
Bar Graph in Google Sheets
Scatter Plot in Google Sheets
Scorecard Chart in Google Sheets
Candlestick Chart in Google Sheets
Gantt Chart in Google Sheets
Timeline Chart in Google Sheets
Kanban Board in Google Sheets
Add Trendline in Google Sheets
Drop-down List in Google Sheets
Alphabetize in Google Sheets
Sort by Date in Google Sheets
Sort in Google Sheets
Freeze Rows or Columns in Google Sheets
Highlight Duplicates in Google Sheets
Bubble Chart in Google Sheets
UNIQUE Function in Google Sheets
Checklist in Google Sheets
Conditional Formatting Based on Another Cell in Google Sheets
Add Columns in Google Sheets
Convert Excel to Google Sheets
Subtract in Google Sheets
Remove Duplicate in Google Sheets
Emojis in Google Sheets
Make a Calendar in Google Sheets
Subscript in Google Sheets
Org Chart in Google Sheets
Multiply in Google Sheets
Hide Rows in Google Sheets
Zoom in and Zoom out in Google Sheets
Delete Rows in Google Sheets
Make Cells Bigger in Google Sheets
Hide Columns in Google Sheets
Split Cells in Google Sheets
Lock a Row in Google Sheets
Remove Gridlines in Google Sheets
Total a Column in Google Sheets
Count Cells with Text in Google Sheets
Make a Schedule in Google Sheets
Bullet Points in Google Sheets
Set Print Area in Google Sheets
Checkmarks in Google Sheets
Today's Date in Google Sheets
Add Numbers in Google Sheets
Make a Graph in Google Sheets
Indent in Google Sheets
Make a Table in Google Sheets
Find and Replace in Google Sheets
CONCATENATE Function in Google Sheets
Auto Sort in Google Sheets
Rename Columns in Google Sheets
TRUE Function in Google Sheets
Protect Cells in Google Sheets
FIND Function in Google Sheets
Filter Views in Google Sheets
MOD Function in Google Sheets
AVERAGE Function in Google Sheets
Group Rows and Columns in Google Sheets
SPLIT Function in Google Sheets
Multiple IF Statements in Google Sheets
Pivot Chart in Google Sheets
Sort by Column in Google Sheets
Merge Cells in Google Sheets
TRANSPOSE Function in Google Sheets
Secondary Axis in Google Sheets
Substring in Google Sheets
Histogram in Google Sheets
Undo Sort in Google Sheets
INDIRECT Function in Google Sheets
Divide in Google Sheets
Not Equal Operator in Google Sheets
Edit Access in Google Sheets
ISBLANK Function in Google Sheets
Copy Formula Down in Google Sheets
New Line in Cell in Google Sheets
Data Validation Based on Another Cell in Google Sheets
Sort by Last Name in Google Sheets
Conditional Formatting with a Checkbox in Google Sheets
Make Gridlines Darker in Google Sheets
Average Ignore 0 in Google Sheets
Link to Another Sheet in Google Sheets
Paste CSV in Google Sheets
Background Image in Google Sheets
Remove Links in Google Sheets
Center Across Selection in Google Sheets
Capitalize First Letter in Google Sheets
Make All Columns Same Width in Google Sheets
Increment Cell Values in Google Sheets
Multi-Level Nested Pie Chart in Google Sheets
Pie of Pie Chart in Google Sheets
Add Target Line to a Chart in Google Sheets
Row Height in Google Sheets
Cumulative Sum Chart in Google Sheets
Dark Mode in Google Sheets
Flowchart in Google Sheets
Change Pie Chart Percentage in Google Sheets
Venn Diagram in Google Sheets
Double Line Graph in Google Sheets
Chart Wizard in Google Sheets
Time Series Chart in Google Sheets
Burndown Chart in Google Sheets
Delete a Chart in Google Sheets
Rotate Pie Chart in Google Sheets
Export Chart in Google Sheets
How to Have 2 Y-Axes in Google Sheets
Switch the X- and Y-axes in Google Sheets
Pie Chart Labels in Google Sheets
Add Vertical or Horizontal Chart Gridlines in Google Sheets
Histogram Bins in Google Sheets
Move Chart to New Sheet in Google Sheets
Dynamic Chart Title from a Cell in Google Sheets
Connect Scatter Plot Data Points in Google Sheets
Change Axis Scales in Google Sheets
Correlation Chart in Google Sheets
Google Sheets Workout Templates
Google Sheets Run-of-Show Templates
Remove Underline in Google Sheets
Extrapolate Graph in Google Sheets
Add an Equation to a Graph in Google Sheets
Google Sheets Payroll Templates
How to Underline in Google Sheets
Google Sheets Packing List Templates
Google Sheets Password Templates
Frequency Table in Google Sheets
Frequency Polygon in Google Sheets
Google Sheets Profit and Loss Templates
Google Sheets Checklist Template
Google Sheets Meal Plan Templates
Line Graph in Google Sheets
Google Sheets Address Book Templates
Google Sheets Wedding Budget Templates
Google Sheets Attendance Templates
Google Sheets Marketing Budget Templates
Google Sheets Personal Budget Templates
Google Sheets Renovation Budget Templates
Google Sheets Moving Budget Templates
Google Sheets College Student Budget Templates
How to Make a Mortgage Calculator in Google Sheets
Google Sheets Business Budget Templates
Google Sheets Household Budget Templates
Google Sheets Monthly Budget Templates
Google Sheets Nonprofit Budget Templates
Google Sheets Project Budget Templates
Google Sheets Event Budget Templates
Google Sheets Zero-Based Budget Templates
Google Sheets Crossword Templates
Google Sheets Travel Budget Templates
Google Sheets Weekly Budget Templates
Google Sheets Startup Budget Templates
Google Sheets Student Data Tracker Templates
How to Make a Budget in Google Sheets
Google Sheets Production Budget Templates
Google Sheets Christmas Budget Templates
Google Sheets School Budget Templates
Google Sheets 50/30/20 Budget Templates
Google Sheets Ledger Templates
Google Sheets Club Budget Templates
Debt Snowball Spreadsheets
Google Sheets Construction Budget Templates
Google Sheets Budget Templates
Split Templates for Excel and Google Sheets
ARRAY_CONSTRAIN Function in Google Sheets
Google Sheets Business Expenses Templates
Free Google Sheets Cash Flow Templates
Net Worth Spreadsheets
BYCOL Function in Google Sheets
QUOTIENT Function in Google Sheets
T.INV.2T Function in Google Sheets
EXP Function in Google Sheets
ROUND Function in Google Sheets
SUBTOTAL Function in Google Sheets
SUM Function in Google Sheets
SUMIF Function in Google Sheets
SUMIFS Function in Google Sheets
MINUS Function in Google Sheets
MULTIPLY Function in Google Sheets
TO_DATE Function in Google Sheets
COUNT Function in Google Sheets
RANK Function in Google Sheets
CONCATENATE Function in Google Sheets
JOIN Function in Google Sheets
LEFT Function in Google Sheets
LEN Function in Google Sheets
REPLACE Function in Google Sheets
RIGHT Function in Google Sheets
SEARCH Function in Google Sheets
TEXT Function in Google Sheets
IMPORTRANGE Function in Google Sheets
LINEST Function in Google Sheets
MAP Function in Google Sheets
DATE Function in Google Sheets
TODAY Function in Google Sheets
WEEKDAY Function in Google Sheets
FILTER Function in Google Sheets
SORT Function in Google Sheets
PMT Function in Google Sheets
ARRAYFORMULA Function in Google Sheets
DETECTLANGUAGE Function in Google Sheets
GOOGLEFINANCE Function in Google Sheets
IMAGE Function in Google Sheets
QUERY Function in Google Sheets
SPARKLINE Function in Google Sheets
ISERROR Function in Google Sheets
ISNUMBER Function in Google Sheets
ISTEXT Function in Google Sheets
CELL Function in Google Sheets
AND Function in Google Sheets
FALSE Function in Google Sheets
IF Function in Google Sheets
IFERROR Function in Google Sheets
IFS Function in Google Sheet
NOT Function in Google Sheets
OR Function in Google Sheets
COLUMNS Function in Google Sheets
FORMULATEXT Function in Google Sheets
INDEX Function in Google Sheets
LOOKUP Function in Google Sheets
MATCH Function in Google Sheets
OFFSET Function in Google Sheets
ROW Function in Google Sheets
ROWS Function in Google Sheets
VLOOKUP Function in Google Sheets
XLOOKUP Function in Google Sheets
CEILING Function in Google Sheets
CEILING.PRECISE Function in Google Sheets
COMBIN Function in Google Sheets
COMBINA Function in Google Sheets
COS Function in Google Sheets
COSH Function in Google Sheets
COT Function in Google Sheets
COTH Function in Google Sheets
COUNTBLANK Function in Google Sheets
COUNTIF Function in Google Sheets
COUNTIFS Function in Google Sheets
COUNTUNIQUE Function in Google Sheets
CSC Function in Google Sheets
CSCH Function in Google Sheets
DECIMAL Function in Google Sheets
DEGREES Function in Google Sheets
Google Sheet Debt Payoff Templates
Google Sheets Checkbook Register Templates
Google Sheets Personal Financial Statement Templates
Google Sheets Budget and Expense Tracker Templates
Retirement Planning Spreadsheets for Excel & Google Sheets

Google Sheets Tutorials & Guides

Browse our collection of Google Sheets how-to tutorials and guides to learn how to master this spreadsheet tool. From starter guides to advanced formulas and AppsScript, our resource library is comprised of in-depth, step-by-step tutorials to help you become a Google Sheets guru. 

If you’re getting started, we can help you take your first steps towards mastery, covering the essentials such as charting, functions, and basic data analysis tools. For more advanced Google Sheets users, we have AppsScript tutorials and complex data analysis guides to help them hone their skills. Regardless of your proficiency in Google Sheets, you’ll find something valuable for growing your skills.

Learn About Google Sheets

Our mission is to create the largest hub of easy-to-follow Google Sheets tutorials on the Web as there are not that many resources systematizing how to use Google Sheets, despite the tool boasting a monthly user base of over two billion people. Browse our step-by-step Google Sheets tutorials to hone your skills and learn how to use these tools more effectively.

Google Sheets Articles

Our articles and step-by-step guides on Google Sheets are completely free so that you can always find the answer to your question.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X