Excel Blog - Page 4
Page 4 of Excel tutorials and guides.
Articles
- 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.
- IFERROR in Excel: Practical Examples: Learn IFERROR in Excel for cleaner VLOOKUP, XLOOKUP, division, dashboard formulas, and error handling without hiding real data problems.
- Flash Fill in Excel: Complete Guide: Learn Flash Fill in Excel for splitting names, extracting codes, formatting phone numbers, combining text, and cleaning imported data.
- Find and Replace in Excel: Complete Guide: Use Find and Replace in Excel to update text, formulas, formats, spaces, line breaks, wildcards, and workbook-wide values safely.
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.