ViewTube

Learn how to use IMPORTHTML in Google Sheets to import web tables straight into cells. We demo =IMPORTHTML(url, "table", ...

Learn how to use IMPORTXML in Google Sheets to scrape a web page straight into your sheet. We demo =IMPORTXML(url, ...

Learn how to use INDEX MATCH in Google Sheets to build lookups more flexible than VLOOKUP. We demo =INDEX(C2:C, ...

Learn how LEFT, RIGHT and MID work in Google Sheets to slice any piece out of a text string. We demo =LEFT(A2, 3) lifting the ...

Learn how to use the MATCH function in Google Sheets to find a value's exact position in a list. We demo =MATCH("Mia", B2:B, ...

Learn how to use NETWORKDAYS in Google Sheets to count only the working days between two dates. We demo ...

Learn how to use the PMT function in Google Sheets to calculate loan payments in one cell. We demo =PMT(0.08/12, 60, -20000) ...

Learn how to use REGEXEXTRACT in Google Sheets to pull clean data out of messy text. We demo =REGEXEXTRACT(A2, ...

Learn how to use the ROUND function in Google Sheets to tidy long decimals fast. We demo =ROUND(B2, 2) snapping 3.14159 ...

Learn how to use SPARKLINE in Google Sheets to draw a mini chart inside a single cell. We demo =SPARKLINE(B2:G2) turning ...