Blog
Why Excel Copilot Gets Math Wrong
A viral meme claims Excel Copilot can’t do basic math. Learn why that conclusion is misleading and how Copilot actually works in Excel.
How to Check If a File Exists Using Excel VBA
Create an Excel VBA function to check if a file exists on local drives, network shares, or via URLs, preventing errors in macros.
How to Check If an Excel File Is Open Using Excel VBA
Learn how to check if an Excel file is already open using VBA to prevent runtime errors, protect data, and build more reliable Excel macros.
What AI Adoption Reminds Me of Past IT Transformations
A practical reflection on AI adoption comparing current AI challenges with lessons learned from past technology transformations.
Rename SharePoint Files in Power Automate Using REST API
Learn how to rename SharePoint files using Power Automate and REST API while preserving file IDs, version history, and integrations.
Schedule Monthly Power BI Refreshes Using Power Automate
Learn how to set up monthly Power BI semantic model refreshes using a simple Power Automate scheduled cloud flow.
Comprehensive Regex for URL Detection and Spam Filtering
Developing a comprehensive regex for URL matching and spam filtering in PHP. Supports domains, IPs, schemes, Unicode, and edge cases in one flexible pattern.
Harden WordPress Security Using Custom .htaccess Files
Step-by-step WordPress .htaccess guide to harden security, block spam, add security headers, and boost performance without plugins.
Windows 10 End of Support: Forced Obsolescence
Windows 10 ends support in 2025, but my self-built 2012 PC still runs perfectly. Why Microsoft says it is obsolete and the tough choices I face next.
Create a Mobile Menu with the Popover API and No JavaScript
Build a clean, responsive mobile menu with the HTML Popover API. No JavaScript or checkbox hacks required.
Citizen Development: DIY Applications Without Writing Code
Citizen development promises faster innovation with low-code tools but raises challenges in security, scalability, and long-term maintainability.
Power Query: Check If Text Starts with a Capital Letter
How to check if a string starts with a capital letter in Power Query using a simple custom M function. Includes step-by-step instructions and test examples.
Simple Methods to Safely Wipe, Reuse, or Destroy Old Storage Devices
Easy steps to test, reuse, securely wipe, or destroy old storage devices to protect your data before recycling or repurposing devices.
Power Query: Check If Text Value is Alphabetic Only
Two simple ways to check if text contains only alphabetic characters in Power Query using a custom function or Text.Select with if-then-else.
Concatenate Excel Ranges Without TEXTJOIN Using VBA Code
No TEXTJOIN? No problem. Use a simple VBA function to concatenate Excel ranges and arrays with control over delimiters and empty cells.
How to Count Cells by Background Color in Excel with VBA
Learn how to count Excel cells based on background color using simple VBA functions. Includes step-by-step instructions, code, and practical examples.
Excel VBA: Improve Excel Range Evaluation by Trimming Unused Cells
Improve Excel range evaluation using a custom VBA function to trim unused cells and optimize performance with whole-column references.
Contact Form for Static Sites Using Cloudflare Workers and Airtable
Create a free, spam-protected contact form for your static website (dedicated server is not required) using Cloudflare Pages, Workers, and Airtable.
Converting Month Names to Numbers in Power Query
Learn three ways to convert month names to numbers in Power Query using if-then-else, Date.FromText, or a custom mapping function.
Power Query: Conditionally Aggregate Data from Multiple Tables
Learn two methods for aggregating data from multiple tables based on selection criteria in Power Query, using Table.SelectRows and Table.NestedJoin.