Excel Blog - Tutorials, Tips & Formula Guides

Read Excel tutorials, formula guides, productivity tips, and practical spreadsheet examples for beginners and advanced users.

Popular tutorial paths

  • Lookups: [VLOOKUP tutorial](/blog/vlookup-excel-tutorial/) → [XLOOKUP tutorial](/blog/xlookup-excel-tutorial/) → [INDEX MATCH](/blog/index-match-excel-guide/)
  • Reporting: [SUMIFS examples](/blog/sumifs-excel-examples/) → [percentage formulas](/blog/excel-percentage-formula/)
  • Data quality: [Remove duplicates](/blog/remove-duplicates-in-excel/) → [Power Query intro](/blog/excel-power-query-introduction/)
  • Inputs: [Drop-down lists](/blog/excel-drop-down-list-complete-guide/) → [Data validation](/blog/data-validation-in-excel/)

Latest Excel tutorials

  • Excel Macros for Beginners: Learn what Excel macros are, when to use them, how recording works, common automation examples, safety tips, and beginner best practices.
  • Power Query in Excel: Beginner Introduction: Learn what Power Query does in Excel, when to use it, how it helps clean data, combine files, transform columns, and refresh reports.
  • What-If Analysis in Excel: Learn Excel What-If Analysis tools, including Goal Seek, Scenario Manager, Data Tables, break-even analysis, and planning models.
  • 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.