Basic Excel formulas everyone should know
The most-used Excel formulas with examples: SUM, AVERAGE, COUNT, IF, COUNTIF, SUMIF, VLOOKUP and CONCAT, plus how to write a formula step by step.
Technology & computers
Step-by-step answers to the most common questions about computers, phones and everyday software.
If you are just starting
- Basic Excel formulas everyone should know
- How to clear your browser cache (Chrome, Edge, Firefox and Safari)
- How to convert a PDF to Word for free (no extra software)
- How to download YouTube videos legally and safely
- How to free up storage on your phone (Android and iPhone)
- How to merge cells in Excel (and unmerge them)
- How to recover your Facebook account if you can't log in
- How to take a screenshot on a PC (Windows and Mac)
- The most useful keyboard shortcuts for Windows and Mac
All technology & computers guides (10)
How to clear your browser cache (Chrome, Edge, Firefox and Safari)
Steps to clear cache and cookies in Chrome, Edge, Firefox and Safari on computer and phone, and what actually happens when you do it.
How to convert a PDF to Word for free (no extra software)
How to turn a PDF into an editable Word document with Microsoft Word or Google Docs, which PDFs convert best, and how to keep private documents safe.
How to download YouTube videos legally and safely
The legal ways to download YouTube videos to watch offline, what YouTube's rules say, and the risks of free download websites and converters.
How to free up storage on your phone (Android and iPhone)
Steps to free up storage on Android and iPhone: see what takes the most space, clear app cache, photos and videos, WhatsApp media, unused apps and downloads.
How to merge cells in Excel (and unmerge them)
How to merge and center cells in Excel, how to unmerge them, how to combine text from several cells without losing data, and the Center Across Selection option.
How to recover your Facebook account if you can't log in
What to do if you forgot your Facebook password or your account was hacked: the official recovery pages, the steps, and how to secure your account afterward.
How to take a screenshot on a PC (Windows and Mac)
Every way to take a screenshot on Windows 10 and 11 and on a Mac: keyboard shortcuts, Snipping Tool, the active window, and where screenshots are saved.
The most useful keyboard shortcuts for Windows and Mac
The most useful keyboard shortcuts for Windows and Mac: copy, paste, undo, find, switch windows, reopen tabs, screenshots and more in one easy table.
VLOOKUP in Excel: how to use it step by step with examples
How to use VLOOKUP in Excel: syntax, a practical example, exact match, the most common #N/A errors and the modern alternative, XLOOKUP.