Google Sheets for Beginners: Everything You Need to Get Started
Learn Google Sheets from scratch: create a sheet, enter data, use basic formulas, format, sort and filter, make charts, share with your team and work offline. Free step-by-step guide.
Learn Google Sheets from scratch: create a sheet, enter data, use basic formulas, format, sort and filter, make charts, share with your team and work offline. Free step-by-step guide.
Split names, emails, codes and addresses with Excel’s newer text functions TEXTSPLIT, TEXTBEFORE and TEXTAFTER: simple examples, useful options and alternatives for older Excel and Google Sheets.
Find what’s in one list but not the other, highlight matches and duplicates, and compare row by row in Excel with COUNTIF, XLOOKUP, FILTER and conditional formatting.
Use Excel’s Goal Seek to work backwards from a target: the price you need for a profit goal, the sales needed to break even, or the loan you can afford, with step-by-step examples.
Give cells and ranges names like VAT_Rate or Sales so formulas read like sentences. How to create named ranges with the Name Box, Define Name and Create from Selection, manage them, and use them in drop-downs.
Turn any list into an Excel Table with Ctrl + T: automatic formatting, filters, formulas that copy themselves, a total row, structured references, and ranges that grow with your data.
VLOOKUP, XLOOKUP and MATCH ignore upper and lower case. Learn how to do a case-sensitive lookup with EXACT, count case-sensitive matches, and find case-sensitive duplicates.
Stop Excel printing a few columns on extra pages: fit the sheet to one page, set the print area, use landscape and narrow margins, repeat header rows, and check Page Break Preview.
Lock formulas but let people type in input cells: how to protect an Excel sheet, protect workbook structure, encrypt a file with a password, and protect ranges in Google Sheets.
Fix extra spaces, hidden characters and inconsistent capitals in Excel with TRIM, CLEAN, PROPER, UPPER, LOWER and SUBSTITUTE, including the non-breaking space problem from web and system exports.