Blog

A viral meme claims Excel Copilot can’t do basic math. Learn why that conclusion is misleading and how Copilot actually works in Excel.

Create an Excel VBA function to check if a file exists on local drives, network shares, or via URLs, preventing errors in macros.

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.

A practical reflection on AI adoption comparing current AI challenges with lessons learned from past technology transformations.

Learn how to rename SharePoint files using Power Automate and REST API while preserving file IDs, version history, and integrations.

Learn how to set up monthly Power BI semantic model refreshes using a simple Power Automate scheduled cloud flow.

Developing a comprehensive regex for URL matching and spam filtering in PHP. Supports domains, IPs, schemes, Unicode, and edge cases in one flexible pattern.

Step-by-step WordPress .htaccess guide to harden security, block spam, add security headers, and boost performance without plugins.

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.

Build a clean, responsive mobile menu with the HTML Popover API. No JavaScript or checkbox hacks required.

Citizen development promises faster innovation with low-code tools but raises challenges in security, scalability, and long-term maintainability.

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.

Easy steps to test, reuse, securely wipe, or destroy old storage devices to protect your data before recycling or repurposing devices.

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.

No TEXTJOIN? No problem. Use a simple VBA function to concatenate Excel ranges and arrays with control over delimiters and empty cells.

Learn how to count Excel cells based on background color using simple VBA functions. Includes step-by-step instructions, code, and practical examples.

Improve Excel range evaluation using a custom VBA function to trim unused cells and optimize performance with whole-column references.

Create a free, spam-protected contact form for your static website (dedicated server is not required) using Cloudflare Pages, Workers, and Airtable.

Learn three ways to convert month names to numbers in Power Query using if-then-else, Date.FromText, or a custom mapping function.

Learn two methods for aggregating data from multiple tables based on selection criteria in Power Query, using Table.SelectRows and Table.NestedJoin.