Blog

Learn how to perform Excel multi-criteria lookups with SUMPRODUCT, INDEX with MATCH, and XLOOKUP. Step-by-step examples included.

Learn how to create a multi-resolution favicon.ico file using Inkscape and ImageMagick so it displays correctly in browsers and search results.

Learn how to add math equations to your Astro site using KaTeX. Step-by-step setup, Markdown examples, and styling options for fast static sites.

Learn how to generate partial and full string permutations in Java using an efficient, duplicate-safe, iterative approach. Includes examples and performance tips.

Step-by-step guide to combining multiple tables in Power BI using DAX or Power Query to build clustered column charts.

Manually clean and optimize your WordPress database using SQL instead of plugins. Reduce bloat, regain control, and improve performance.

Case study of a website indexed by Bing, yet it does not appear in search results. This post documents what happened and how I tried to correct it.

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.