Excel Blog - Page 2
Page 2 of Excel tutorials and guides.
Articles
- Goal Seek in Excel: Complete Guide: Learn Goal Seek in Excel for reverse calculations, break-even analysis, target profit, loan payments, pricing, and what-if planning.
- Sparklines in Excel: Complete Guide: Learn how to use Excel sparklines for mini charts, trends, KPI tables, dashboards, and compact visual summaries.
- SUBTOTAL in Excel: Complete Guide: Learn SUBTOTAL in Excel for filtered lists, visible rows, sums, counts, averages, and report summaries that respond to filters.
- Rank Formula in Excel: Learn how to rank numbers in Excel with RANK, RANK.EQ, RANK.AVG, descending rank, ascending rank, and tie handling.
- Transpose Data in Excel: Learn how to transpose data in Excel using Paste Special, the TRANSPOSE function, dynamic arrays, and Power Query for repeatable workflows.
- Remove Blank Rows in Excel: Learn safe ways to remove blank rows in Excel using filters, Go To Special, sorting, and checks that avoid deleting valid partial records.
- Sort by Date in Excel: Learn how to sort dates in Excel, fix dates stored as text, sort by month, newest to oldest, oldest to newest, and custom date groups.
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.