Excel Blog - Page 6
Page 6 of Excel tutorials and guides.
Articles
- Excel Formulas Cheat Sheet: Essential Formulas: A practical Excel formulas cheat sheet covering SUM, IF, XLOOKUP, COUNTIF, SUMIFS, TEXTJOIN, dates, errors, and lookup formulas.
- How to Filter in Excel: Learn how to filter data in Excel by text, numbers, dates, colors, blanks, search terms, and dynamic FILTER formulas.
- How to Sort in Excel: Learn how to sort data in Excel by one column, multiple columns, dates, colors, custom lists, and dynamic SORT formulas.
- Data Validation in Excel: Complete Guide: Use data validation in Excel to create drop-down lists, restrict dates and numbers, prevent invalid entries, and protect spreadsheet quality.
- 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.
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.