Excel for Beginners: 15 Things You Need to Know First
New to Excel? Start with these 15 essentials: workbooks and cells, entering data, formulas, AutoFill, cell references, formatting, sorting, filtering, tables, charts and shortcuts.
New to Excel? Start with these 15 essentials: workbooks and cells, entering data, formulas, AutoFill, cell references, formatting, sorting, filtering, tables, charts and shortcuts.
Split full names into first and last name columns in Excel using Flash Fill, Text to Columns, TEXTSPLIT, or formulas. Includes tips for middle names and Google Sheets.
Keep headers visible while you scroll. Learn how to freeze the top row, first column, or several rows and columns at once in Excel and Google Sheets, and how to unfreeze them.
Learn the simple formula for percentage change in Excel, plus percentage of total, adding or removing a percentage, and how to avoid #DIV/0! errors. With copyable examples.
Excel showing the formula instead of the result? Here are the 5 causes, from Show Formulas mode and Text-formatted cells to a missing equals sign, and how to fix each one.
Download a free printable Google Sheets formulas cheat sheet: 50+ formulas with examples, including Sheets-only tools like QUERY, IMPORTRANGE, ARRAYFORMULA, GOOGLETRANSLATE and REGEX.
Download a free 2-page printable Excel formulas cheat sheet: 52 essential formulas with examples (SUMIFS, XLOOKUP, IF, TEXT, dates, FILTER), plus common errors and must-know tips.
Learn the IF function in Excel and how to combine it with AND and OR to test several conditions. Real examples for bonuses, pass/fail grades, overdue invoices and more.
Learn how INDEX and MATCH work together in Excel to look up values in any direction. Step-by-step examples, two-way lookups, and how it compares to VLOOKUP and XLOOKUP.
Numbers stored as text break SUM, VLOOKUP and sorting in Excel. Learn how to spot them and 6 quick ways to convert text to numbers, including Text to Columns and VALUE.