Practical guides
Browse every Tweaknook guide by problem area, from file and spreadsheet workflows to AI-assisted work, Windows, browsers, and Google Workspace.
Productivity
15 published guides in this area.
How to Find Missing Files and Duplicate Numbers in a Filename Sequence
Find gaps, repeated numbers, padding changes, and naming outliers in a numbered file sequence before renaming, uploading, or archiving the folder.
How to Stop Google Sheets from Changing Numbers to Dates
Stop Google Sheets from converting codes and number-like text into dates by using Plain text, checking locale, repairing cells, and protecting imports.
How to Stop Google Drive from Syncing a Folder 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.
How to Merge Duplicate Contacts in Google Contacts Without Losing Information
Merge duplicate contacts in Google Contacts safely by exporting a backup, checking accounts, reviewing merge suggestions, and undoing mistakes.
How to Free Up Gmail Storage Without Deleting Important Emails
Find large Gmail messages, preserve important records, and clear storage safely without confusing archiving with deletion.
How to Organize Google Drive Without Disrupting Shared Files
Organize Google Drive with practical folders, naming rules, shortcuts, and permission checks without disrupting shared files.
How to Combine Files from a Folder with Excel Power Query
Combine similarly structured Excel or CSV files from one folder and refresh the result later with Excel Power Query.
How to Analyze Large Excel Data with Power Pivot and DAX
Load large datasets into Excel Data Model, create relationships, and use DAX measures without placing every row on a worksheet.
How to Clean Messy Spreadsheet Data with Google Sheets Regex
Use REGEXEXTRACT and REGEXREPLACE to standardize emails and phone numbers in Google Sheets, then review exceptions.
How to Generate and 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.
How to Organize Gmail with Three Practical Filters
Create three Gmail filters for newsletters, automated notifications, and priority contacts without hiding messages you still need to review.
How to Automate Recurring CSV Cleanup with Excel Power Query
Create a repeatable Power Query workflow for importing, cleaning, and refreshing recurring CSV reports in Excel.
How to Safely Bulk Rename Files with Python
Use a beginner-friendly Python script to preview and bulk rename files while preserving extensions and avoiding common name collisions.
How to Build a Google Sheets Dashboard with IMPORTRANGE
Connect data from another Google Sheets file with IMPORTRANGE, build a simple dashboard, and avoid common access and performance problems.
How to Choose Between XLOOKUP, VLOOKUP, and INDEX MATCH in Excel
Compare XLOOKUP, VLOOKUP, and INDEX MATCH in Excel, then choose a lookup formula based on compatibility, direction, error handling, and worksheet design.
AI Guides
14 published guides in this area.
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.
How to Stop ChatGPT from Using Old Information in New Chats
Stop old memories, chat history, custom instructions, or project context from influencing new ChatGPT chats, and verify that the cleanup worked.
How to Use ChatGPT Study Mode with Your Notes and PDFs
Use ChatGPT Study Mode with notes and PDFs through a source-first study loop that builds understanding, tests recall, and verifies important answers.
How to Compare Two Documents with AI and Verify the Differences
Compare two document versions with AI, locate additions and removals, and verify important differences against the original files.
How to Summarize a YouTube Video with AI Using the Transcript
Use a YouTube transcript and a structured AI prompt to create useful summaries, study notes, and action items while checking key details against the video.
How to Rewrite an Email with AI Without Sharing Private Information
Rewrite emails with AI while protecting names, account details, client information, and other sensitive data before you paste anything into a prompt.
How to Extract PDF Tables into CSV and Verify the Data
Extract tables from a PDF into CSV with OCR or AI-assisted tools, then verify headers, rows, numbers, and source pages before using the data.
How to Draft SQL with AI Without Exposing Production Data
Use a sanitized database schema, read-only access, query limits, and execution-plan review when drafting SQL with AI.
How to Build a Competitor Feature Map with AI
Use public source material and a structured prompt to organize competitor features, evidence, and gaps for manual review.
How to Classify Customer Feedback with AI and Check the Results
Create a customer-feedback classification scheme, test it on a reviewed sample, and use AI to draft sentiment, category, urgency, and action fields.
How to Extract Key Information from Long PDFs with AI
Use a structured prompt to extract dates, obligations, and key points from long PDFs, then verify the results against the original pages.
How to Turn Meeting Transcripts into Action Items with AI
Convert a meeting transcript into decisions, action items, open questions, and follow-up notes while checking owners, dates, and speaker attribution.
A Verification Prompt That Helps Reduce AI Hallucinations
Use source requirements, uncertainty labels, and a verification checklist to reduce unsupported claims in AI-generated work.
How to Write Reusable AI Instructions for Consistent Results
Build reusable AI instructions with a clear task, context, input rules, output format, boundaries, and review checklist.
Tech Tips
15 published guides in this area.
How to Organize Keyboard Shortcuts Across Apps Without Duplicates
Create a cross-application shortcut inventory, separate true duplicates from safe reuse, and maintain scope, ownership, status, and recovery records.
How to Check for Keyboard Shortcut Conflicts Before Assigning a Hotkey
Check keyboard shortcut conflicts before assigning a hotkey by comparing browser and system shortcuts, testing context, and using HotkeyRadar safely.
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.
How to Fix a USB Drive That Is Not Showing Up in Windows 11
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.
How to Stop Website Notification Spam in Chrome
Stop unwanted website notifications in Chrome while keeping useful alerts from calendars, email, and trusted services.
How to Find Duplicate Files with PowerShell and Export a Report
Use PowerShell and SHA-256 hashes to find files with matching content and export a CSV report for manual review.
How to Access Your PC Remotely with Tailscale
Set up Tailscale and Windows Remote Desktop without exposing RDP directly to the public internet. Includes prerequisites and connection checks.
How to Install Multiple 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.
How to Create a Safer One-Way Backup with Robocopy
Create a one-way Windows file backup with Robocopy without using mirror mode, and schedule it with Task Scheduler.
How to Use Windows Clipboard History to Paste Multiple Items
Enable Windows clipboard history, paste previous text and images with Windows key plus V, and manage pinned or sensitive items safely.
How to Find What Is Using Memory in Chrome and Reduce It
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.
How to Recover a Deleted Git Commit or Branch with Reflog
Learn how to inspect Git reflog and recover a deleted local branch or commit safely by creating a new rescue branch.