Focused practical guides
Tweaknook keeps a focused library of concrete tool-backed checks, technical troubleshooting, spreadsheet and Google Workspace tasks, and product-specific ChatGPT troubleshooting.
Tool-backed checks
Guides that pair a concrete manual workflow with Tweaknook's own browser tools or a reproducible local check. 9 maintained guides.
Missing Frames in an Image Sequence: Check Numbered Files Before Import
Check image-sequence filenames, expected frame ranges, gaps, and application import settings without renaming or losing the original frames.
Web App Shortcut Not Working in Chrome? Diagnose Browser and Extension Conflicts
Find which layer handles a shortcut when it stops working inside Chrome, from built-in browser keys to extension commands and editor focus.
Which Number Is the Sequence? Auditing Filenames with Dates, Versions, and Frame Numbers
Identify the real sequence token when filenames also contain dates, versions, resolutions, or IDs, then review gaps without guessing or automatic renaming.
Single-Key Keyboard Shortcuts: Avoid Accidental Triggers from Speech Input
Review character-only shortcuts for accidental activation, then choose an off switch, modifier-based remap, or focus-only scope using W3C guidance.
Keyboard Shortcut Inventory: Scope, Ownership, and Change History Across Apps
Create a keyboard shortcut inventory across apps and platforms, identify duplicate assignments, document scope and ownership, and keep a recoverable change log.
Missing or Duplicate Filename Numbers: A Safe Sequence Audit
Check numbered filenames for missing values, repeated numbers, padding changes, and pattern outliers before renaming, uploading, or archiving a folder.
Keyboard Shortcut Conflicts: What to Check Before Assigning a Hotkey
Check keyboard shortcut conflicts before assigning a hotkey by comparing browser and system shortcuts, testing context, and using HotkeyRadar safely.
Find Duplicate Files with PowerShell Before Deleting Anything
Use PowerShell and SHA-256 hashes to find files with matching content and export a CSV report for manual review.
Bulk Rename Files with Python: A Preview-First Workflow
Use a beginner-friendly Python script to preview and bulk rename files while preserving extensions and avoiding common name collisions.
Technical troubleshooting
Focused recovery and diagnosis guides for Windows, browsers, networking, backup, remote access, and command-line tasks. 12 maintained guides.
How to Fix Microsoft Store Stuck on Pending in Windows 11
Fix Microsoft Store downloads stuck on Pending in Windows 11 by checking the queue, account, updates, cache, app repair, storage, and device limits.
How to Fix Bluetooth Missing from Windows 11
Restore a missing Bluetooth option in Windows 11 by checking hardware detection, updates, drivers, services, and safe recovery choices.
USB Drive Missing in Windows 11: Diagnose Before Formatting
Fix a USB drive that is missing from File Explorer in Windows 11 by checking Disk Management, drive letters, drivers, and hardware safely.
How to Fix Wi-Fi That Keeps Disconnecting on Windows
Diagnose and fix Wi-Fi that keeps disconnecting on Windows by separating PC, signal, router, and internet-service problems before using advanced resets.
Stop Chrome Notification Spam: Review and Reset Site Permissions
Stop unwanted website notifications in Chrome while keeping useful alerts from calendars, email, and trusted services.
Remote PC Access with Tailscale Without Exposing RDP
Set up Tailscale and Windows Remote Desktop without exposing RDP directly to the public internet. Includes prerequisites and connection checks.
Batch-Install Windows Apps with WinGet
Use a PowerShell loop with WinGet to install several Windows applications and learn how to export and import an app list.
Safer Windows Backups with Robocopy
Create a one-way Windows file backup with Robocopy without using mirror mode, and schedule it with Task Scheduler.
Windows Clipboard History: Paste, Pin, and Clear Multiple Items
Use Windows 11 Clipboard History with Windows+V, pin reusable items, understand its 25-item and 4 MB limits, sync deliberately, and clear sensitive entries.
Chrome Memory Troubleshooting: Find the Tab or Extension Using RAM
Use Chrome Task Manager, Memory Saver, extension review, and tab checks to reduce browser memory pressure without guessing which process is responsible.
How to Free Up Disk Space Safely in Windows
Free up disk space in Windows with Storage settings, Cleanup recommendations, Storage Sense, and a review process that avoids deleting important files.
Recover Deleted Git Commits and Branches with Reflog
Learn how to inspect Git reflog and recover a deleted local branch or commit safely by creating a new rescue branch.
Spreadsheets & workspace
Specific Google Workspace and Excel tasks with source-backed limits, reversible steps, and checks before deletion or automation. 13 maintained guides.
Google Sheets Turning Numbers into Dates: Prevention and Recovery
Stop Google Sheets from converting codes and number-like text into dates by using Plain text, checking locale, repairing cells, and protecting imports.
Stop One Google Drive Folder from Syncing Without Deleting Files
Stop Google Drive for desktop from syncing one folder without losing local or cloud files, and choose the right method for backups, mirroring, or streaming.
Merge Duplicate Google Contacts Without Losing Details
Merge duplicate contacts in Google Contacts safely by exporting a backup, checking accounts, reviewing merge suggestions, and undoing mistakes.
Free Up Gmail Storage Without Deleting Important Mail
Find large Gmail messages, preserve important records, and clear storage safely without confusing archiving with deletion.
Organizing Google Drive Without Breaking Shared Files
Organize Google Drive with practical folders, naming rules, shortcuts, and permission checks without disrupting shared files.
Combine Folder Files with Excel Power Query
Combine similarly structured Excel or CSV files from one folder and refresh the result later with Excel Power Query.
Excel Power Pivot and DAX: Relationships, Measures, and Validation
Load large datasets into Excel Data Model, create relationships, and use DAX measures without placing every row on a worksheet.
Cleaning Messy Spreadsheet Data with Google Sheets Regex
Clean spreadsheet text with Google Sheets REGEXEXTRACT, REGEXREPLACE, and REGEXMATCH while preserving original data and reviewing exceptions.
Email PDF Invoices from Google Sheets
Create PDF invoices from Google Sheets using a Google Docs template and email them as attachments with Apps Script.
Three Gmail Filters for a Cleaner Inbox
Create safer Gmail filters for newsletters, automated notifications, and priority senders by testing search criteria before archiving or forwarding mail.
Repeatable CSV Cleanup in Excel Power Query
Build a repeatable Excel Power Query cleanup for recurring CSV files, then diagnose schema, type, and refresh errors without editing the source blindly.
Google Sheets IMPORTRANGE Dashboards: Setup, Access, and Refresh Limits
Build a Google Sheets IMPORTRANGE dashboard, fix access and loading errors, avoid slow chains, and reduce data exposure before sharing the result.
Excel Lookup Functions: XLOOKUP vs VLOOKUP vs INDEX MATCH
Compare XLOOKUP, VLOOKUP, and INDEX MATCH in Excel, then choose a lookup formula based on compatibility, direction, error handling, and worksheet design.
ChatGPT troubleshooting
Product-specific ChatGPT guides kept only where the problem, settings, limits, and verification steps can be checked against current product documentation. 3 maintained guides.
How to Fix ChatGPT File Upload Not Working or Upload Limit Reached
Fix ChatGPT file upload failures and 'upload limit reached' errors by checking file type, size, storage, account limits, browser issues, and service status.
ChatGPT Keeps Using Old Information: Find the Source and Remove It
Stop old memories, chat history, custom instructions, or project context from influencing new ChatGPT chats, and verify that the cleanup worked.
ChatGPT Study Mode with Notes and PDFs: A Source-First Workflow
Use ChatGPT Study Mode with notes and PDFs through a source-first study loop that builds understanding, tests recall, and verifies important answers.