Step-by-step tech tutorials

Clear answers for your iPhone, Windows, Office and Google apps

Latest guides

Excel Oct 22, 2026 17 min read

How to Use the FILTER Function in Excel

Type =FILTER(data, condition, "message if nothing matches") in one cell and Excel spills every matching row. This guide covers the syntax, AND and OR criteria, SORT and UNIQUE combinations, #SPILL! and #CALC! fixes, and how FILTER differs from the Filter button.

Read the guide
ExcelOct 19

How to Use XLOOKUP in Excel

Type =XLOOKUP(lookup value, lookup column, return column) and press Enter. This guide explains every argument, walks through 12 worked examples…

Browse by topic

New in popular topics

More recent guides

  1. Excel How to Make a Bar Graph in Excel
  2. iPhone How to Customize the Action Button on iPhone
  3. Excel How to Create a Pivot Table in Excel
  4. Windows 10 How to Activate Windows 11 or Windows 10 (Including Without a Product Key)
  5. Windows 10 Can’t Find Your BitLocker Recovery Key? Where to Look and What to Do
  6. iPhone How to Leave a Group Text on iPhone
  7. Tutorials How to Play iMessage Games on iPhone and iPad
  8. Tutorials How to Extract Text from a Screenshot in Windows 11
  9. Tutorials How to Share a Wi-Fi Password with a QR Code in Windows 11
  10. Tutorials How to Use Quick Machine Recovery in Windows 11
  11. Tutorials How to Use Tabs in Google Docs: A Step-by-Step Guide
  12. Tutorials How to Add a Subtab in Google Docs: A Step-by-Step Guide
  13. Tutorials How to Move Content Between Tabs in Google Docs Efficiently
  14. Tutorials How to Print One Tab from a Google Doc: A Step-by-Step Guide
  15. Tutorials How to Add a Cover Image to a Google Doc: A Step-by-Step Guide