Blog

• Power Query: Load Excel Data from Local, Web, or Current Workbook

  Learn how to load Excel data into Power Query from a local file, SharePoint, or the current workbook, covering worksheets, tables, and defined names.

• Excel Multi-Criteria Lookup Guide

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

• How to Create a Multi-Resolution favicon.ico File

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

• How to Add Math Equations to Astro with KaTeX

  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.

• Java Permutation Generator: Partial and Full Strings

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

• Combine Multiple Tables for Clustered Charts in Power BI

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

• Manual WordPress Database Cleanup Using SQL Without Plugins

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

• Indexed by Microsoft Bing but Missing from Search Results

  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.

• 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.