Blog

Articles

422 articles

Fresh from the blog

Newest first

ARRAYFORMULA in Google Sheets: how to use array formulas, with examplesGoogle Sheets TipsARRAYFORMULA in Google Sheets: how to use array formulas, with examplesHow to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFSGoogle Sheets TipsHow to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFSHow to make a bar graph in Google Sheets, with error barsGoogle Sheets TipsHow to make a bar graph in Google Sheets, with error bars

All articles

422 articles

ARRAYFORMULA in Google Sheets: how to use array formulas, with examplesGoogle Sheets TipsARRAYFORMULA in Google Sheets: how to use array formulas, with examplesHow to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFSGoogle Sheets TipsHow to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFSHow to make a bar graph in Google Sheets, with error barsGoogle Sheets TipsHow to make a bar graph in Google Sheets, with error barsROUND, CEILING and FLOOR in Google Sheets: which rounding function to useGoogle Sheets TipsROUND, CEILING and FLOOR in Google Sheets: which rounding function to useCHAR function in Google Sheets: list of codes and examplesGoogle Sheets TipsCHAR function in Google Sheets: list of codes and examplesHow to make a chart in Google Sheets: types and settingsGoogle Sheets TipsHow to make a chart in Google Sheets: types and settingsCONCATENATE and & in Google Sheets: combine text from cellsGoogle Sheets TipsCONCATENATE and & in Google Sheets: combine text from cellsCOUNT and COUNTA in Google Sheets: what each one counts, with examplesGoogle Sheets TipsCOUNT and COUNTA in Google Sheets: what each one counts, with examplesCOUNTIF and COUNTIFS in Google Sheets: criteria and examplesGoogle Sheets TipsCOUNTIF and COUNTIFS in Google Sheets: criteria and examplesData analysis tools in 2026: 19 tools by the job they doAnalytics ToolsData analysis tools in 2026: 19 tools by the job they doData validation in Google Sheets: rules, drop-down lists and custom formulasGoogle Sheets TipsData validation in Google Sheets: rules, drop-down lists and custom formulasHow to filter by date with QUERY in Google SheetsGoogle Sheets TipsHow to filter by date with QUERY in Google SheetsDate functions in Google Sheets: DATE, DATEVALUE, DATEDIF, EDATE and EPOCHTODATEGoogle Sheets TipsDate functions in Google Sheets: DATE, DATEVALUE, DATEDIF, EDATE and EPOCHTODATEDates and times in Google Sheets: how they work, with formulasGoogle Sheets TipsDates and times in Google Sheets: how they work, with formulasDAY, DAYS and DAYS360 in Google Sheets: formulas and examplesGoogle Sheets TipsDAY, DAYS and DAYS360 in Google Sheets: formulas and examples7 Google Sheets features every marketer should knowGoogle Sheets Tips7 Google Sheets features every marketer should knowEXACT function in Google Sheets: case-sensitive comparison, lookup and countGoogle Sheets TipsEXACT function in Google Sheets: case-sensitive comparison, lookup and countExploratory data analysis in Google Sheets: a step-by-step guideGoogle Sheets TipsExploratory data analysis in Google Sheets: a step-by-step guideFIND and SEARCH functions in Google Sheets: differences, formulas and examplesGoogle Sheets TipsFIND and SEARCH functions in Google Sheets: differences, formulas and examplesFILTER function in Google Sheets: formula, conditions and examplesGoogle Sheets TipsFILTER function in Google Sheets: formula, conditions and examplesMATCH function in Google Sheets: find the position of a valueGoogle Sheets TipsMATCH function in Google Sheets: find the position of a valueHow to convert currency in Google Sheets using GOOGLEFINANCEGoogle Sheets TipsHow to convert currency in Google Sheets using GOOGLEFINANCEGOOGLEFINANCE function in Google Sheets: syntax, attributes list and examplesGoogle Sheets TipsGOOGLEFINANCE function in Google Sheets: syntax, attributes list and examplesHLOOKUP in Google Sheets: syntax, examples and errorsGoogle Sheets TipsHLOOKUP in Google Sheets: syntax, examples and errors

…