Guides

• AI Chatbots Compared: Limits, Price, File Upload and Web Search

  Read the limit rules before you pay: 5-hour windows, 2x to 20x multipliers, 32k to 1M context, and file caps for Claude, Gemini, ChatGPT and Mistral.

• Blue Screen of Death: Read the Stop Code and Fix It on Windows 11

  A Windows blue screen shows a stop code such as 0x0000001A. Learn what it means, where the 64 KB minidump is saved and the fixes Microsoft lists, in order.

• CapCut for Beginners: Free vs Pro, 4K Export and the Watermark

  Start with CapCut: split with Ctrl+B, find why 4K is missing, remove the template watermark, and compare free and Pro prices. Read 2026-11-01.

• ChatGPT Alternatives: Claude, Gemini, Mistral, Perplexity, Copilot

  Five ChatGPT alternatives matched to jobs, with plan prices from official pages: Claude $20, Mistral $14.99, Gemini EUR 21.99, ChatGPT Plus $20.

• ChatGPT vs Claude: Plans, Prices and Limits (Oct 2026)

  ChatGPT Plus is $20 a month, Claude Pro $20 monthly or $200 a year. Plans, limits, models and data settings, as the official pages stated on 31 Oct 2026.

• Claude vs Gemini: Plans, Limits and Upload Sizes Side by Side

  Claude Pro is $20 a month; Google AI Pro is EUR 21.99. Compare context size, 5-hour limits, file uploads and storage from the official pages, read 2026-11-01.

• COUNTIFS Explained: Count Rows That Meet Every Condition

  COUNTIFS syntax, text, number and date criteria, Microsoft's quota example that returns 2, and the 255-character and empty-cell traps.

• Excel Conditional Formatting: 6 Rule Types, Formulas and Limits

  Excel conditional formatting has 6 advanced rule types. Learn the menu path, the formula rule with $ signs, rule order, the 255-character text limit and fixes.

• Excel Drop-Down List: Data Validation Steps, Alerts and Limits

  Make an Excel drop-down list in 6 steps with Data > Data Validation > List. See the Stop, Warning and Information alerts, the 255-character limit and Mac steps.

• Excel FILTER Function: Syntax, Versions and #SPILL! Fixes

  FILTER(array, include, [if_empty]) needs Excel 2021, 2024 or 365. See AND and OR examples, the #CALC! fix and 7 causes of #SPILL!.

• Excel Freeze Panes: Top Row, First Column or Both, and Unfreeze

  Freeze the top row, first column or both in Excel with View > Freeze Panes. See which cell to click, how to unfreeze, how Split differs, and the Sheets steps.

• Excel Keyboard Shortcuts: Windows and Mac Keys That Differ

  The Excel shortcuts that use different keys on Windows and Mac: time, AutoSum, Paste Special, strikethrough, Define Name. Plus F-key fixes for MacBooks.

• Excel Macros for Beginners: Record One, Read It, Run It Safely

  Record a macro in 4 steps, read the VBA it writes, and learn why a downloaded file blocks macros and how to unblock it. Windows and Mac steps.

• Excel PivotTables: Create, Refresh, Group and Limits

  Build a PivotTable in 5 steps, refresh it, group dates and numbers, and know the limits: 1,048,576 unique items and 300,000-row undo cutoff.

• Excel Remove Duplicates: 3 Methods and What Gets Deleted

  Highlight, filter or delete duplicates in Excel. A 6-row example shows how the columns you tick change the result, plus undo and limits.

• Excel Text to Columns: Delimited, Fixed Width and Pitfalls

  Split one Excel column on commas or spaces in 7 steps. Covers fixed width, text qualifiers, leading zeros, 15-digit limit and TEXTSPLIT.

• Excel to PDF: Print Area, Scaling and Page Breaks That Work

  Save Excel as PDF in 6 steps, then fix wide sheets: print area, Fit to 1 page wide, page breaks and why manual breaks stop working under Fit to.

• Excel UNIQUE Function: Syntax, Examples and #SPILL! Fixes

  UNIQUE(array, by_col, exactly_once) in Excel 2021, 2024 and 365: an 8-row worked example, SORT pairing and 5 causes of #SPILL!.

• Figma for Beginners: Toolbar, Frames and Free Plan Limits

  Learn Figma's toolbar, frames and panels, plus what the free Starter plan allows (3 files, 30 days of history) and what Professional costs at $16.

• Google Sheets IMPORTRANGE: Permission, Limits and Fixes

  IMPORTRANGE needs one Allow Access click per source, caps each request at 10MB and rechecks hourly. Syntax, a worked example and the errors to expect.

• Google Sheets QUERY Function: Clauses, Order and Examples

  QUERY takes 3 arguments and up to 10 clauses in a fixed order. See select, where, group by, pivot, label and the traps, with a worked example.

• How to Use Claude: Projects, File Uploads and Usage Limits

  Set up a Claude Project, upload up to 20 files of 500 MB, and read the 5-hour usage limit in Settings > Usage. Free allows 5 projects; Pro is $20 a month.

• How to Use Gemini: Sign In, Upload Files and Know Your Limits

  Sign in at gemini.google.com, attach up to 10 files per prompt, and learn the 5-hour limit, 32k to 1M token windows and plan prices from Google's help pages.

• IFERROR Explained: Replace Formula Errors, Not Hide Them

  IFERROR(value, value_if_error) catches 7 error types. See Microsoft's 210/35 example, when IFNA is safer, and what it does in Google Sheets.

• INDEX MATCH Explained: Two-Way Lookups in Excel and Sheets

  INDEX returns the cell, MATCH finds its row number. See the syntax, a worked example with real cells, and why #N/A or #REF! appears.

• Mac Won't Connect to Wi-Fi: 8 Apple Checks in Order

  Fix a Mac that won't join Wi-Fi: restart, forget the network, check Private Wi-Fi Address on macOS 15, VPN software and 8 router settings from Apple.

• Microsoft Teams for Beginners: Chats, Channels and Meeting Limits

  Teams explained with real limits: free meetings stop at 60 minutes and 100 people, group chats lose video calling above 20 people. Read 2026-11-01.

• Notion Templates: Make, Import and Repeat Them (Limits by Plan)

  How Notion database templates work, how to import files up to 5 MB on Free or 50 MB on paid plans, and the repeat and nesting rules, read 2026-11-01.

• Obsidian for Beginners: Vaults, Links, Plugins and Sync Prices

  Obsidian is free. Set up a vault in 4 steps, link notes with [[ ]], and see what Sync ($4 a month yearly) and Publish ($8) add. Read 2026-11-01.

• Outlook Not Working? Fix It by Symptom (Classic Outlook, Windows)

  Frozen, Disconnected, password loop or stuck Outbox? Match the symptom to Microsoft's fix: outlook.exe /safe, add-ins, profile, IPv6 key, send limits.

• Outlook Rules Guide: Create Them and Stay Under 256 KB

  Make Outlook rules in new Outlook, classic and on the web, and learn the 256 KB rule space limit and the 20-person client-only error. Read 2026-11-01.

• PAGE_FAULT_IN_NONPAGED_AREA (0x50): Causes and Fixes

  Stop code 0x50 means a driver or RAM touched memory that is not there. Read the 4 parameters, name the driver, then run chkdsk /f /r and a memory test.

• Printer Offline? Fix It on Windows 11, Windows 10 and Mac

  Bring an offline printer back in the order Microsoft lists: 30-second power cycle, default printer, queue, spooler, reinstall. Mac steps included.

• Remove the Activate Windows Watermark: Legal Fixes by Error Code

  Clear the Activate Windows watermark the legal way: read the Activation page, match your error code, then use a digital license or a 25-character key.

• Slack for Beginners: Channels, Threads and Free Plan Limits

  Slack basics: public vs private channels, threads, shortcuts for Mac and Windows, and the Free plan's 90-day history and 10-app limit.

• SUMIFS Explained: Add Cells That Meet Several Conditions

  SUMIFS syntax with up to 127 criteria pairs, wildcards, a worked example that returns 20, and why it gives 0 or #VALUE! in Excel and Sheets.

• TEXTJOIN vs CONCATENATE vs CONCAT in Excel: What Differs

  TEXTJOIN adds a delimiter and skips blanks; CONCATENATE does neither. Argument limits (252, 253, 255), versions and a 6-cell example.

• UNEXPECTED_STORE_EXCEPTION (0x154): Disk and Driver Checks

  Fix the UNEXPECTED_STORE_EXCEPTION blue screen (bug check 0x154): read Event Viewer, check drive health, run chkdsk, DISM and SFC, then test memory and drivers.

• VIDEO_TDR_FAILURE (0x116): Fix the Graphics Driver Crash

  0x116 means Windows waited 2 seconds for your GPU, failed to reset the driver, and stopped. Read the .sys file name, then update, test RAM and check power.

• VLOOKUP Explained: Syntax, 4 Arguments and Why You Get #N/A

  VLOOKUP has 4 arguments and searches only the first column. See what TRUE and FALSE do, the 255-character limit, and why #N/A, #REF! and #VALUE! appear.

• Wi-Fi Connected but No Internet: Fix It on Windows 11 and Mac

  Find where the fault is in 4 checks: device, router or ISP. Real commands for Windows 11, Mac steps, and DNS addresses 8.8.8.8 and 1.1.1.1.

• Windows Recall Explained: What It Saves and How to Turn It Off

  Recall saves screen snapshots on a Copilot+ PC with 40 TOPS, 16 GB RAM and 256 GB storage. See what it stores, the 25 GB default cap and how to switch it off.

• Windows Update Stuck? Fixes by Stage: Scan, Download, Install

  Find which stage is stuck, then use Microsoft's steps: 20 GB free space, services.msc checks, SoftwareDistribution reset, DISM and SFC, and a safe recovery path.

• XLOOKUP in Excel: Syntax, 6 Arguments, Errors and Example

  XLOOKUP has 3 required and 3 optional arguments. See each one, which Excel versions have it, how it beats VLOOKUP, and how to fix #N/A and #SPILL!.

• Zoom for Beginners: Join, Mute and Know the 40-Minute Limit

  Join a Zoom meeting with no account, learn the Alt+A mute key, and see why a free meeting ends at 40 minutes. Plan limits and prices read 2026-11-01.