Learning path

Spreadsheets for analysis

Functions, formulas, and spreadsheet workflows for analysts who want more autonomy.

6 articles

Spreadsheets Beginner Tutorial

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

Spreadsheets Beginner Tutorial

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

Feb 17, 2026 8 min read

Spreadsheets Beginner Tutorial

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

Spreadsheets Intermediate Tutorial

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

Feb 16, 2026 6 min read

Spreadsheets Intermediate Tutorial

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

Feb 16, 2026 12 min read

Spreadsheets Beginner Tutorial

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.