Quick Tweaks for Smarter Workflows
Welcome to Tweaknook. We deliver concise, text-based guides on IT automation, advanced AI prompting techniques, and essential tech tips designed to save your time and eliminate office friction.
Productivity
-
Why I Stopped Using VLOOKUP (And What I Use Instead to Prevent Excel Crashes)
While VLOOKUP is a staple in data analysis, its left-to-right limitation can cause critical errors. Discover how combining INDEX and MATCH creates a dynamic, unbreakable formula for complex spreadsheets.
AI Guides
-
My AI Prompts Kept Failing. Here's the 1 Tweak That Fixed Them
Stop writing the same instructions repeatedly. Learn how to craft robust system prompts that define an AI's persona, output format, and constraints to generate consistent, professional results every time.
Tech Tips
-
New tech tips coming soon.