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 LET Function: Write Cleaner, Faster Formulas: Learn how the Excel LET function names intermediate calculations, cuts formula repetition, and makes nested XLOOKUP and IF logic easier to read in Microsoft 365.
  • UNIQUE Function in Excel: Remove Duplicates & Build Lists: Master the Excel UNIQUE function to extract distinct values, count duplicates, and build dynamic dropdown lists in Microsoft 365. Includes BYCOL, BYROW, and spill tips.
  • How to Convert Text to Number in Excel (Green Triangle Fix): Fix numbers stored as text in Excel: remove the green triangle, repair SUM and VLOOKUP errors, and use VALUE, multiply by 1, or Text to Columns.
  • REGEXTEST in Excel: Pattern Matching Guide (With Examples): Learn how to use the Excel REGEXTEST function to validate emails, IDs, and text patterns. Includes match_mode syntax, real examples, and fixes for #VALUE! errors.
  • 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.