Google Sheets Basics
How to Autofill Cells in Google Sheets Based on Another Column
Learn how to autofill cells in Google Sheets based on another column using VLOOKUP, ARRAYFORMULA, IF statements, or custom Apps Script rules.
Read article
Blog
1285 articles
Google Sheets Basics
How to Autofill Date When a Cell Is Updated in Google Sheets
Autofill date in Google Sheets when a cell is updated using Apps Script or checkbox triggers with automatic timestamping options.
Read article
Google Sheets Basics
How to Extract a URL from a Hyperlink in Google Sheets
Extract URLs from hyperlinks in Google Sheets using REGEXEXTRACT formulas or Apps Script for both formula-based and manually added links.
Read article
Google Sheets Intermediate Tutorials
How to Recover Deleted Google Sheets After 30 Days
Learn how to recover deleted Google Sheets after 30 days using Google Support, Vault, collaborator access & version history.
Read article
Google Sheets Basics
How to Search for Text in a Range in Google Sheets
Learn how to search text in a range in Google Sheets using COUNTIF, FILTER, SEARCH, conditional formatting, and the Find tool.
Read article
Excel for Statistics
How to Make a Minimum Variance Portfolio in Excel
This article explores what is a minimum variance portfolio and how to make a minimum variance portfolio in Excel with the Solver Add-in.
Read article
Google Sheets Intermediate Tutorials
Data Validation Based on Another Cell in Google Sheets
Learn how to use data validation in Google Sheets based on another cell using fixed cell rules, row-based conditions, or Google Apps Script.
Read article
Google Sheets Formulas
How to Reference a Cell in Another Sheet in Google Sheets
Learn how to reference a cell from another sheet in Google Sheets using direct links, INDIRECT function, and tips to avoid common errors.
Read article
Google Sheets Intermediate Tutorials
How to Create a Dependent Drop-Down List in Google Sheets
Learn how to create a dependent drop-down list in Google Sheets using Named Ranges, INDIRECT, FILTER function, or Google Apps Script.
Read article
Excel for Statistics
How to Calculate Variance Inflation Factor in Excel
This article explores what is variance inflation factor and how to calculate variance inflation factor in Excel with Data Analysis ToolPak.
Read article
Excel Charts
How to Select Data for a Chart in Excel (with Different Criteria)
Learn how to select data for a chart in Excel—before or after creating it. Covers adjacent, non-adjacent data, and named range selections.
Read article
Google Sheets Formulas
Remove Duplicate Rows Based on One Column in Google Sheets
Learn how to remove duplicate rows based on another column in Google Sheets using built-in tools, UNIQUE, QUERY, and troubleshooting tips.
Read article