Excel Blog - Page 3
Page 3 of Excel tutorials and guides.
Articles
- Filter by Color in Excel: Learn how to filter by cell color, font color, and conditional formatting color in Excel reports and cleanup workflows.
- Wrap Text in Excel: Complete Guide: Learn how to wrap text in Excel, add line breaks, fix row height, align text, and make long labels readable in reports.
- Merge Cells in Excel: When to Use It and Avoid It: Learn how to merge cells in Excel, when merged cells are useful, why they can break sorting and filtering, and better alternatives.
- Compare Two Columns in Excel: Compare two columns in Excel to find matches, differences, missing values, duplicates, and lookup mismatches using formulas and formatting.
- Find Duplicate Values in Excel: Find duplicate values in Excel using conditional formatting, COUNTIF formulas, Remove Duplicates, and data cleanup checks.
- Excel Calendar Template Guide: Create an Excel calendar template for monthly planning, schedules, deadlines, content calendars, and recurring tasks.
- How to Create a Gantt Chart in Excel: Build a Gantt chart in Excel using task names, start dates, durations, stacked bar charts, dependencies, and project timeline formatting.
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.