Excel Blog - Page 7
Page 7 of Excel tutorials and guides.
Articles
- Absolute Reference in Excel: When to Use Dollar Signs: Learn absolute, relative, and mixed references in Excel, including when to use dollar signs, F4 shortcuts, and common formula copy mistakes.
- How to Lock Cells in Excel: Learn how to lock formulas, protect sheets, unlock input cells, and prevent accidental edits in Excel without breaking workbook usability.
- How to Split Text in Excel: Split text in Excel using Text to Columns, TEXTSPLIT, LEFT, RIGHT, MID, TEXTBEFORE, and TEXTAFTER with practical examples.
- How to Combine Cells in Excel: Combine cells in Excel with ampersand, CONCAT, CONCATENATE, TEXTJOIN, line breaks, spaces, commas, and formulas that ignore blanks.
- INDEX MATCH in Excel: Complete Guide: Learn INDEX MATCH in Excel with exact match examples, left lookup, two-way lookup, common errors, and when to use XLOOKUP instead.
- How to Use the IF Function in Excel: Learn the Excel IF function with practical examples for pass/fail results, status labels, nested IF formulas, AND/OR logic, and common mistakes.
- Excel Charts: Complete Guide to Choosing the Right Chart: Choose the right Excel chart for trends, comparisons, rankings, parts of a whole, and dashboards, with practical chart selection examples.
Recommended Excel resources
- Browse the complete Excel functions directory to find syntax, examples, common errors, and related formulas for every major function.
- Use the formula problem guides when a workbook returns #N/A, #VALUE!, #SPILL!, wrong totals, or formulas that do not update as expected.
- Compare similar Excel functions before choosing a formula, especially for lookup, conditional aggregation, text cleanup, and dynamic array tasks.