Topic

Spreadsheets

Google Sheets, formulas, and techniques to organize analysis before scaling to SQL or Python.

6 articles

Mastering COUNTIF and COUNTIFS Functions in Google Spreadsheets

A comprehensive guide to improving data analysis skills with the COUNTIF and COUNTIFS functions in Google Spreadsheets.

Feb 17, 2026 8 min read

Learn how to effectively use the CONCATENATE function in Google Spreadsheets to enhance your data handling capabilities.

Feb 17, 2026 8 min read

A comprehensive guide to mastering the SUMIF and SUMIFS functions in Google Sheets for advanced data analysis and efficiency.

Feb 16, 2026 7 min read

A comprehensive guide to SUMPRODUCT in Google Sheets — weighted sums, conditional sums, and array formulas.

Feb 16, 2026 6 min read

A deep dive into the QUERY function in Google Sheets, covering syntax, uses, optimization tips, and troubleshooting.

Feb 16, 2026 12 min read

A quick guide to pulling data between spreadsheets with IMPORTRANGE, plus common errors and fixes.

Feb 05, 2026 4 min read

Data Analysis Specialization

A practical program with SQL, ETL, and Python for analysts.