Excel Blog - Page 3
Page 3 of Excel tutorials and guides.
Articles
- 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.
- Excel Invoice Template Guide: Create an Excel invoice template with line items, quantities, prices, tax, discounts, totals, invoice numbers, and professional formatting.
- Excel Budget Template Guide: Build a practical Excel budget template with income, expenses, categories, monthly totals, variance formulas, and dashboard-ready summaries.
- Excel Time Formulas: Complete Guide: Learn Excel time formulas for hours worked, time differences, overtime, adding hours, formatting durations, and common time calculation errors.
- Excel Date Formulas: Complete Guide: Learn Excel date formulas for today, due dates, month ends, working days, age, days between dates, and common date problems.
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.