How-to guides and tutorials to help you perform specific tasks and use products and applications made by Microsoft.
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. Continue Reading How to Use the FILTER Function in Excel
Type =XLOOKUP(lookup value, lookup column, return column) and press Enter. This guide explains every argument, walks through 12 worked examples with sample tables, compares XLOOKUP with VLOOKUP, and fixes the common errors. Continue Reading How to Use XLOOKUP in Excel
Open Settings > Accounts > Automatic replies in the new Outlook or Outlook on the web, or File > Automatic Replies in classic Outlook. This guide gives separate steps for Windows, web, Mac, and mobile, a rule workaround for POP and IMAP accounts, sample messages, and fixes when replies don’t send. Continue Reading How to Set Up Automatic Replies (Out of Office) in Outlook
Select your data and choose Insert > Insert Column or Bar Chart > Clustered Bar. This guide explains bar vs column charts, clustered vs stacked vs 100% stacked, data labels, axis formatting, putting the largest bar on top, Mac and web steps, and fixes for common problems. Continue Reading How to Make a Bar Graph in Excel
Click a cell in your data, choose Insert > PivotTable, and check the fields you want to summarize. This guide covers every step on Windows, Mac, and the web, plus a worked example, Recommended PivotTables, PIVOTBY, refreshing, and troubleshooting. Continue Reading How to Create a Pivot Table in Excel
Activate Windows 11 or 10 with a digital license, product key, or Microsoft account. What works without a key, how to fix activation errors, and what it costs. Continue Reading How to Activate Windows 11 or Windows 10 (Including Without a Product Key)
Stuck on the BitLocker recovery screen? Here’s every place your 48-digit key can be, how to enter it, and your real options if it’s gone for good. Continue Reading Can’t Find Your BitLocker Recovery Key? Where to Look and What to Do
Restart a frozen Windows 11 taskbar by restarting Windows Explorer in Task Manager, or with a Terminal command. Continue Reading How to Restart the Taskbar in Windows 11
Add a user on Windows 10 from Settings > Accounts > Family & other users, with a Microsoft account or a local account, then set the account type. Continue Reading How to Add an Account on Windows 10
Start Windows 11 or 10 in Safe Mode: hold Shift, click Restart, open Startup Settings and press 4. Also covers msconfig and sign-in screen methods. Continue Reading How to Get Into Safe Mode in Windows 11 and 10
Free up C drive space in Windows 10 with Storage Sense, temporary file cleanup, uninstalling unused apps, and moving large files. Continue Reading How to Increase C Drive Space in Windows 10
Convert HEIC to JPG on Windows with Photos or Paint, batch-convert whole folders, or set your iPhone to send JPGs automatically. Includes fixes if it fails. Continue Reading How to Change HEIC to JPG on Windows 11 and 10 (4 Easy Ways)
Delete a leftover Windows service safely with sc delete in an admin Command Prompt, find the right service name, and when to disable instead. Continue Reading How to Delete a Windows Service (Safely)
Back up your iPhone to a Windows PC with Apple Devices or iTunes, encrypt the backup, find where backups are saved, and restore your iPhone. Continue Reading How to Back Up an iPhone to a Windows Computer (Apple Devices or iTunes)
Use iMessage on Windows by linking your iPhone to Phone Link over Bluetooth. Setup steps, what works (and doesn’t), and safe alternatives. Continue Reading How to Use iMessage on Windows With Phone Link
Install Node.js and npm on Windows 10 or 11 with the official installer, winget, or nvm-windows, verify the install, and fix PATH and script errors. Continue Reading How to Install Node.js on Windows 10 and 11 (Installer, winget, nvm)
Reset a network adapter in Windows 10 by re-enabling it, resetting Winsock and TCP/IP, using Network reset in Settings, or reinstalling the driver. Continue Reading How to Reset a Network Adapter in Windows 10
PC picture cut off on the TV? Turn off overscan with Just Scan or Screen Fit, use the recommended resolution, and adjust graphics scaling. Continue Reading How to Fit Your PC Screen to a TV in Windows 10
Pause Windows updates for up to five weeks, set active hours, and use metered connections or Group Policy to control when updates install. Continue Reading How to Stop Windows From Automatically Updating
Fix “Wireless capability is turned off” in Windows 10: check the Wi-Fi key, Airplane mode, adapter settings, power management, drivers, and the BIOS. Continue Reading How to Turn On Wireless Capability in Windows 10
Update Windows in Settings > Windows Update > Check for updates. Learn update types, driver updates, upgrading to Windows 11, and fixes for failed updates. Continue Reading How to Update Your Windows Computer
Transfer videos from an iPhone to a Windows 10 PC with the Photos app, File Explorer, or iCloud, and fix videos that will not copy or play. Continue Reading How to Transfer Videos From iPhone to PC on Windows 10
Cast Windows 10 to a TV: turn on the TV mirroring mode, press Windows + K and choose the TV. Use browser casting or HDMI if Miracast is not supported. Continue Reading How to Cast Windows 10 to a TV
Find recently deleted files in the Recycle Bin, and recover files that are not there with Previous Versions, File History or winfr. Continue Reading How to See Recently Deleted Files on Windows
Stop a Windows 11 update that is downloading or installing with Pause updates, and when it is not safe to interrupt one. Continue Reading How to Stop a Windows 11 Update in Progress
Check the Windows event log with Event Viewer: open it, choose the right log, filter for errors, understand common event IDs, and query logs in PowerShell. Continue Reading How to Check the Windows Event Log (Event Viewer Guide)
See all open windows with Task View (Windows+Tab), Alt+Tab, or taskbar thumbnails. Includes fixes for windows hidden on other desktops. Continue Reading How to See All Open Windows in Windows 11 and 10
Lock your keyboard on Windows with Windows + L, lock automatically with Dynamic Lock, or disable a laptop keyboard in Device Manager. Continue Reading How to Lock Your Keyboard on Windows
Switch tabs on Windows with Ctrl + Tab, Ctrl + Shift + Tab and Ctrl + number, plus Alt + Tab for windows and tab tips for File Explorer. Continue Reading How to Change Tabs on Windows (Keyboard Shortcuts)
Play VOB files on Windows 10 with a DVD-capable player such as VLC: open the VIDEO_TS folder for the full disc, or a single VOB file. Continue Reading How to Play VOB Files on Windows 10
Restore Windows 11 or 10 to a previous date with System Restore without losing files, even when Windows will not start, and undo or create restore points. Continue Reading How to Restore Windows to a Previous Date (System Restore Guide)
Back up a Windows 11 laptop to an external hard drive with File History or a system image, copy files manually, and restore your data. Continue Reading How to Back Up a Laptop to an External Hard Drive on Windows 11
Copy a DVD in Windows 10 to your PC with File Explorer, convert home videos to MP4, burn a copy to a blank disc, and why Media Player cannot rip DVDs. Continue Reading How to Copy a DVD in Windows 10 (to Your PC or a New Disc)
Unzip files in Windows by right-clicking the ZIP and choosing Extract All. Recent Windows 11 versions also open 7z, RAR and TAR archives. Continue Reading How to Unzip Files in Windows
Add a file, folder, file type or process exclusion in Windows Security, choose the safest type, and remove it later. Continue Reading How to Add an Exclusion to Windows Defender (Windows Security)
Convert files to PDF on Windows for free: press Ctrl + P and choose Microsoft Print to PDF, or use Save As PDF in Office apps to keep links. Continue Reading How to Convert to PDF on Windows: Print to PDF and Save As
Clear temp files in Windows 10 via Settings > System > Storage > Temporary files, the %temp% folder, or Disk Cleanup. Plus Storage Sense automation. Continue Reading How to Clear Temp Files in Windows 10
Record your screen in Windows 11 with Win + Shift + R, record an app with Game Bar (Win + Alt + R), or record audio with Sound Recorder. Continue Reading How to Record Your Screen or Audio in Windows
Check disk space on Windows 10: open File Explorer > This PC, or Settings > System > Storage for a breakdown. Plus Disk Management and cleanup tips. Continue Reading How to Check Disk Space on Windows 10
Connect to Wi-Fi on Windows 7 from the taskbar network icon, join hidden networks, and fix missing Wi-Fi, driver problems, and no internet access. Continue Reading How to Connect to Wi-Fi on Windows 7
Blur your background in the Zoom desktop app on Windows 10 from Background and effects or during a meeting. Continue Reading How to Blur Your Background in Zoom on Windows 10
Install pygame on Windows 10 or 11 with py -m pip install pygame, test it with the aliens example, and fix common errors. Continue Reading How to Install Pygame on Windows 10
Block websites on Windows 10 or 11 with the hosts file for every browser, or with Microsoft Family Safety for a child account. Continue Reading How to Block Websites on Windows
Create a new virtual desktop in Windows with Windows+Ctrl+D or Task View, New desktop, and switch with Windows+Ctrl+Arrow keys. Continue Reading How to Make a New Desktop in Windows
Copy or move files from an external hard drive to a Windows 11 PC with File Explorer or robocopy, then eject safely. Continue Reading How to Transfer Files From an External Hard Drive to a PC
Find your IP address on Windows 10 in Settings or with ipconfig, and learn the difference between your private and public IP. Continue Reading How to Check Your IP Address on Windows 10
Windows To Go was removed, but you can still run Windows from an external SSD with an imaging tool. Steps and limits. Continue Reading How to Install Windows on an External Hard Drive
Trim a video on Windows 10 for free with Clipchamp by dragging the clip edges, or bring back the old Photos trim tool with Photos Legacy. Continue Reading How to Trim a Video in Windows 10
Move the taskbar to the top, left, right or bottom. Windows 11 added a Taskbar position setting in the September 2026 update; Windows 10 always had one. Continue Reading How to Move the Windows Taskbar to the Top, Side or Bottom
Close programs on Windows with the X button, Alt+F4 or the taskbar, and force-close frozen apps with Task Manager. Continue Reading How to Close Programs on Windows