Google Sheets Tips
82 articles · 5 videos
Article · Google Sheets TipsJoined Data Marts in Google Sheets: One Report from Several Tables, No VLOOKUP Chains
Article · Google Sheets TipsWhy Your Scheduled Refresh Keeps Wiping Google Sheets Formulas (and How to Fix It)
Article · Google Sheets TipsGA4 reports in Google Sheets: two ways to automate them
Article · Google Sheets TipsARRAYFORMULA in Google Sheets: how to use array formulas, with examples
Article · Google Sheets TipsHow to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFS
Article · Google Sheets TipsHow to make a bar graph in Google Sheets, with error bars
Article · Google Sheets TipsROUND, CEILING and FLOOR in Google Sheets: which rounding function to use
Article · Google Sheets TipsCHAR function in Google Sheets: list of codes and examples
Article · Google Sheets TipsHow to make a chart in Google Sheets: types and settings
Article · Google Sheets TipsCONCATENATE and & in Google Sheets: combine text from cells
Article · Google Sheets TipsCOUNT and COUNTA in Google Sheets: what each one counts, with examples
Article · Google Sheets TipsCOUNTIF and COUNTIFS in Google Sheets: criteria and examples
Article · Google Sheets TipsData validation in Google Sheets: rules, drop-down lists and custom formulas
Article · Google Sheets TipsHow to filter by date with QUERY in Google Sheets
Article · Google Sheets TipsDate functions in Google Sheets: DATE, DATEVALUE, DATEDIF, EDATE and EPOCHTODATE
Article · Google Sheets TipsDates and times in Google Sheets: how they work, with formulas
Article · Google Sheets TipsDAY, DAYS and DAYS360 in Google Sheets: formulas and examples
Article · Google Sheets Tips7 Google Sheets features every marketer should know
Article · Google Sheets TipsEXACT function in Google Sheets: case-sensitive comparison, lookup and count
Article · Google Sheets TipsExploratory data analysis in Google Sheets: a step-by-step guide
Article · Google Sheets TipsFIND and SEARCH functions in Google Sheets: differences, formulas and examples
Article · Google Sheets TipsFILTER function in Google Sheets: formula, conditions and examples
Article · Google Sheets TipsMATCH function in Google Sheets: find the position of a value
Article · Google Sheets TipsHow to convert currency in Google Sheets using GOOGLEFINANCE
Article · Google Sheets TipsGOOGLEFINANCE function in Google Sheets: syntax, attributes list and examples
Article · Google Sheets TipsHLOOKUP in Google Sheets: syntax, examples and errors
Article · Google Sheets TipsFind and replace in Google Sheets: options, regex and examples
Article · Google Sheets TipsHow to sort data in Google Sheets: by column, by multiple columns, by date and by color
Article · Google Sheets TipsHow to split cells in Google Sheets: Split text to columns and the SPLIT function
Article · Google Sheets TipsHow to use VLOOKUP with an IF statement in Google Sheets
Article · Google Sheets TipsHow to wrap text in Google Sheets: menu, toolbar, line breaks and fixes
Article · Google Sheets TipsIF function in Google Sheets: formula, IF with AND and OR, nested IF
Article · Google Sheets TipsIFS function in Google Sheets: several conditions in one formula
Article · Google Sheets TipsIMPORTDATA function in Google Sheets: import a CSV or TSV file from a URL
Article · Google Sheets TipsIMPORTFEED function in Google Sheets: import an RSS or Atom feed
Article · Google Sheets TipsIMPORTHTML function in Google Sheets: import a table or a list from a web page
Article · Google Sheets TipsIMPORTRANGE in Google Sheets: formula, multiple ranges, examples and errors
Article · Google Sheets TipsIMPORTXML in Google Sheets: syntax, XPath examples and errors
Article · Google Sheets TipsHow to use INDEX MATCH in Google Sheets: formula, examples and errors
Article · Google Sheets TipsJOIN and TEXTJOIN in Google Sheets: join a range into one cell
Article · Google Sheets TipsXLOOKUP vs VLOOKUP in Google Sheets: the key differences
Article · Google Sheets TipsLEFT, RIGHT and MID in Google Sheets: extract part of a text
Article · Google Sheets TipsLEN function in Google Sheets: count characters in a cell
Article · Google Sheets TipsHow to link cells, tabs and spreadsheets in Google Sheets
Article · Google Sheets TipsLOOKUP function in Google Sheets: syntax, examples and when to use another lookup
Article · Google Sheets TipsMAX, MIN and MEDIAN in Google Sheets: formulas and examples
Article · Google Sheets TipsMONTH and EOMONTH functions in Google Sheets: formulas and examples
Article · Google Sheets TipsNOW and TODAY functions in Google Sheets: current date and time, with examples
Article · Google Sheets TipsPERCENTILE function in Google Sheets: PERCENTILE.INC and PERCENTILE.EXC with examples
Article · Google Sheets TipsPERCENTRANK function in Google Sheets: the percentile rank of a value
Article · Google Sheets TipsPivot charts in Google Sheets: how to make a chart from a pivot table
Article · Google Sheets TipsPivot tables in Google Sheets: how to create, customize and use them
Article · Google Sheets TipsPivot tables and charts in Google Sheets: from a raw table to a report
Article · Google Sheets TipsQUARTILE function in Google Sheets: how to calculate quartiles, the IQR and outliers
Article · Google Sheets TipsQUERY function in Google Sheets: syntax, clauses and examples
Article · Google Sheets TipsQUERY vs VLOOKUP in Google Sheets: which one to use
Article · Google Sheets TipsQUERY with CONCATENATE in Google Sheets: how to concatenate two columns
Article · Google Sheets TipsQUERY with IMPORTRANGE in Google Sheets: formula and 12 examples
Article · Google Sheets TipsQUERY with UNIQUE in Google Sheets: how to return distinct rows
Article · Google Sheets TipsRANK function in Google Sheets: RANK, RANK.EQ and RANK.AVG
Article · Google Sheets TipsREGEX functions in Google Sheets: REGEXMATCH, REGEXEXTRACT and REGEXREPLACE
Article · Google Sheets TipsHow to remove duplicates in Google Sheets, and prevent them
Article · Google Sheets TipsREPLACE function in Google Sheets: syntax and examples
Article · Google Sheets TipsREPT function in Google Sheets: repeat text, pad values and draw in-cell bars
Article · Google Sheets TipsHow to search in Google Sheets: Find, find and replace, and the SEARCH function
Article · Google Sheets TipsSlicers in Google Sheets: how to add, use and save them
Article · Google Sheets TipsSORT and SORTN in Google Sheets: syntax, top N and ties
Article · Google Sheets TipsSPARKLINE in Google Sheets: chart types, options and examples
Article · Google Sheets TipsSUBSTITUTE function in Google Sheets: replace text, the nth occurrence and multiple values
Article · Google Sheets TipsHow to sum in Google Sheets: SUM, SUMIF and SUMIFS with examples
Article · Google Sheets TipsTables in Google Sheets: how to create, format and reference them
Article · Google Sheets TipsTEXT function in Google Sheets: format codes for numbers, dates and times
Article · Google Sheets TipsHow to calculate time in Google Sheets: add, subtract and the TIME functions
Article · Google Sheets TipsTRIM, CLEAN and T functions in Google Sheets: remove extra spaces and hidden characters
Article · Google Sheets TipsUNIQUE function in Google Sheets: syntax, examples and common errors
Article · Google Sheets TipsUPPER, LOWER and PROPER in Google Sheets: change text case
Article · Google Sheets TipsVLOOKUP in Google Sheets: formula, VLOOKUP from another sheet, and examples
Article · Google Sheets TipsVLOOKUP with multiple criteria in Google Sheets: 5 ways
Article · Google Sheets TipsDay of the week and week number in Google Sheets: WEEKDAY, WEEKNUM and ISOWEEKNUM
Article · Google Sheets TipsWORKDAY and NETWORKDAYS in Google Sheets: how to count working days
Article · Google Sheets TipsYEAR and YEARFRAC functions in Google Sheets: get the year from a date and the years between two dates
Article · Google Sheets TipsStop delegating tasks with data screenshots that are wrong by morningYou are booked. The invitation is on its way to , with the calendar invite and the meeting link.
Schedule in person meeting at Data Outpost San Francisco
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.