Topic

spreadsheet functions

Deep dive into spreadsheet functions. Learn powerful formulas for Google Sheets and Excel data manipulation.

Google Sheets QUERY Function: SQL for Your Spreadsheet

Master the Google Sheets QUERY function. Learn SELECT, WHERE, GROUP BY, and more with practical examples and error fixes.

Feb 9, 202610 min read

Learn how to use XLOOKUP in Google Sheets with examples. Covers syntax, VLOOKUP comparison, wildcards, reverse lookups, and advanced techniques.

Feb 9, 20268 min read

Learn INDEX MATCH in Google Sheets with step-by-step examples. Faster and more flexible than VLOOKUP for left lookups.

Feb 9, 20269 min read

Discover how to add and interpret a Google Sheets line of best fit. This guide covers trendlines, functions like LINEST, and analyzing any dataset.

Feb 1, 202613 min read

Big CSV and Excel imports freeze the tab and lose work. SmoothSheet does them server-side, with a backup you can roll back to.

See how it worksGoogle sign-in, no card. Free plan covers 10 uploads a month.