Excel Blog - Page 6
Page 6 of Excel tutorials and guides.
Articles
- How to Calculate Age in Excel: Calculate age in Excel from a date of birth using DATEDIF, YEARFRAC, TODAY, and formulas for years, months, days, and exact age labels.
- Excel Percentage Formula: Complete Guide: Learn how to calculate percentages in Excel, including percent of total, percentage increase, percentage decrease, discounts, margins, and completion rates.
- Conditional Formatting in Excel: Complete Guide: Learn conditional formatting in Excel for highlighting duplicates, overdue dates, top values, low stock, status colors, and formula-based rules.
- 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.
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.